Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

A simple question?

Hi all

Consider this table:

Capture.PNG

The expression behind the 0-20 -> 80-100 colums looks like this:

if

(sum({$<EmpAvd=>}if(mixmatch([Activity No.],1000,1099)> 0 and mixmatch([Activity Type], 'Time') > 0,[Registered Quantity])) /

sum({$<EmpAvd=>}if(mixmatch([Activity No.],1000,1099,1100,1200,9000,9010,9011,9100,9600)> 0 and mixmatch([Activity Type], 'Time') > 0,[Registered Quantity]))

>=.2

AND

sum({$<EmpAvd=>}if(mixmatch([Activity No.],1000,1099)> 0 and mixmatch([Activity Type], 'Time') > 0,[Registered Quantity])) /

sum({$<EmpAvd=>}if(mixmatch([Activity No.],1000,1099,1100,1200,9000,9010,9011,9100,9600)> 0 and mixmatch([Activity Type], 'Time') > 0,[Registered Quantity]))

<.4,
count(DISTINCT [Employee No.]))

My challange is that I need to present this as a bar chart, presenting the sum of all counts in the 0-20, 20-40, 40-60, 60-80, 80-100 colums.

What is the easiest way to accomplish that?

Best regards

Trond E

0 Replies