topic Multiple Alternate States in a Chart in QlikView

Multiple Alternate States in a Chart

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

I am creating a chart with multiple expressions that each exist in a separate state. I have included the example below:

=Sum({[Chart 1]} [Total Spend])

They all work fine, but I wanted to add on a simple field =Fieldname on the end. Those aren't working with the alternate states the same way. I was trying =({[Chart 1]} Fieldname) but that was coming up as an error.

Does anyone know how to write this?

Re: Multiple Alternate States in a Chart

Clever_Anjos — Thu, 13 Oct 2016 16:58:46 GMT

try using Only() function

=Only({[Chart1]}Fieldname)

Re: Multiple Alternate States in a Chart

sunny_talwar — Thu, 13 Oct 2016 16:59:02 GMT

Hey Jeremy -

How are you? Are you looking for this?

=Sum({[Chart 1]} [Total Spend]) & ' ' & Only({[Chart 1]} Fieldname)

Re: Multiple Alternate States in a Chart

Anonymous — Thu, 13 Oct 2016 17:20:51 GMT

Thank you very much Sunny. I will check to see if this will work.