Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor 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
Contributor

Re: Dual count in a bar chart

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
Contributor

Re: Dual count in a bar chart

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

Highlighted
Contributor III

Re: Dual count in a bar chart

Dear SanthiQlik,

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