Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Thank You PrashantSangle, that worked!