Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello QLikers,
i have a sample data :
Emp num | Category | Mark | Score |
1 | One | Wanted | 40 |
1 | One | Actual | 20 |
1 | Two | Wanted | 25 |
1 | TWo | Actual | 0 |
1 | Three | Wanted | 25 |
1 | Three | Actual | 10 |
1 | Four | Wanted | 10 |
1 | Four | Actual | 15 |
2 | One | Wanted | 40 |
2 | One | Actual | 25 |
2 | Two | Wanted | 25 |
2 | Two | Actual | 20 |
2 | Three | Wanted | 25 |
2 | Three | Actual | 25 |
2 | Four | Wanted | 10 |
2 | Four | Actual | 10 |
I want to show the AVG of (actual) in a bar chart with grouped category, i did it but when i take the AVG(SCORE)
it gives me the avg for both wanted and actual score, i want to make the wanted as a static bar (for referencing) and the actual as AVG
something like this ( A = one , B = two , etc.....) , excuse my drawing XD,
any help ? thanks.
Hi, I believe you need to create 2 different measures, one just for Wanted, other for Actual. This can be done like this:
avg({<Mark={'Wanted'}>}Score)
avg({<Mark={'Actual'}>}Score)
so your chart should look like this:
Hi, I believe you need to create 2 different measures, one just for Wanted, other for Actual. This can be done like this:
avg({<Mark={'Wanted'}>}Score)
avg({<Mark={'Actual'}>}Score)
so your chart should look like this:
It worked , weird enough that the first time it did not give me an option to add 2 measures, then i took max(actual values) to achieve what I wanted.
Thank you so much.