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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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