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

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))??

Labels (1)
12 Replies
rwunderlich
MVP
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...