Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))??
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
Thats what Im trying to avoid
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: