topic Re: How to display (columns for) values missing? in QlikView

How to display (columns for) values missing?

datanibbler — Tue, 16 Apr 2013 09:21:06 GMT

Hi,

my ´problem is seemingly very simple: I have created a QlikView report with a pivot table that has quite a lot of dimensions. For some of these dimensions, there is no data available - I still want it to display all the columns (the "expand all" checkbox in the properties is ticked) with some symbol when the values are missing.

Currently, however, the rightmost dimensions are not displayed (seemingly independent of the selection) although I can see in the preview of the source table that those fields are available.

Thanks for any help!

Best regards,

DataNibbler

Re: How to display (columns for) values missing?

datanibbler — Tue, 16 Apr 2013 09:55:16 GMT

P.S.: Hmm, I just deleted a dimension where there were no values to display and now all the dimensions right of that one are displayed. So it seems than when in one column (dimension) there are no values, then the ones to the right of that one are not displayed. Is that correct? If so, what can I do to prevent that?

Thanks!

Best regards,

DataNibbler

Re: How to display (columns for) values missing?

Tue, 16 Apr 2013 11:05:12 GMT

Under presentation un-tick "suppress zero values"

See attached example

Re: How to display (columns for) values missing?

datanibbler — Tue, 16 Apr 2013 14:27:26 GMT

Hi zohaibirshad,

that checkbox is not ticked ;-(

Oh - it seems that was, as I was starting to assume, a specific point about the pivot table. I just tried changing the diagram type from a pivot table to a flat table, that will do nicely for the purposes of this document. Guess what, now the values are seemingly all displayed.

Seems there's no way to close this thread, but it does seem that this is answered.

Best regards,

DataNibbler