Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Akshaya45
New 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
Highlighted
Partner
Partner

Re: Date Range in Filter Pane using Min and Max Variables

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
New Contributor II

Re: Date Range in Filter Pane using Min and Max Variables

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