topic Re: Bar chart Help in App Development

Bar chart Help

Saif1 — Wed, 19 Oct 2022 06:23:21 GMT

Hello QLikers,

i have a sample data :

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.

justISO — Wed, 19 Oct 2022 06:38:36 GMT

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:

Saif1 — Wed, 19 Oct 2022 06:57:01 GMT

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.