topic Re: Open and Close Selected Dimension in Calculated Dimension in QlikView

Open and Close Selected Dimension in Calculated Dimension

timsaddler — Fri, 21 Aug 2015 08:13:40 GMT

Hello

Is it possible to open and close certain rows in a dimension by using a calculated dimension?

Within an app I know it is possible to do this "manually" and this looks fine in the app. (screenshot1)

When using "Publisher" the results are random.(screenshot2)

Here are screenshots to show what I mean

Screenshot1

Screenshot2

Re: Open and Close Selected Dimension in Calculated Dimension

jonathandienst — Fri, 21 Aug 2015 09:21:58 GMT

By publisher I assume you mean viewed on the portal vs the desktop client?

The results are not random - they are the numbers from the one Item class that is non-zero. Publisher is suppressing the zero values but the desktop client is not.

You could play around with the suppress zeroes option on Properties | Presentation - but I don't have any simple workarounds.

Are you using browser that is compatible with the version of QV on the server? I see no + icons.

Re: Open and Close Selected Dimension in Calculated Dimension

timsaddler — Fri, 21 Aug 2015 10:36:38 GMT

hi jonathan

turning zero suppression off doesn't seem to have any effect?

the server on which the Distribution service is running has IE 9 installed - does this need upgrading?

also I notice that on the server PDF-Xchange3 is installed

is this software actually rendering the pdf's at runtime ?

Kind regards