topic Re: Dual count in a bar chart in QlikView

Dual count in a bar chart

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

Dear Qlikview Experts,

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

My raw data is:

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:

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

Re: Dual count in a bar chart

santhiqlik — Fri, 25 Jan 2019 05:32:05 GMT

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.

Re: Dual count in a bar chart

s10157754 — Fri, 25 Jan 2019 05:38:20 GMT

Dear SanthiQlik,

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