topic Re: piechart both expression and number in QlikView

piechart both expression and number

Thu, 30 Jul 2015 07:47:22 GMT

Hey

i have an expression say sum({<empid={1}>}empid)/sum(empid)

i want this 2 be dispayd as % in pie chart and sum(empid) as number values in the same pie chrt.

Re: piechart both expression and number

Gysbert_Wassenaar — Thu, 30 Jul 2015 07:52:22 GMT

See attached example.

Re: piechart both expression and number

Thu, 30 Jul 2015 08:56:00 GMT

thanks gysbert.

In dual(num(sum(Sales),'#,##0') & chr(10) & num(sum({<Year={2009}>}Sales)/sum(Sales),'#.0%') ,sum({<Year={2009}>}Sales)/sum(Sales))

what does num(sum(Sales),'#,##0') & chr(10) actually mean? and y u r concatinating this with num(sum({<Year={2009}>}Sales)/sum(Sales),'#.0%') ?

pls elaborate this.

Re: piechart both expression and number

Gysbert_Wassenaar — Thu, 30 Jul 2015 09:02:32 GMT

The chr(10) is a line break. That way you get the first part of the text on one line and the second part on the next line.

Re: piechart both expression and number

Thu, 30 Jul 2015 09:36:02 GMT

gwassenaar dual takes two parameters text and number.

so you say num(sum(Sales),'#,##0') & chr(10) & num(sum({<Year={2009}>}Sales)/sum(Sales),'#.0%') is a textual representation and sum({<Year={2009}>}Sales)/sum(Sales) is a numerical representation ?

Re: piechart both expression and number

Gysbert_Wassenaar — Thu, 30 Jul 2015 09:47:27 GMT

Yes, that's correct.

Re: piechart both expression and number

Thu, 30 Jul 2015 10:10:04 GMT

num(sum(Sales),'#,##0') & chr(10)

it means the number displayed in pie chart is sum(Sales) and not sum({<Year={2009}>}Sales)/sum(Sales)?

because after line break; (sales in 2009 / total sales) is present;which is displaying as %. Before line break; the expression is num(sum(Sales),'#,##0') -> the number display part which is not the ratio. gwassenaar‌

Re: piechart both expression and number

Gysbert_Wassenaar — Thu, 30 Jul 2015 10:20:54 GMT

num(sum(Sales),'#,##0') & chr(10)

it means the number displayed in pie chart is sum(Sales) and not sum({<Year={2009}>}Sales)/sum(Sales)?

No, that's not correct. The dual function creates numeric value that also has a textual display representation. The numeric values determine the sizes of the pie segments. The textual representations (two lines of text because of the chr(10)) are shown as a labels with the segments.

Re: piechart both expression and number

Thu, 30 Jul 2015 11:55:20 GMT

then wat does exactly num(sum(Sales),'#,##0') mean to be used? gwassenaar‌