topic Re: Qlik Sense , can not put a function into set analysis in App Development

Qlik Sense , can not put a function into set analysis

Anonymous — Fri, 29 Jun 2018 09:00:24 GMT

Hello :

in my case , I want to set a variable, and then put the variable into a KPI/BAR CHART .but I find it is not working for me.

my Step 1:

Set getLastMonth = monthname(Max([Refresh Date]));

Set KPI = Sum({$<[Refresh Date]={"$(=$(getLastMonth))"}>} [Total]) ;

my Step 2:

in a KPI, I put

$(KPI)

but it is not working for me , it just return '0'.

my Step 3:

I put Sum({$<[Refresh Date]={"$(=$(getLastMonth))"}>} [Total]) directly into the KPI, then it is working and return correct value.

thanks

Xu Zhao

Anonymous — Fri, 29 Jun 2018 09:07:51 GMT

BTW,

I also tried put variable KPI in the chart, and

it only returns Sum({$<[Refresh Date]={""}>} [Total]) , which means it did not get $(=$(getLastMonth))

ogautier62 — Sat, 30 Jun 2018 05:42:06 GMT

Hi,

and with this :

Set KPI =

Sum({$<[Refresh Date]={"=$(getLastMonth)"}>} [Total]) ;

it should work

regards

Chanty4u — Sun, 01 Jul 2018 07:30:22 GMT

can you share your app?

how expression you set in variable? with "=" or without = ?

Anonymous — Tue, 03 Jul 2018 08:56:02 GMT

Hi Olivier,

I also tried your statement, but it will not only return the last month, it returns all months.

so that I have to do Sum({$<[Refresh Date]={"$(=$(getLastMonth))"}>} [Total]) .

From software development point of view, I do not like to use the statement directly in the wiget.