Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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.

View solution in original post

5 Replies
Highlighted
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.

View solution in original post

Highlighted
MVP & Luminary
MVP & Luminary

Re: Chart depending on "if then" date comparison

Hi,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted

Re: Chart depending on "if then" date comparison

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

Highlighted

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Chart depending on "if then" date comparison

Please mark the post as answered.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".