Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How TO pass Dimension from Chart to Function Call Expression

I have an expression that takes a paramater as a value

In one of my charts the values in one of the dimensions are the names I would like to pass to my function. How Would you accomplish this?

$(FunctionName(PassDimension))??

12 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The way to do row by row conditional is with if() instead of Set Analysis. For example

sum(if(GroupName=$1, Value))

Might that work for you?

-Rob

Not applicable
Author

Thats what Im trying to avoid

sabreyals
Contributor III
Contributor III

I have a similar issue and i have posted it in the New to Qliksense forum where I ideally want to pass the dimension value to the set analysis part of the expression like this

Sum({<Vintage={'$(=$(vMaxVinNum(Mkt_Name)))'}>}Measure)

where vMaxVinNum=max({<Market={$1}>}VintageNumber)

I understand that the set analysis is calculated just once per chart but aggr doesn't work either.

because each market has a different value for max(Vintage) but the set analysis sees only one value.

Any ideas?

My Post:

https://community.qlik.com/t5/New-to-Qlik-Sense/How-to-pass-dimension-value-to-a-measure-in-set-anal...