Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
FerdiSisko
Partner - Contributor II
Partner - Contributor II

Date Calculation Fails in Chart Expression to Filter Dimension

I have a strange issue. When I use a text chart object, I am able to calculate the difference between two dates:

Max(WarrantyDate) - Min(WarrantyDate): 11/10/2020 - 11/08/2020  = 2

However, when I try the same thing for a chart table dimension filter, it doesn't work:

If(Num(Max(WarrantyDate) - Min(WarrantyDate)) = [Number Warranty Days],  [Number Warranty Days])

The subtraction to determine the date difference doesn't work.  I have tried using a variable to store the difference and reference it but while it works for displaying the result in a text object, it also is useless in a chart expression.

 

0 Replies