Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
jessica_webb
Contributor III

Showing all possible values in bar chart

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

Tags (2)
1 Solution

Accepted Solutions

Re: Showing all possible values in bar chart

see the attached application

Capture.JPG

View solution in original post

10 Replies

Re: Showing all possible values in bar chart

Like this?

Capture.PNG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jessica_webb
Contributor III

Re: Showing all possible values in bar chart

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

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
jessica_webb
Contributor III

Re: Showing all possible values in bar chart

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

The only possible values for Cat 'A' are:

A*

A

B

C

D

E


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

Re: Showing all possible values in bar chart

Can you map the table using ApplyMap ‒ QlikView

And expression should this?

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

Re: Showing all possible values in bar chart

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

jessica_webb
Contributor III

Re: Showing all possible values in bar chart

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

see the attached application

Capture.JPG

View solution in original post

jessica_webb
Contributor III

Re: Showing all possible values in bar chart

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!