topic Re: conditional to hide bars in bar chart? in QlikView

conditional to hide bars in bar chart?

Tue, 19 Aug 2014 14:58:07 GMT

Hello all,

I have a question regarding hiding specific bars in a bar chart. I was wondering if there is a conditional statement I could write out that would hide specific bars in a chart that I have.

on this chart there are several dimension values that have no corresponding data. I have checked off supress null values in the properties of the chart and the dimension values are still shown.

I was wondering if there was any possible conditional statement (either for dimension or expression) that would enable me to target the specific data and hide it from the graph.

additionally, if anyone can think of another solution without using a conditional, (using variable ect.) I would love to hear it.

Thanks, Mike

Re: conditional to hide bars in bar chart?

Anonymous — Mon, 15 Dec 2014 07:32:31 GMT

Hi,

Even I want the solution to the above problem.Please anyone help me.

Re: conditional to hide bars in bar chart?

lironbaram — Mon, 15 Dec 2014 07:45:47 GMT

to the best of my knowledge you can't hide those columns

as this is a secondary dimension , if you a have a value in one of the rows

qlikview need to create the dimension for all value in the main dimension

Re: conditional to hide bars in bar chart?

ali_hijazi — Mon, 15 Dec 2014 07:48:23 GMT

if you uncheck the Show Legend in the dimension tab; would this solve your problem?

Re: conditional to hide bars in bar chart?

Mon, 15 Dec 2014 08:05:31 GMT

Maybe use conditional layout on the Expressions tab. For example: if(YourExpression=0,0,1)

Try it, and let us know whether it worked or not!

Br,

Re: conditional to hide bars in bar chart?

lironbaram — Mon, 15 Dec 2014 08:37:43 GMT

hi conditional for expression is evaluating the condition for the total data in the

qlikview document ,

and the result is Boolean either show the expression in all dimension values or not

Re: conditional to hide bars in bar chart?

Mon, 15 Dec 2014 08:56:21 GMT

Thanks Liron for the explanation!

Re: conditional to hide bars in bar chart?

Anonymous — Mon, 15 Dec 2014 09:18:16 GMT

Hi Ali,

The problem wont be solved by unchecking the Show Legends. Any other solution?

Re: conditional to hide bars in bar chart?

Anonymous — Mon, 15 Dec 2014 09:22:55 GMT

Hi Tibor,

I need to hide the rows of the dimension not of the expression.

Re: conditional to hide bars in bar chart?

Anonymous — Wed, 07 Jan 2015 15:22:03 GMT

Hi,

It worked when I used (dim1&'-'&dim2), instead of using dim1 and dim2 separately.

Re: conditional to hide bars in bar chart?

Fri, 30 Jan 2015 15:04:31 GMT

Hi Niharika,

Thanks its working for me.