Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
s10157754
Creator III
Creator III

Dual count in a bar chart

Dear Qlikview Experts,

I was wondering how to create this type of chart in Qlikview.

My raw data is:

1.PNG

I have a 3 fields, "Block", "CodeA" & "CodeB"

I want to create a chart with "Block" as my dimension and dual count of CodeA & CodeB as my expression. My desired outcome will be something similar like below:

Test.PNG

I do not wish to show Code17 or Blank cell, then other code values shall be reflect in the bar chart.

For example:

6 [19] means Code 19 appeared 6 times

2 [5] means Code 5 appeared 2 times

etc...

Appreciating your time and help in advance. 🙂

Best Regards

QianNing

 

1 Solution

Accepted Solutions
santhiqlik
Creator
Creator

Hi,

Please find the attached QVW. Here is the picture of the soution I got.  Please let me know if this is what you are looking for.

CodeCount.PNG

View solution in original post

2 Replies
santhiqlik
Creator
Creator

Hi,

Please find the attached QVW. Here is the picture of the soution I got.  Please let me know if this is what you are looking for.

CodeCount.PNG

s10157754
Creator III
Creator III
Author

Dear SanthiQlik,

Your solution works like a charm. Thank you!
Best Regards
QianNing