Using GetSelectedFields in set analysis via variable

Perus_Pena — Sat, 16 Nov 2024 20:20:26 GMT

Hello everyone,

I have simple table listing months which is used to select YearMonth values from multiple tables. I have then multiple measures that I'd like to declare as variables in the Script editor. I will be calculating e.g. v.Count_A / v.Count_B type of measures.

This works as a measure: COUNT(distinct {<YearMonth={'$(=getfieldselections(SelectedPerioid))'}>} %_ID)

But if I use this in QlikScript like this:

Let v.Count = 'COUNT(distinct {<YearMonth={"$(=getfieldselections(SelectedPerioid))"}>} %_ID)';

--> Will show COUNT(distinct {<YearMonth={""}>} %_ID) on the app side.

I guess the $ will make the script will return "" for the field selection as there is no variable with that name. So how can I force that $(=get...Perioid) to be used on the app side?

Regards,

Pena

Re: Using GetSelectedFields in set analysis via variable

agigliotti — Wed, 31 Jul 2019 13:31:14 GMT

let's try with the below syntax:

LET v.Count = 'COUNT(distinct {<YearMonth={' & '$' & '(=getfieldselections(SelectedPerioid))}>} %_ID)';

I hope this could help.

Re: Using GetSelectedFields in set analysis via variable

Perus_Pena — Thu, 01 Aug 2019 06:26:24 GMT

Thanks, this worked perfectly!

topic Re: Using GetSelectedFields in set analysis via variable in App Development

Using GetSelectedFields in set analysis via variable

Re: Using GetSelectedFields in set analysis via variable

Re: Using GetSelectedFields in set analysis via variable