Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

datanibbler
Esteemed Contributor

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

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

1 Solution

Accepted Solutions

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

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

2 Replies

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

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

datanibbler
Esteemed Contributor

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

Hi Marcus,

good idea! Thanks!

Best regards,

DataNibbler

Community Browser