Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to create a filter pane with a date calculated dimension in Qlik Sense based on another date field and I have an issue.
When I put if([User Date]>='27/10/2016',[User Date]) it works, but when I put if([User Date]>=Min([Order Confirmed Date]),[User Date]) it doesn't.
Anyone could help me to figure out why?
Thanks in advance for your help.
Best regards,
Nicolas
Try
if([User Date]>=Date(Min([Order Confirmed Date]),'DD/MM/YYYY'),[User Date])
Hi Girirajsinh,
I already tried and it doesn't work neither.
Nicolas
HI Nicolas
In Filter pane put below as expression
Date(Aggr(max({<DateOut={">=$(=Min(DateIn))"}>}DateOut), DateOut))
Replace DateOut with your "User Date"
and
DateIn with "User Confirmed Date"
I hope that would help
What do you get if you put =Min([Order Confirmed Date]) in a text box?
Is ([User Date] a text field, or a numeric date field?
Hello Girirajsinh,
I don't know why but it doesn't work neither.
Do you have any other idea?
Nicolas
Hello Jonathan,
If I put =Min([Order Confirmed Date]) in a text box it gives me the correct date:
Do you have any idea why it doesn't work when I put it in a calculated dimension in a filter pane?
Nicolas
This is a calculated dimension, you will need to use TOTAL qualifier here.... Try this
If([User Date]>=Min(TOTAL [Order Confirmed Date]), [User Date])
Hi Nicolas
Then I guess you are not having Text and not Date.
Try to convert it to Date value.
Put below in place of DateIn.
Date(Date#(DateIn,'DD/MM/YYYY'),'DD/MM/YYYY')
Date(Aggr(max({<DateOut={">=$(=Min(DateIn))"}>}DateOut), DateOut))
Thus it would be like
Date(Aggr(max({<DateOut={">=$(=Min(Date(Date#(DateIn,'DD/MM/YYYY'),'DD/MM/YYYY')))"}>}DateOut), DateOut))
Hello Sunny,
It doesn't work.
I obtain an empty filter:
Any other idea?
Nicolas