topic How Variables work in Qlik Sense Script? in QlikView

How Variables work in Qlik Sense Script?

MaSo1996 — Mon, 03 Mar 2025 09:18:55 GMT

Hello fellow Qlik enthusiasts!

I'd like to create variable in Qlik Sense script, that stores value:

NoConcatenate
RawTable: //Only with SPG Subproducts
load *,
num([StdCostSemi] / [StdCost],'0,00%') as [% of SPG Cost in Product],
1 as Flag
Resident fplCalcSemiInject;

drop Table fplCalcSemiInject;

NoConcatenate
Sth:
load
Avg([StdCostSemi] / [StdCost]) as [%]
Resident RawTable
Group By Flag;

Let AvgCostOfSPGinProduct = Peek([%]);

I'd expect that variable to give me i.e. 30%, but instead it's blank in sheet:

What am I doing wrong? - could you help me with that?

Re: How Variables work in Qlik Sense Script?

PrashantSangle — Mon, 03 Mar 2025 10:28:36 GMT

NoConcatenate
RawTable: //Only with SPG Subproducts
load *,
num([StdCostSemi] / [StdCost],'0,00%') as [% of SPG Cost in Product],
1 as Flag
Resident fplCalcSemiInject;

drop Table fplCalcSemiInject;

NoConcatenate
Sth:
load
Avg([StdCostSemi] / [StdCost]) as [%Perc]
Resident RawTable
Group By Flag;

LET AvgCostOfSPGinProduct = Peek('%Perc',0,'Sth');

Regards,

Prashant Sangle

Re: How Variables work in Qlik Sense Script?

MaSo1996 — Mon, 03 Mar 2025 10:31:39 GMT

Thank You PrashantSangle, that worked!