Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Akshaya45
Contributor II
Contributor II

Date Range in Filter Pane using Min and Max Variables

Hi Friends,

Please help me foe below requirements, I ma new in qliksense

i need to pass minimum and  maximum values in the Date filter Pane. How to write the expression 

Example -  I have created Vmin and VMax variables and i want to pass these variables in my date filter pane.

it means , if any  one will select any month , this filter will reflect only the above date range using the variables.

 

Kindly help !!!

 

2 Replies
bkilicli
Partner - Contributor III
Partner - Contributor III

Hi,

You can use set analysis in filter pane object, just use AGGR function to convert dimension. Or you can use  the following code block.

 

=Aggr(Only({< numdate = {">=$(=vMin)<=$(=vMax)"} >}Date),Date)

Also, I add attachment. You can find .qvf and .xlsx files for sample.

 

Akshaya45
Contributor II
Contributor II
Author

Hi , Thank you so much for your Input,

but my scenario is , Let say i have to different date field Date1 and Date2 which is not linked in the model,

if i want to select any date from date1 the in date2 will reflect last 12 month rolling.

I am not getting any solution , please help me out.

 

Regards,

Akshaya