Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Change your measure as follow:
if(len(getfieldselections(Dimension)))=0, sum({<Dimension=-{'B'}>}Measure),
sum({<Dimension>}Measure)
)
Create a bookmark for users to apply for this senerio.
Change your measure as follow:
if(len(getfieldselections(Dimension)))=0, sum({<Dimension=-{'B'}>}Measure),
sum({<Dimension>}Measure)
)
You can also look for some Extensions in Qlik Branch.
Perhabs something like that:
I use like this.
if(len(getfieldselections(Dimension))=0,
sum({<Dimension=-{'B'}>}Measure),
sum(Measure)
)
thank you very much.
thank you everyone!
problem has been solved.