Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

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
marcus_sommer

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

View solution in original post

2 Replies
marcus_sommer

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
Champion
Champion
Author

Hi Marcus,

good idea! Thanks!

Best regards,

DataNibbler