Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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