Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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

View solution in original post

s10157754
Creator III
Creator III
Author

Dear SanthiQlik,

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