Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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.

5 Replies
Anil_Babu_Samineni

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

For Ref, PFA

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Not applicable
Author

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vinieme12
Champion II
Champion II

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

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

kanchandendge
Contributor II
Contributor II

this might work in expressions or by setting a variable

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