topic Re: Alternative text for chart if there are multiple values to display? in QlikView

Alternative text for chart if there are multiple values to display?

datanibbler — Thu, 15 Sep 2016 08:26:10 GMT

Hi,

in a chart I have, there are certain instances where there are two values to display for the exact same constellation of dimensions - in that case, the chart will display a dash, that is understood and I can deal with it.

I have now even found out how to replace the standard dash that is displayed in that case by a short alternative text.

<=> Is it possible to differentiate whether there are multiple values there or simply nothing at all?

Thanks a lot!

Best regards,

DataNibbler

Re: Alternative text for chart if there are multiple values to display?

marcus_sommer — Thu, 15 Sep 2016 08:36:08 GMT

Hi DataNibbler,

on this place you couldn't differentiate them - you could there replace the dashes with NULL (and the option below them with EMPTY) and need to catch the missing aggregation-error from the calculation with something like:

if(substringcount(concat(value, '+'), '+') >= 1, 'SEVERAL VALUES', value)

or maybe you used with concat an aggregation-function for it.

- Marcus

Re: Alternative text for chart if there are multiple values to display?

datanibbler — Thu, 15 Sep 2016 10:56:34 GMT

Hi Marcus,

good idea! Thanks!

Best regards,

DataNibbler