topic Re: How to exclude empty dimensions from grid chart in QlikView

How to exclude empty dimensions from grid chart

Wed, 10 Jul 2013 09:43:38 GMT

I've created a grid chart with 4 distinct values in the first dimension and 20 distinct values in the second dimension. Each value in the second dimension corresponds to exactly one value in the first.

How can I exclude the empty series from rendering in each of the 4 charts?

Thanks & regards

Matthias

Re: How to exclude empty dimensions from grid chart

er_mohit — Wed, 10 Jul 2013 10:08:03 GMT

i think on dimension side you have to check on suppress null value for that dimension

Re: How to exclude empty dimensions from grid chart

Gysbert_Wassenaar — Wed, 10 Jul 2013 11:31:10 GMT

Make four charts. If you use only one chart and the trellis options then all the selected dimension values of MASCHINE_ID will be shown. The axes are shared by all the sub-plots. That's by design. You can't change that.

Re: How to exclude empty dimensions from grid chart

Wed, 10 Jul 2013 12:59:43 GMT

I had already tried that, but it didn't change anything. Maybe it refers to NULL values of the dimension field itself.

Re: How to exclude empty dimensions from grid chart

Wed, 10 Jul 2013 13:08:30 GMT

I tried to use 4 charts before, but there I couln't specify different selections for the same dimension. I was able to achive what I wanted only by "disconnecting" and changing the selection one after another.

But how can I have multiple charts with diffent selections in the same dimension?