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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
ObiWan
Contributor
Contributor

Add a parameter to a variable

Hi!

I would like to create a variable in the front end of qlik sense with a parameter, as I did in qlik view: 

(sum(cost) / $1)

but it doesn't work and the message is "Error in expression". Do you know why?

Thanks a lot!

 

 

Labels (1)
1 Solution

Accepted Solutions
agigliotti
MVP
MVP

let's try as below:

variableName = sum(cost) / $1

call it as:
$(variableName(parameter value))

ex. $(variableName(2))

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it

View solution in original post

3 Replies
agigliotti
MVP
MVP

Hi,

your expression doesn't works also in qlikview.
I just tried it on version April 2020.

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
agigliotti
MVP
MVP

let's try as below:

variableName = sum(cost) / $1

call it as:
$(variableName(parameter value))

ex. $(variableName(2))

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
ObiWan
Contributor
Contributor
Author

I have the same messagge of error with my and your solution..  but using both in a text object the result is correct...

thanks