Qlik Sense date calculated dimension filter pane

[nlr-biin_soluti]

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

[girirajsinh]

Try

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

[nlr-biin_soluti]

Hi Girirajsinh,

I already tried and it doesn't work neither.

Nicolas

[girirajsinh]

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]

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?

[nlr-biin_soluti]

Hello Girirajsinh,

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

Do you have any other idea?

Nicolas

[nlr-biin_soluti]

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

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

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]

Hello Sunny,

It doesn't work.

I obtain an empty filter:

Any other idea?

Nicolas