With reference to the example shared by Manish Kachhia in below post i want to show '0' as a separate dimension. where Age=0 is grouped.
Yes the grouping needs to be dynamic as its. I just want to add the 0 as dimension apart from the other grouping.
For example if the bucket is 8, currently the distribution is 0-8,8-16,16-24 etc
I want 0,(>0)-8,8-16,16-24..etc
Thanks Sunny. This looks good. I will try to replicate this on my original requirement. Can you please explain this part Num(0.0000001, '#.')
i was trying with 0 instead in place of Num(0.0000001, '#.') and what difference does it make.
Not sure why but 0 was not showing up... so I incremented its value by a very small number 0.0000001, but then it showed 0.0000001 in the dimension. So, I used Num() function to show just 0
Is there anyway to do this in QlikSense? We don't have QlikView so I can't download your .qvw and get anything but the xml that is at the trailing end of the file. However, I can't seem so shoe-horn it into QlikSense.