topic StraightTable Field in QlikView

StraightTable Field

Fri, 04 Feb 2011 17:10:28 GMT

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

StraightTable Field

Fri, 04 Feb 2011 17:40:05 GMT

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.

StraightTable Field

Fri, 04 Feb 2011 17:51:37 GMT

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.

StraightTable Field

Fri, 04 Feb 2011 18:07:42 GMT

sorry for late reply by me.

Hai Amaury,

I need only the value in 4 th value row.

Thnks

StraightTable Field

Fri, 04 Feb 2011 18:20:23 GMT

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

StraightTable Field

Fri, 04 Feb 2011 18:38:50 GMT

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

StraightTable Field

vgutkovsky — Fri, 04 Feb 2011 19:02:34 GMT

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