topic Re: Showing all possible values in bar chart in QlikView

Showing all possible values in bar chart

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

I'm hoping someone can take a look at the attached for me.

What I want is to select from the 'Cat & SubCat' list box, and for the chart to show all possible grades for that 'Cat' along the X axis (obviously many of them will be null values).

For example, when I select 'A English', I should see A* - E along X axis, but with values only for 'A' and 'B'

Have tried various JOINS/KEEP functions in script, but still no joy!

I also don't want to bring 'Type C' from the 'Possible' table into the data - so I only want to join the Types that appear in the 'Main' table.

Thanks,
Jess

Re: Showing all possible values in bar chart

Anil_Babu_Samineni — Thu, 14 Sep 2017 09:07:18 GMT

Like this?

Re: Showing all possible values in bar chart

jessica_webb — Thu, 14 Sep 2017 09:08:40 GMT

Not quite, because 'M' and 'P' don't belong to 'Cat A'.

So the chart you're showing, but without M or P.

Re: Showing all possible values in bar chart

Anil_Babu_Samineni — Thu, 14 Sep 2017 09:50:48 GMT

But, If we are doing suppress then P and M should come right? i am not sure i followed you..

Re: Showing all possible values in bar chart

jessica_webb — Thu, 14 Sep 2017 09:52:34 GMT

So when I select 'A English', it is coming from Cat 'A'.

The only possible values for Cat 'A' are:

So I would like to see all of those values on the X axis.

Re: Showing all possible values in bar chart

Anil_Babu_Samineni — Thu, 14 Sep 2017 10:02:11 GMT

Can you map the table using ApplyMap ‒ QlikView

And expression should this?

Count({<Type = $:: Type>} ID)

Re: Showing all possible values in bar chart

Kushal_Chawda — Thu, 14 Sep 2017 10:17:18 GMT

What should be the count for All possible values? A=4 or 1, B=5 or 3?

Re: Showing all possible values in bar chart

jessica_webb — Thu, 14 Sep 2017 10:28:17 GMT

Sorry Kushal, I don't really understand your question.

Basically, the chart should show exactly as my attachment, except all possible values should be showing along the X axis.

Most values will be null, but A type 2 = 1, B type 1 = 2, B type 2 = 1

Re: Showing all possible values in bar chart

Kushal_Chawda — Thu, 14 Sep 2017 11:37:02 GMT

see the attached application

Re: Showing all possible values in bar chart

jessica_webb — Thu, 14 Sep 2017 13:50:46 GMT

Thanks Kushal. Your solution involved a few more variables and syntax than I hoped, but works great.

Think I've managed to find a more straightforward solution. It leaves me with a synthetic table, but I'm hoping that won't cause too many issues!

Re: Showing all possible values in bar chart

Kushal_Chawda — Thu, 14 Sep 2017 13:56:53 GMT

I don't know but it may cause some issue due to synthetic keys. If it works for you then that's really good. You can mark the appropriate answer as correct or helpful