Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

StraightTable Field

Hai,

can anyone explain me to get 4th row of values from a 1st field in table . I need this in expression of straight table.

Thnks

6 Replies
Not applicable
Author

Hi,

there is a function called FieldValue that you can use to get the n value from a field but the only drawback it works based on the load order.

Not applicable
Author

Hi satish:

Could you explain me your question? Do you need top 4 rows in your table or only the value in the 4th value row? Could send me an example

Thanks.

Not applicable
Author

sorry for late reply by me.

Hai Amaury,

I need only the value in 4 th value row.

Thnks

Not applicable
Author

thanks for your reply

i need which is to count the value of that particular row.

ex:

Id Defectname

1 bug(20)

hole(30)

edge(40)

2 bug(120)

hole(130)

edge(140)

so on....

( ) ---> bugs count is 20, hole count is 30 , edge count is 40

Now i required is when i click id=1, 2,.. then should display only hole and its count.

ex:

Id hole

1 20

2 120

I need exactly this way. Can you provide an expression for this StraightTable.

Thnks

Not applicable
Author

Hi satish,

I didn't understand what you need. Do you want to count the number of times a value exists? Could you explain a little more if the bug count is a value or is it the result of a count?

Regards

vgutkovsky
Master II
Master II

Satish, please try to not duplicate posts in the future: http://community.qlik.com/forums/t/40447.aspx