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: 
Anonymous
Not applicable

Multiple Alternate States in a Chart

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?

1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

try using Only() function

=Only({[Chart1]}Fieldname)

View solution in original post

3 Replies
Clever_Anjos
Employee
Employee

try using Only() function

=Only({[Chart1]}Fieldname)

sunny_talwar

Hey Jeremy -

How are you? Are you looking for this?

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

Anonymous
Not applicable
Author

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