Tricky QlikSense Development Concern

[Ron1]

This is my input table

Region	Area	Code	Rlevel	Sales	Target
APAC	CENTRAL	CHN	3	100	90
APAC	CENTRAL	JPN	3	80	85
APAC	CENTRAL		2		160

My desired output is attached in Image 1 without the null entry . The concern is when I am unchecking the Include Null value box, the CENTRAL total Target (2nd column Total entry is becoming null) (Shown in the Image 2)

(You can see the definition of the second measure in the below images)

Image 1:

Image 2:

No change can be made to the input file.. Kindly help to achieve this. Stuck here since last 3 days 😞

[kaanerisen · Accepted solution]

Hi Ron,

You can try this

IF(Dimensionality()=1,sum(aggr(sum({<Rlevel={2},Code=>}Target),Area)),sum({<Rlevel={3}>}Target))

 

Hope it helps..

[Ron1]

Excellent.It works. Thank you very much 🙂