topic Re: Using an expression to add text to a chart title in QlikView

Using an expression to add text to a chart title

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I am using the following expression to add dynamic text to a chart title -

='Full breakdown of the number of entrants from, ' & region

I would like to alter the expression to show the 'region' OR the 'institution' if a specific institution is selected.

I'm not very good with IF statements or programming in general. Is there an easy way to do this?

Thanks

Greg

marcus_sommer — Tue, 23 Aug 2016 12:40:35 GMT

You could try something like this:

='Full breakdown of the number of entrants from, ' & if(getselectedcount(institution) = 1, institution, region)

- Marcus

Anonymous — Tue, 23 Aug 2016 12:44:07 GMT

Thanks Marcus. I'm very grateful.

Greg

maxgro — Tue, 23 Aug 2016 12:44:20 GMT

this is to show the institution if one instititution is selected (getselectedcount), else the regions

='Full breakdown of the number of entrants from, ' & if(GetSelectedCount(institution)=1, institution, concat(distinct region, ', '))