Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
jeremy_d_terles
Contributor II
Contributor II

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)

View solution in original post

sunny_talwar

Hey Jeremy -

How are you? Are you looking for this?

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

jeremy_d_terles
Contributor II
Contributor II
Author

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