topic Filter Condition in QlikView

Filter Condition

Mon, 14 Sep 2015 18:07:59 GMT

Hi,

I need to handle the below filter condition so that data gets refreshed in a single click.

= '=TEST_CASE_STATUS=' & chr(39) & 'Testing Evidence' & chr(39) & 'AND TEST_EXPIRATION_DT1=' & TIMESTAMP(TODAY())

Right now, I have mentioned this in Button but as there is no data that matches this filter condition, nothing happens when the button is clicked and the whole data set appears; ideally no data should be listed as nothing fits in this filter condition. Please let me know if there is any other way to specify this condition. (Please check the syntax too)

Thanks,

Sudha.

Re: Filter Condition

robert_mika — Mon, 14 Sep 2015 19:13:58 GMT

Could you share your app?

Re: Filter Condition

Mon, 14 Sep 2015 19:20:28 GMT

Sorry, I can't find an option to attach here...

Here is the snapshot -

Here if I click on Test button, nothing should be displayed because my data does not have 'E'; instead, nothing happens when the button is clicked and all data still appears. Hope this helps.

Re: Filter Condition

MarcoWedel — Mon, 14 Sep 2015 21:27:39 GMT

Hi,

one solution could be:

='=TEST_CASE_STATUS = ''Testing Evidence'' and TEST_EXPIRATION_DT1 = TODAY()'

hope this helps

regards

Marco