Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Pie chart fixed

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!

1 Solution

Accepted Solutions
MK_QSL
Not applicable

Re: Pie chart fixed

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.

Other solution is  SUM({1}Sales)

Already suggested by Chiranjeevi

3 Replies
chiru_thota
Not applicable

Re: Pie chart fixed

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)

MK_QSL
Not applicable

Re: Pie chart fixed

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.

Other solution is  SUM({1}Sales)

Already suggested by Chiranjeevi

neetha_p
Not applicable

Re: Pie chart fixed

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