topic More than one Expression on Y Axis in QlikView

More than one Expression on Y Axis

peterderrington — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Not sure if this can be done, it seems a simple ask but i don't seem to be able to find a way of doing it.

I have a Combo graph that shows in the bars the number of times something happens. On the Y axis i show how often a particular client achieves this (as a percentage).

What i would like to be able to do is to show a second (and then possibly a third or more) Y Axis expression so that we can see the comparison between one client and the next.

Any ideas?

Thanks

Re: More than one Expression on Y Axis

Anil_Babu_Samineni — Mon, 17 Sep 2018 14:11:54 GMT

Can you share sample application. We can split axis into Right and Left Axis...

Re: More than one Expression on Y Axis

peterderrington — Mon, 17 Sep 2018 14:27:24 GMT

The Axis is already split into Right and Left.

From this image you can see that Location 1 compliance doesn't show at all.

Re: More than one Expression on Y Axis

Anil_Babu_Samineni — Mon, 17 Sep 2018 14:29:50 GMT

Will you change that to straight table and seen how values are returning?

Re: More than one Expression on Y Axis

peterderrington — Mon, 17 Sep 2018 14:38:38 GMT

Re: More than one Expression on Y Axis

peterderrington — Tue, 18 Sep 2018 10:40:28 GMT

For some reason the calculation for location 1 and 2 is showing the same answer even though the amounts are different.

If i use the selection tool to only display location 1 or 2 then it shows the correct figures for that specific location (and not the other) but i want this graph to be independent of the selection tool (as i want to be able to show the comparison between locations).

Any ideas?

Re: More than one Expression on Y Axis

Anil_Babu_Samineni — Tue, 18 Sep 2018 11:15:36 GMT

It is very difficult to say this? Can you supply input data to get as idea?

Re: More than one Expression on Y Axis

peterderrington — Tue, 18 Sep 2018 11:28:37 GMT

unfortunately i cant really supply the input data.

However i think i have almost sorted it.

I used the expression:

Count({<Location={'Location 1'},[Questions Complete]={'Yes'}>}Location)

And that is now showing the correct numbers however when i try to divide by the date /Count ([PAS Date]) in order to get the percentage it shows an incorrect figure.

I'm guessing i may need a DISTINCT or similar marker on my /Count ([PAS Date]) section of the expression

Re: More than one Expression on Y Axis

peterderrington — Tue, 18 Sep 2018 11:37:55 GMT

Sorted.

Used this as my expression and it now works perfectly.

Count({<Location={'Location 1'},[Questions Complete]={'Yes'}>}Location)/Count({<Location={'Location 1'}>}Location)

Thanks for all the help.

Cheers