topic Re: Set Expression in QlikView

Set Expression

upaliwije — Thu, 17 Oct 2013 03:58:51 GMT

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

Re: Set Expression

Thu, 17 Oct 2013 04:08:35 GMT

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

answer is already in your other thread >.>

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

Re: Set Expression

upaliwije — Thu, 17 Oct 2013 05:21:00 GMT

Pls consider my example more than one list box

Re: Set Expression

Thu, 17 Oct 2013 05:33:32 GMT

lol, then just add branch to your set analysis

Example:

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