Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Suppress null value bar without excluding null values in calculation of an expression

Dear Community,

I have a problem regarding suppress when value is null option in dimension properties of a chart.

I would like to calculate an indicator that takes into account null values in given field. However,on the chart I do not want to see this last bar, where all cases with null values for my dimension fall.

I thought that suppress when value is null option will solve the problem, meaning will hide last bar, but when this option is checked, values for my expression do not count null cases and its value becomes wrong.

I will be gratefull for all your suggestions that may solve my problem.

2 Replies
Employee
Employee

Re: Suppress null value bar without excluding null values in calculation of an expression

But in that case, wouldn't the chart show wrong results?

I mean you want to calculate the null values but you don't want to show them.

Is it possible to be more specific and post a qvw sample?

Thanks

Agis

Not applicable

Re: Suppress null value bar without excluding null values in calculation of an expression

Agis,

thank you for your interest, I appreciate it very much

Finally I managed to solve my problem. The solution was connected with rebuilding data model and creating 1-1 relation between my tables. I was afraid that duplicating my records will  inhibit the app but hopefully,  loading it on Access Point did not make any troubles.

Once more thank you and have a nice day!

Community Browser