topic Compare Previous Expression in QlikView

Compare Previous Expression

Wed, 19 Dec 2012 12:22:28 GMT

Hi Guys,

I need to arrive at the total count of the values based on the previous expression.

Attached is the sample Excel & the Desired output as well.

Can some1 help me in this

Rgds,

srini

Gysbert_Wassenaar — Wed, 19 Dec 2012 12:40:23 GMT

Try: if(amt>=20,count({<amt={'>=20'}>} total amt),0)

See attached qvw

Wed, 19 Dec 2012 12:42:53 GMT

BINGO 🙂

Wed, 19 Dec 2012 13:05:16 GMT

just one help,

is it possible to count the same no of rows, if the second Expression ("Yes/No") = 'Yes' as per my excel.

i.e, can i get output something based on below

Column(2) = if(amt>=20,'Yes','No')

count(if(column(2)='Yes', count(rowno()))

Rgds,

srini

Thu, 20 Dec 2012 04:47:59 GMT

Hi,

i have done it @ Script itself..

Rgds,

srini