Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
tommyl
Creator
Creator

Custom variables for date filtering

Hello,

I am trying to create a date filter with "Enrolment Start Date" and "Enrolment end dates".

I created two variables in load editor: 

let filterStart = '01.01.1900';
let filterEnd = Today();

And use these as a dimension in the filter panes ( as Start Filter and End Filter)

And wrote a set expression for the chart measure, like:

=Only({$<enrolmentDate>=Date(Date#([$(filterStart)],'DD.MM.YYYY','DD.MM.YYYY') , enrolmentDate<=Date(Date#([$(filterEnd)],'DD.MM.YYYY','DD.MM.YYYY')>}(Count(memberId)/Count(total{1}memberId)))

 

It shows nothing. Could you please help me?

 

Regards,

 

 

 

 

Labels (1)
2 Replies
Nishanthi
Contributor II
Contributor II

What is the desired output from you ? Could  you please brief out

tommyl
Creator
Creator
Author

Hi,

To add date filter to the dashboard for enrolment date. Range picker xtension didnt satisfy the need. 

Regards,