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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store an expression in a variable, with parameters

Hi there,

I'm facing an inconvenient issue. I have 4 gauge charts, with the same expression. The only difference between all of them, is a value in a set analysis condition. This value is fixed and different in every chart.

The thing is, if I want to change something in the expression, I have to do it for all the 4 charts; so 4 times the same change.

I was thinking of storing the expression in a variable, and affecting this variable in my charts. So if I want to change my expression, I do it only once, and it's appplied in the 4 charts.

My problem concerns the fixed value in the set analysis condition. Is there a way to indicate in the expression (stored in the variable) that the value is not fixed, and when I affect the variable in the chart, I give a kind of parameter, which is the value, different in the 4 charts?

E.g:

  • 1st Chart expression:

Sum({$<Category={1}>} Price)

  • 2nd Chart expression:

Sum({$<Category={2}>} Price)

  • 3rd Chart expression:

Sum({$<Category={3}>} Price)

  • ...

Let's say I store this expression in a variable:

vPrices = Sum({$<Category={1}>} Price)

Do you guys have an idea how to indicate my Category value as a dynamic parameter, and affect vPrices for each chart with a different value every time?

Thanks in advance,

David

1 Solution

Accepted Solutions
marcus_sommer

You could use the $-sign + a number for any parameter, like:

vPrices:

Sum({$<Category={$1}>} Price)

expression:

$(vPrices(1))

$(vPrices(2))

....

- Marcus

View solution in original post

2 Replies
marcus_sommer

You could use the $-sign + a number for any parameter, like:

vPrices:

Sum({$<Category={$1}>} Price)

expression:

$(vPrices(1))

$(vPrices(2))

....

- Marcus

Not applicable
Author

Wow, awesome, it perfectly works!

I didn't know that.

Thanks

David