topic Re: Tricky QlikSense Development Concern in App Development

Tricky QlikSense Development Concern

Ron1 — Fri, 11 Oct 2019 10:25:05 GMT

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 😞

Re: Tricky QlikSense Development Concern

kaanerisen — Fri, 11 Oct 2019 12:32:45 GMT

Hi Ron,

You can try this

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

Hope it helps..

Re: Tricky QlikSense Development Concern

Ron1 — Mon, 14 Oct 2019 08:10:04 GMT

Excellent.It works. Thank you very much 🙂