Expression with more than one set analysis filter passed to a variable as a parameter not working

victor95 — Sat, 16 Nov 2024 05:59:33 GMT

Hi guys.

First of all, this is my first post, so I hope I am posting it the right place.

Qlik Sense allows you to pass parameters to variables, which is great. There is an example on how it works:

let sum = $1+$2
in: $(sum(1,3))
out: 4

Equivalently, one can pass expressions to a variable. This is usefull when dealing with formats.

let format = if(Fabs($1)<1,num($1,'0,0%'),num($1,'#.##0'))

The expression above apply percentage format to parameters that are less than 1.

An example on how to use it could be

$(format(sum( Sales )))

Or even

$(format(sum({<Country={'Spain'}>} Sales)))

The problem cames when trying to pass more than one set analysis filter, as in

$(format(sum({<Country={'Spain'},Year={'2018'}>} Sales)))

In this last case, as there is a comma in the expression (separing the Country and Year filters), the variable understands that two parameters are being passed.

I mean, when passing this parameter, the variable is understanding that

$1 = sum({<Country={'Spain'}

$2 = Year={'2018'}>} Sales))

How could I tell Qlik Sense that this comma is not meaning parameter separation? I have tried concatenating, using parenthesis...

Thank you in adavance! Cheers!

Re: Expression with more than one set analysis filter passed to a variable as a parameter not workin

sunny_talwar — Fri, 26 Apr 2019 11:31:21 GMT

Look here

Problem when I send parameters to variable function with a set analysys with two conditions

topic Re: Expression with more than one set analysis filter passed to a variable as a parameter not workin in App Development

Expression with more than one set analysis filter passed to a variable as a parameter not working

Re: Expression with more than one set analysis filter passed to a variable as a parameter not workin