Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Highlighted
Not applicable

conditional to hide bars in bar chart?


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.Capture.PNG.png

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

10 Replies
niharika
Contributor II

Re: conditional to hide bars in bar chart?

Hi,

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

Partner
Partner

Re: conditional to hide bars in bar chart?

hi

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

Partner
Partner

Re: conditional to hide bars in bar chart?

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

I can walk on water when it freezes
Not applicable

Re: conditional to hide bars in bar chart?

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,

T

Partner
Partner

Re: conditional to hide bars in bar chart?

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

Not applicable

Re: conditional to hide bars in bar chart?

Thanks Liron for the explanation!

niharika
Contributor II

Re: conditional to hide bars in bar chart?

Hi Ali,

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

niharika
Contributor II

Re: conditional to hide bars in bar chart?

Hi Tibor,

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

niharika
Contributor II

Re: conditional to hide bars in bar chart?

Hi,

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