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: 
nlr-biin_soluti
Partner - Contributor III
Partner - Contributor III

Qlik Sense date calculated dimension filter pane

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

15 Replies
girirajsinh
Creator III
Creator III

Try

if([User Date]>=Date(Min([Order Confirmed Date]),'DD/MM/YYYY'),[User Date])

nlr-biin_soluti
Partner - Contributor III
Partner - Contributor III
Author

Hi Girirajsinh,

I already tried and it doesn't work neither.

Nicolas

girirajsinh
Creator III
Creator III

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

jonathandienst
Partner - Champion III
Partner - Champion III

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?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
nlr-biin_soluti
Partner - Contributor III
Partner - Contributor III
Author

Hello Girirajsinh,

I don't know why but it doesn't work neither.

Do you have any other idea?

Nicolas

nlr-biin_soluti
Partner - Contributor III
Partner - Contributor III
Author

Hello Jonathan,

If I put =Min([Order Confirmed Date]) in a text box it gives me the correct date:

Min date in TextBox.PNG

Do you have any idea why it doesn't work when I put it in a calculated dimension in a filter pane?

Nicolas

sunny_talwar

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])

girirajsinh
Creator III
Creator III

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))

nlr-biin_soluti
Partner - Contributor III
Partner - Contributor III
Author

Hello Sunny,

It doesn't work.

I obtain an empty filter:

Empty filter.PNG

Any other idea?

Nicolas