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: 
arusanah
Creator II
Creator II

Help with Calculated dimensions

       

Please See word file for desired out put.

I'm trying two create wo dimensions Pre Grp & Post Grp , but my calculations are not working . any help will be greatly Appreciated.

Thanks

5 Replies
sunny_talwar

3D fall under pre? Is that a rule that anything after the last null goes under post, everything else is pre null?

Capture.PNG

arusanah
Creator II
Creator II
Author

Hi Sunny ,

yes , pre null values goes to Pre Field  & Post null in Post Field .Every month  we get new record for ID . so  you might  have 3d fall there . but it always stores pre null values in pre Field & Post null in Post field.  so  cinase were we have 3D fall . when we select month Filter Our Post & pre values will change accordingly.

arusanah
Creator II
Creator II
Author

Hey sunny ,

I tried to debug it and looks like ISnull() function is causing issue . is there any alternative  for that .. or any new logic I should be using.

Not applicable

try len(<field>)=0 instead of IsNull()

arusanah
Creator II
Creator II
Author

Nope Ram, its not working