topic Re: Need to hide bars with zero value in QlikView

Need to hide bars with zero value

qlikwiz123 — Sat, 16 Nov 2024 20:46:13 GMT

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.

Re: Need to hide bars with zero value

Anil_Babu_Samineni — Wed, 29 May 2019 12:54:16 GMT

If possible, Please rectify that in application to test.

Re: Need to hide bars with zero value

Uday_Pasupuleti — Wed, 29 May 2019 12:58:16 GMT

Try this in the dimension

Re: Need to hide bars with zero value

qlikwiz123 — Wed, 29 May 2019 13:03:00 GMT

@Anil_Babu_Samineni No idea what you mean by 'Rectify that in application to test' 🤔

Re: Need to hide bars with zero value

qlikwiz123 — Wed, 29 May 2019 13:00:56 GMT

@Uday_Pasupuleti This is QlikView and QlikView issue, not Qlik Sense

Re: Need to hide bars with zero value

Uday_Pasupuleti — Wed, 29 May 2019 13:07:23 GMT

my bad .. Ignore that ..

In regards to the QV,
If it's easy just do a if clause in the expression and show the zero's as nulls and ignore the nulls in the options.

Re: Need to hide bars with zero value

Anil_Babu_Samineni — Wed, 29 May 2019 13:09:04 GMT

My intention here, Share some sample application to investigate.

Re: Need to hide bars with zero value

qlikwiz123 — Wed, 29 May 2019 13:11:42 GMT

@Anil_Babu_Samineni Hi, the sample qvw is already attached 🙂

Re: Need to hide bars with zero value

qlikwiz123 — Wed, 29 May 2019 13:13:40 GMT

@Uday_Pasupuleti Nope, If condition and checking for 0's and nulls doesn't work either

Re: Need to hide bars with zero value

Uday_Pasupuleti — Wed, 29 May 2019 13:17:17 GMT

try this

Sum({<Measure Field= {">0"}>}Measure Field)

Re: Need to hide bars with zero value

qlikwiz123 — Wed, 29 May 2019 13:20:40 GMT

@Uday_Pasupuleti Even this condition is not working 😐

Re: Need to hide bars with zero value

Uday_Pasupuleti — Wed, 29 May 2019 13:23:09 GMT

I don't have access to QV at this moment.

That expression should work unless your expression involves multiple aggregations and complex.

If you can post your expression by changing the field names then I can look into it.

Re: Need to hide bars with zero value

qlikwiz123 — Wed, 29 May 2019 13:24:44 GMT

@Uday_Pasupuleti

Sum({<[Funds]= {">0"}>}([Funds]))

This is what am using but it is not working.

Re: Need to hide bars with zero value

Uday_Pasupuleti — Wed, 29 May 2019 13:26:07 GMT

Try this..
Sum({<[Funds]= {">0"}>}[Funds])

Re: Need to hide bars with zero value

qlikwiz123 — Wed, 29 May 2019 13:27:25 GMT

@Uday_Pasupuleti That's exactly what I am using (sans braces on Funds column). No luck

Re: Need to hide bars with zero value

Uday_Pasupuleti — Wed, 29 May 2019 13:29:40 GMT

Are you sure there is no syntax error coz I can see extra () on funds column

Re: Need to hide bars with zero value

qlikwiz123 — Wed, 29 May 2019 13:30:51 GMT

@Uday_Pasupuleti Placing a field within () is never an error or incorrect

Re: Need to hide bars with zero value

Uday_Pasupuleti — Wed, 29 May 2019 13:32:58 GMT

Am not saying it's an error.. I meant with the other parts of the exp..

Anyway, Post some screen shots of the options then I would be able to help.

Re: Need to hide bars with zero value

qlikwiz123 — Wed, 29 May 2019 13:33:52 GMT

@Anil_Babu_Samineni Any Luck?

Re: Need to hide bars with zero value

rwunderlich — Wed, 29 May 2019 13:34:24 GMT

When you use multiple dimensions QlikView is always going to lay the bar chart out symmetrically, reserving space for every dimension combination. The workaround is to use a single concatenated dimension. For example in the sample qvw you uploaded:

=Quarter & '-' & Year

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com