Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ron1
Partner - Creator
Partner - Creator

Tricky QlikSense Development Concern

This is my input table

RegionAreaCodeRlevelSalesTarget
APACCENTRALCHN310090
APACCENTRALJPN38085
APACCENTRAL 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:

clipboard_image_0.png

 

Image 2:

clipboard_image_1.png

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

1 Solution

Accepted Solutions
kaanerisen
Creator III
Creator III

Hi Ron,

You can try this

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

Untitled.png 

Hope it helps..

View solution in original post

2 Replies
kaanerisen
Creator III
Creator III

Hi Ron,

You can try this

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

Untitled.png 

Hope it helps..

Ron1
Partner - Creator
Partner - Creator
Author

Excellent.It works. Thank you very much 🙂