Triggers - actions: select from date & exclude dat... - Qlik Community

Report Inappropriate Content · ‎2017-03-15

Hello all,

I have go a sheet in my application where a want to show tables and graphs from a certain date (01/11/2016).

I managed to do this with Onectivate Sheet - Action : select in field.

='>=' & Date

This gives me the tables and graphs for the period I want.

In the data however is one particular date (31/01/2017) that I want to exclude from this sheet.

Is there any way I can integrate this in the trigger?

Thx.

Anil_Babu_Samineni · ‎2017-03-15

We have On Activate Sheet with Select in Field and then Select Excluded option

For Ref, PFA

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Report Inappropriate Content · ‎2017-03-15

I tried that but Ididn't seem to work.

Can you write the solution in text because I am on personal edition for the moment and I cannot open your qvw.

Anil_Babu_Samineni · ‎2017-03-15

Can you describe more, And try to add application. Then tell me what you are doing over there. So that, I can paste on wall. It would better to move

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vinieme12 · ‎2017-03-15

After the Action to Select dates ='>=' & Date add another action

Select in Field > Toggle Select : Add field name and string as the date

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

Anonymous · ‎2017-03-15

this might work in expressions or by setting a variable

=Only({<DATE-={'(31/01/2017'}>}DATE)

Triggers - actions: select from date & exclude date in selection