Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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

Re: Qlik Sense date calculated dimension filter pane

Try

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

nlr-biin_soluti
New Contributor III

Re: Qlik Sense date calculated dimension filter pane

Hi Girirajsinh,

I already tried and it doesn't work neither.

Nicolas

girirajsinh
Contributor III

Re: Qlik Sense date calculated dimension filter pane

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

MVP
MVP

Re: Qlik Sense date calculated dimension filter pane

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

Re: Qlik Sense date calculated dimension filter pane

Hello Girirajsinh,

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

Do you have any other idea?

Nicolas

nlr-biin_soluti
New Contributor III

Re: Qlik Sense date calculated dimension filter pane

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

Re: Qlik Sense date calculated dimension filter pane

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
Contributor III

Re: Qlik Sense date calculated dimension filter pane

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

Re: Qlik Sense date calculated dimension filter pane

Hello Sunny,

It doesn't work.

I obtain an empty filter:

Empty filter.PNG

Any other idea?

Nicolas