Skip to main content
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

variable declaration for comparison of no. of days


Here I want when the user will select an event like Diwali the corresponding date will be displayed in the field like below shown in image


now I want when user enters DaysofComp (as shown in fig) as -10 so the sale for (selected date -10 ) should be displayed ,

similarly if user enters daysofcomp as +20 so the sale for (selected date +20 ) should be displayed

Please help how to declare a variable (I need to make that variable flexible so that I can compare any values )

1 Reply
Contributor III
Contributor III

Hi Sakshi.

Please try the following:

Add a Variable event trigger

               To do this, go to document settings

               Triggers tab

               At the bottom, highlight the DaysOfComp variable

               OnChange - Add action

Select in Field


                    Action Type: Selection

                    Action: Select in Field

                    Field: *Your Date Field*

                    Search String:

                                   =Date+ $(DaysOfComp)

Hope this helps