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: 
MrAndrews
Contributor III
Contributor III

Variable output into chart

Hi

I have an app where I want a value to be dynamic based on a user choice, which is all ok.  However, they also want the choice 'title' to be shown in the table.

So the user chooses 'GWP', they see a value form GWP, and the word GWP in a different column.  I dont seem to be able to get it to change! The value is dynamic, but not the string.  Mock up attached.


Ta

 

 

Labels (2)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Ok got it. Change your expression in the DriverDetailDesc field to:

=if(DriverName = 'Prem', '$(vPremDriver)' , '$(vClaimDriver)' )

View solution in original post

4 Replies
Lisa_P
Employee
Employee

What do you need to see in the table and where do you need to see it ?

MrAndrews
Contributor III
Contributor III
Author

Hi Lisa - In the column 'DriverDetailDesc' it should be the chosen option driver by the buttons above.   

If the driver name is Prem - it would be GWP or NWP. If the Driver Name is Claims it would be either NIC or Attr.

At the moment I can't get the literal to update in the DriverDetailDesc column, despite it updating the actual value in 'DriverValue'

Cheers!

 

Lisa_P
Employee
Employee

Ok got it. Change your expression in the DriverDetailDesc field to:

=if(DriverName = 'Prem', '$(vPremDriver)' , '$(vClaimDriver)' )

MrAndrews
Contributor III
Contributor III
Author

Ah mega! I really need to brush up on my dollar expansion.  I get super mixed up with when to and how to use.  Cheers!