Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!!
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.
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