topic Re: Display 2 expression values in a stacked bar chart in QlikView

Display 2 expression values in a stacked bar chart

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

Dear Qlikview Experts,

I had created a stacked bar chart with multiple expressions.

E.g. 1) Count(A)/Count(Result)

2) Count(B)/Count(Result)

3) Count(C)/Count(Result)

Now I would like to add 3 expressions to display numerical values beside the respective % in the segment.

E.g. 1) Count(A)

2) Count(B)

3) Count(C)

May I know is it possible for me to achieve it? Thanks a lot in advance!

tamilarasu — Thu, 01 Feb 2018 06:58:14 GMT

Hi Zhang,

You can use Dual function in this case. Try something like,

1) Dual(Num(Count(A)/Count(Result), '#,##0%')& ' (' & Count(A) & ') ' ,Count(A)/Count(Result) )

2) Dual(Num(Count(B)/Count(Result), '#,##0%') & ' (' & Count(B) & ') ' ,Count(B)/Count(Result) )

3) Dual(Num(Count(C)/Count(Result), '#,##0%') & ' (' & Count(C) & ') ' ,Count(C)/Count(Result) )

s10157754 — Thu, 01 Feb 2018 07:52:41 GMT

Dear Tamil,

Once again, thank you so much for your help! It works like a charm!

Best Regards,

QianNing

tamilarasu — Thu, 01 Feb 2018 07:54:55 GMT

Great. Have a great day, Zhang!