Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Not able to filter the data

=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.

1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: Not able to filter the data

Thumsup

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

Regards

Mohit

6 Replies

Re: Not able to filter the data

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



talk is cheap, supply exceeds demand
Not applicable

Re: Not able to filter the data

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

er_mohit
Honored Contributor II

Re: Not able to filter the data

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


Not applicable

Re: Not able to filter the data

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

Not applicable

Re: Not able to filter the data

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

er_mohit
Honored Contributor II

Re: Not able to filter the data

Thumsup

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

Regards

Mohit

Community Browser