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

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

Mon, 22 Jun 2015 12:41:15 GMT

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.

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

Agis-Kalogiannis — Mon, 22 Jun 2015 20:56:42 GMT

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

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

Tue, 30 Jun 2015 06:32:10 GMT

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!