Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SET Variable Qlik Sense Script

Hi All,

I would like to be able to use an old Qlikview variable in Qlik Sense but I understand this now needs to be done via a SET or LET (my knowledge is such I am unsure which is best).

The variable is an expression based on a few parameters as below

sum({<title={'*Articulated Vehicles Using White Diesel*','*Rigid Vehicles Using White Diesel*'}>}value)

I tried

SET vLitres =  sum({<title={'*Articulated Vehicles Using White Diesel*','*Rigid Vehicles Using White Diesel*'}>}value)

But this brought back errors. Please help as my head is firmly stationed in front of a wall!!

Toby

1 Solution

Accepted Solutions
hic
Former Employee
Former Employee

Try

SET vLitres =  =sum({<title={"*Articulated Vehicles Using White Diesel*","*Rigid Vehicles Using White Diesel*"}>}value);

See The Little Equals Sign

HIC

View solution in original post

2 Replies
hic
Former Employee
Former Employee

Try

SET vLitres =  =sum({<title={"*Articulated Vehicles Using White Diesel*","*Rigid Vehicles Using White Diesel*"}>}value);

See The Little Equals Sign

HIC

Not applicable
Author

Fantastic!! Thank you very much Henric !!!!