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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
New-here1
Contributor III
Contributor III

2 measures showing same value in bar chart

Hello,

I have a bar chart which has 1 dimension and 3 measures; the dimension is name and the 3 measures are late on arrival, on time and early

The bar chart is to show a count of how jobs are late on arrival, are on time and are early per person selected

I have these calculation:

Late - Count(if([Todays Date]>'0', [Todays Date]))

On time - count(if([Todays Date]<='0' or [Todays Date] >='-14', [Todays Date]))

Early - count(if([Todays Date] <'-14', [Todays Date]))

When checking the bars, the late and on time measures are showing the same. Im sure I have missed something and have been looking at this for too long so it is likely very obvious. 

Thank you in advance for your help

Labels (5)
1 Solution

Accepted Solutions
G3S
Creator III
Creator III

On time should be AND .. not OR.

On time - count(if([Todays Date]<='0' AND [Todays Date] >='-14', [Todays Date]))

View solution in original post

2 Replies
G3S
Creator III
Creator III

On time should be AND .. not OR.

On time - count(if([Todays Date]<='0' AND [Todays Date] >='-14', [Todays Date]))

New-here1
Contributor III
Contributor III
Author

That worked a treat - so simple as well. Thank you so much