Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Even I want the solution to the above problem.Please anyone help me.
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
if you uncheck the Show Legend in the dimension tab; would this solve your problem?
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
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
Thanks Liron for the explanation!
Hi Ali,
The problem wont be solved by unchecking the Show Legends. Any other solution?
Hi Tibor,
I need to hide the rows of the dimension not of the expression.
Hi,
It worked when I used (dim1&'-'&dim2), instead of using dim1 and dim2 separately.