Set Expression

[upaliwije]

I have pie chart with class as dimension to sum sales. Apart from that I have following List boxes

Dept    Dept1,Dept2,

Regions   Reg1,Reg2,Reg3 etc

Branch     Bran1,Bran2,Bran,3 etc

Years      2011,201,2013

Months   Jan,Feb,Mar.....

I want a set expression to show Dept1 Sales irrespective of my selection of Regions or branches. But when I select Year or month, sales should change accordingly but for whole Dept. Pls someone help to write the correct set expression. I am new to qlikview.

Thanks in advance

[#2]

please don't create multiple thread with the same problem.

answer is already in your other thread >.>

http://community.qlik.com/thread/96189

[upaliwije]

Pls consider my example more than one list box

[#4]

lol, then just add branch to your set analysis

Example:

sum({<Region=,Branch=>} Sales)