How to set selected dimensions when start in QS

[Anonymous]

Hello, friends.

I met a problem need to be solved. please read the description below.

for example, i have a table as below.

Dimension	Measure
A	2
B	4
C	3
D	5

by default, if i do sum(Measure), measure is 14.

and i can select Dimension A, then measure is 2.

it is ok for me..

now, i want to do sum({<Dimension={‘*’}-{‘B'}>}Measure) as default result (10) when i open the report.

later, if i  manually select the Dimensions A-D, the Measure result is 14.

that means B is not really filtered. it is just not taken into account at the beginning.

any solution for that?

thank you very much.

BR

Larry

[ogster1974]

Create a bookmark for users to apply for this senerio.

[OmarBenSalem · Accepted solution]

Change your measure as follow:

if(len(getfieldselections(Dimension)))=0, sum({<Dimension=-{'B'}>}Measure),

sum({<Dimension>}Measure)

)

[Ralf_Heukäufer]

You can also look for some Extensions in Qlik Branch.

Perhabs something like that:

http://branch.qlik.com/#!/project/5775290349fc1bfca8047ad2

[Anonymous]

I use like this.

if(len(getfieldselections(Dimension))=0,

sum({<Dimension=-{'B'}>}Measure),

sum(Measure)

)

[Anonymous]

thank you very much.

[Anonymous]

thank you everyone!

problem has been solved.