Discussion board where members can get started with QlikView.
Here i am taking as dimension as "Sub_Division" and Expression as Sum( ) ...
Here i want to show others values as "others" on X-Axis ....& i want to remove zero's on my X-Axis .....
How to Achieve this one ..?
Thanks To All
on ur expression tab :
=if(sum( urfieldname)>0.1,sum( uefieldname),null())
on ur dimesnion tab:
check the check box, suppress when value is null
suppress when value is null
suppress zero values.
in dimension limit
check show others for other values