topic Re: Qlik Sense date calculated dimension filter pane in App Development

Qlik Sense date calculated dimension filter pane

nlr-biin_soluti — Fri, 20 Jan 2017 04:50:29 GMT

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

Re: Qlik Sense date calculated dimension filter pane

girirajsinh — Fri, 20 Jan 2017 05:47:37 GMT

Try

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

Re: Qlik Sense date calculated dimension filter pane

nlr-biin_soluti — Fri, 20 Jan 2017 05:54:49 GMT

Hi Girirajsinh,

I already tried and it doesn't work neither.

Nicolas

Re: Qlik Sense date calculated dimension filter pane

girirajsinh — Fri, 20 Jan 2017 07:44:46 GMT

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

Re: Qlik Sense date calculated dimension filter pane

jonathandienst — Fri, 20 Jan 2017 09:30:38 GMT

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?

Re: Qlik Sense date calculated dimension filter pane

nlr-biin_soluti — Fri, 20 Jan 2017 15:23:16 GMT

Hello Girirajsinh,

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

Do you have any other idea?

Nicolas

Re: Qlik Sense date calculated dimension filter pane

nlr-biin_soluti — Fri, 20 Jan 2017 15:26:04 GMT

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

Re: Qlik Sense date calculated dimension filter pane

sunny_talwar — Fri, 20 Jan 2017 15:35:53 GMT

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

Re: Qlik Sense date calculated dimension filter pane

girirajsinh — Fri, 20 Jan 2017 15:38:34 GMT

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

Re: Qlik Sense date calculated dimension filter pane

nlr-biin_soluti — Fri, 20 Jan 2017 15:42:13 GMT

Hello Sunny,

It doesn't work.

I obtain an empty filter:

Any other idea?

Nicolas

Re: Qlik Sense date calculated dimension filter pane

sunny_talwar — Fri, 20 Jan 2017 15:46:13 GMT

How about this:

Aggr(If([User Date]>=Min(TOTAL [Order Confirmed Date]), [User Date]), [User Date])

Aggr(If([User Date]>=Min(TOTAL [Order Confirmed Date]), [User Date]), [User Date], [Order Confirmed Date])

Re: Qlik Sense date calculated dimension filter pane

nlr-biin_soluti — Fri, 20 Jan 2017 15:54:10 GMT

Hello again Sunny,

It is really weird because when I put it in a table it works, but in a filter pane it seems emply.

and if I click on "..." and select all, it selects me 42 values

but it doesn't display it.

If I make it bigger like a list it works...

So maybe it is related to my Qlik Sense version?

Nicolas

Re: Qlik Sense date calculated dimension filter pane

girirajsinh — Fri, 20 Jan 2017 15:56:02 GMT

Try

Date(Aggr(max({<[User Date]={">=$(=Min(Date(Date#([Order Confirmed Date],'DD/MM/YYYY'),'DD/MM/YYYY')))"}>}[User Date]), [User Date]))

Re: Qlik Sense date calculated dimension filter pane

sunny_talwar — Fri, 20 Jan 2017 15:57:34 GMT

That makes complete sense... I have heard some issues with calculated dimensions in filter pane....

Re: Qlik Sense date calculated dimension filter pane

nlr-biin_soluti — Fri, 20 Jan 2017 16:14:43 GMT

Hi Girirajsinh,

See my answer to Sunny.

It seems like a bug because when I make the filter pane bigger it works and when i put it like a listbox it doesn't.

I am going to try with another version of Qlik Sense desktop.

I am currently using Qlik Sense Desktop 3.1 SR4 (qliksensedesktop: 10.7.3)

Nicolas

Re: Qlik Sense date calculated dimension filter pane

nlr-biin_soluti — Fri, 20 Jan 2017 16:19:06 GMT

I am going to try with another version of Qlik Sense desktop.

I am currently using Qlik Sense Desktop 3.1 SR4 (qliksensedesktop: 10.7.3)

I'll keep you informed of the result as soon as possible.

Nicolas