Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone! I am relatively new to qlikview and have a question about hiding the "bars" and axis labels which have zero/null value...
no other answers have worked because my data is set up in an unique way.
I need to hide the budget and forecast from 12h2 through 13h2 so that there is no empty space in my graph. Since no data is available for Budget and Forecast through 12h2 through 13h2, there is this weird empty space but on 14h1, since there is data for all three, it looks full.
Any help is GREATLY appreciated.
and no.... checking supress zero values doesn't do anything....
Please look at Distribution 2 and Result Table for the empty bars chart. I need to remove those empty spaces (bars) with zero values.
If possible, Please rectify that in application to test.
Try this in the dimension
@Anil_Babu_Samineni No idea what you mean by 'Rectify that in application to test' 🤔
@Uday_Pasupuleti This is QlikView and QlikView issue, not Qlik Sense
My intention here, Share some sample application to investigate.
@Anil_Babu_Samineni Hi, the sample qvw is already attached 🙂
@Uday_Pasupuleti Nope, If condition and checking for 0's and nulls doesn't work either
try this
Sum({<Measure Field= {">0"}>}Measure Field)