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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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 !!!!