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.
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
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