Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Chart depending on "if then" date comparison

I would like to show depending on a date comparison a donut chart. The followin expression gives me a bogus result:

f((Date#(today(1),'DD.MM.YYYY')=>[DueDate]),Count([ActionPointID]))

For a bar chart I used the following exspression, which does work just fine with the same data:

if((Date#(today(1),'DD.MM.YYYY')>=[DueDate]),MonthName(Date#([DueDate],'DD.MM.YYYY')))

What do I miss?

Thank you

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Chart depending on "if then" date comparison

Just got it fixed:

Count(if((Date#(today(1),'DD.MM.YYYY')>=[DueDate]),[ActionPointID]))

The Count() statement needs to wrap everything.

5 Replies
Not applicable

Re: Chart depending on "if then" date comparison

Just got it fixed:

Count(if((Date#(today(1),'DD.MM.YYYY')>=[DueDate]),[ActionPointID]))

The Count() statement needs to wrap everything.

Re: Chart depending on "if then" date comparison

Hi,

Check the sign '=>' it should be  '>=' instead of '=>'

Regards,

Kaushik Solanki

MVP
MVP

Re: Chart depending on "if then" date comparison

Do you have a sample you can share? Not sure I understand what the issue is?

MVP
MVP

Re: Chart depending on "if then" date comparison

In this case, I would suggest using set analysis:

Count({<DueDate = {"$(='<=' & Date(Today(1), 'DD.MM.YYYY'))"}>} [ActionPointID]))

Re: Chart depending on "if then" date comparison

Please mark the post as answered.

Regards,

Kaushik Solanki

Community Browser