Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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