topic Set Expression in QlikView

Set Expression

upaliwije — Thu, 17 Oct 2013 02:55:12 GMT

I have a pie chart with Products as dimension. I have a list boxes for Dept for Dept 1, Dept 2. Under each of these dept there are many regions in a separate list box. In my pie chart total of dept1 should be shown irrespective of Regions i select. Could someone pls help me to write the set experession for this.

thanks

Re: Set Expression

Thu, 17 Oct 2013 03:28:50 GMT

try inserting this to your Expression

{<Region=>} ////this set analysis will make your Expression not be affected by your region selections

Example:

sum({<Region=>} Sales) ////this means your chart will give the summation of sales without being affected by your selections under region.

Re: Set Expression

jagan — Thu, 17 Oct 2013 05:15:39 GMT

Hi,

You can ignore the selections of a particular by using DimensionName = in set analysis experssion. So try like this

=Sum({<Region=>} Sales)

Regards,

Jagan.