topic Re: Pie chart fixed in QlikView

Pie chart fixed

Thu, 06 Mar 2014 17:13:12 GMT

Hello,

I need to have a pie chart by región, but any time i do a selection in any region i need this chart not changing, It is that possible?

Thanks a lot!

Re: Pie chart fixed

chiru_thota — Thu, 06 Mar 2014 17:14:58 GMT

Yes.It is possible using setanalysis.

ignore region from this chart

Ex : Sum ( {<Region=>} sales)

if you want that chart won't be responded to any selections then

Ex : Sum({1} Sales)

Re: Pie chart fixed

MK_QSL — Thu, 06 Mar 2014 17:29:46 GMT

SUM({<Dimension1 = , Dimension2 =, Dimension3=,>}Sales)

Considering that you have Dimension1, Dimension2, Dimension3, are list boxes and you don't want your pie chart to be changed on selecting any selection from these list boxes.

Re: Pie chart fixed

Anonymous — Thu, 06 Mar 2014 17:36:56 GMT

Region dimension

Sales is expression

To show sales per region use the below set analysis syntax in sales expression in expression tab.

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>} Sales / $(vCurrency)).

Hope this helps