Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Variables to drive charts

Hello Experts,

I have a dates to variables question. I have date Dimension field called History_Date in the format of DD/MM/YYYY. I want to create 2 variables History_Date_From and History_Date_To, so that a end user makes a selection of 2 dates, then the chart should calculate the sum(sales). Earlier I have done something similar using AutoGenerate function for just weeks... but here its a full date format, so a bit confused as to how to do it.

Any suggestions are welcom and Thanks in advance

Mady

10 Replies
magavi_framsteg
Partner - Creator III
Partner - Creator III

Hi again.

Usually when I want to do this, I create a button with a series of actions:

- 1. Clear all or clear certain fields

- 2. set variable vFromDate = (blank)

- 3. set variable vToDate = (blank)

- 4. some other action