Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
=IF(Num(Age)>0,DUAL(Replace(Class(Age,$(vBucketWIdth)),'<= x <',' - '),Class(Age,$(vBucketWIdth))+1), Num(0.0000001, '#.'))
hI Surya
and what about the grouping, do we need to retain that?
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
Try this
=IF(Num(Age)>0,DUAL(Replace(Class(Age,$(vBucketWIdth)),'<= x <',' - '),Class(Age,$(vBucketWIdth))+1), Num(0.0000001, '#.'))
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.
Hi Mate,
Is it possible 0-5, i need starts from 6-10..e.t.c
Is it possible, Please let me know.
Thanks & Regards,
Ravindra Babu G