Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI ,
I have a requirement to exclude zero bar form a bar chart.
I have two dim and one exprsssion bar chart.
For dim who has no entry wrt to count are also coming in bar chart just name on axis.
how can I exclude this.
I have tried all supress zero, null etc nothing working
Like this?
Please note that there is no direct approach to handle in QlikView Bar Chart while using multiple dimension.
Thanks to rubenmarin for suggesting this long time ago.
Can you please show the image, Please do supress Dimension level and Presentation respect
The issue may be because of two dimensions, even if there is no Expression value for one dim other dim may have.
Pls check the attached doc. where you will see that despite the fact that there is no value for Expression, we have place holder for bar( blank space) in bar chart.
!Thanks Kumar,
but I want both dim in x axis and legend should be of expression .
Please see attached your application with changes . in this for 2001 I am getting zero bars for march n april month .
I want to exclude that
Hi,
it will give Zero for 2001 ,March,April no data in your source.
thanks rite so I don't want that in axis , just jan feb should come .for 2001
how to restrict that
There is no default option to deserve this issue? Hope mrkachhiaimp offer you work around. Let's wait for his response
okay. @manish kindly guide
Like this?
Please note that there is no direct approach to handle in QlikView Bar Chart while using multiple dimension.
Thanks to rubenmarin for suggesting this long time ago.
Thanks Manish,I am not able to see the query you have posted sometime back inorder to get this result .
Can u please post again and if u can explain little bit .
Thanks in advance