Display 2 expression values in a stacked bar chart

[s10157754]

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 · Accepted solution]

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]

Dear Tamil,

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

Best Regards,

QianNing

[tamilarasu]

Great. Have a great day, Zhang!