Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

arusanah
Contributor

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
MVP
MVP

Re: Help with Calculated dimensions

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
Contributor

Re: Help with Calculated dimensions

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
Contributor

Re: Help with Calculated dimensions

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

Re: Help with Calculated dimensions

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

arusanah
Contributor

Re: Help with Calculated dimensions

Nope Ram, its not working