Set Expression

Tue, 03 Apr 2012 10:53:37 GMT

i have written this set expression for calculating volume of a product.

sum({$<%CPID={1},REGION_ID=, DISTRICT_ID=, TERRITORY=>} (Volume))

where %CPID is the product ID.

I have Dimension as Geo_ID which is a cyclic group with Nation, REGION_ID, DISTRICT_ID and TERRITORY as fields. Now even if i am selecting any particular geography level say a particular district or a territory then the selected is highlighted but other district or territory are also listed with their values. But when i am going one level down with a particular district selected then all the territories in the nation are coming. I want only those territories to appear which are there in the selected district. How can i change my expression to do that ??

Set Expression

gandalfgray — Tue, 03 Apr 2012 11:14:17 GMT

I don't know if I missing something here, but in general if you want your sum expression to respect which DISTRICT_ID you actually have selected, you should not have a set expression with DISTRICT_ID= in it, because that makes that expression disregard any selections in DISTRICT_ID.

/GG

topic Set Expression in QlikView

Set Expression

Set Expression