topic Re: Not able to filter the data in QlikView

Not able to filter the data

Tue, 14 May 2013 05:52:23 GMT

=if(PROGRAM_ID <> if(EVT_DATE <= '4/30/2013' and EVT_DATE >='4/1/2013',PROGRAM_ID),PROGRAM_ID)

in the above expression i want to filter the program id where transaction has not taken place in last month.. please someone help its urgent.

Gysbert_Wassenaar — Tue, 14 May 2013 05:59:13 GMT

Try: if(EVT_DATE EVT_DATE <=date#('4/1/2013','M/D/YYYY') or >= date#('4/30/2013','M/D/YYY') ,PROGRAM_ID)

Tue, 14 May 2013 06:03:04 GMT

thanks for the reply Gysbert Wassenaar, but i am not able to filter the data its giving all program id s

er_mohit — Tue, 14 May 2013 06:24:29 GMT

Try this

sum(PROGRAM_ID -= P({<EVT_DATE ={">=4/1/2013 <=4/30/2013"}>}PROGRAM_ID)>}PROGRAM_ID)

its not giving error you jst check ur expression is ok

because we use in set analysis -= then it show under line not error

by my mistake i don't write that

acc . to vishwaranjan so please you ll write that so that, vishwaranjan will be happy to see this syntax actully works

Tue, 14 May 2013 06:33:04 GMT

this expression looks good, but giving error near that -=

Tue, 14 May 2013 07:19:47 GMT

thnaks man er.mohit ur expression is working insted of sum i took count its working thnaks a lot .

er_mohit — Tue, 14 May 2013 07:28:36 GMT

Thumsup

To closed this thread you have to make it either correct or helpful because it might be helpful for other users

Regards

Mohit