Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
anushree1
Specialist II
Specialist II

Suppress Zero Values in Bar Chart

Hi,

I would like to know if there is a way to ensure that the bars having zero values be made invisible .

I do understand by converting the zero to Null we can have this achieved, but i would want to retain the zero Values as it is required for me to go ahead with the other column calculations using the previously calculated values

3 Replies
vinieme12
Champion II
Champion II

Try by giving a decimal value to the Zero's

example

if( Sum(Sales)=0,0.01,Sum(Sales))

anushree1
Specialist II
Specialist II
Author

Hi Vineeth,

The requirement is not to see those bars so this would not work

vinieme12
Champion II
Champion II

it will only be visible if you scale is in 2 decimals IS IT??