Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Every One,
Am facing issue when using set analysis and aggr in qliksense script, Always getting script error for these expresions
Aggr:
if(aggr(count(TransactionId),BankName)< 500,'Others',left(BankName,10))
Set Analysis:
Temp:
load
sum({<PL.paidindays = {'-14'}>}PL.DueAmt) as [Statement DueAmt] resident PaymentLiquidation;
if i use any set analysis expresions like Qlikview always getting like this
sum({<PL.paidindays = {'-14'}>}PL.DueAmt) as [Statement DueAmt]
Getting Red Mark after sum .. Can any one give me alternative expression in case of Aggr and Set Analysis.
Regards
suresh
Set analysis and aggr-functions are features from the gui - they aren't available on script-level. You will need for the aggregations group by loadings and if-loops for for the conditions.
- Marcus
We are using nested if conditions to achieve cyclic functionality it leads poor performance, Is there any optimised expression for these type of expression
IF($(vDim)=1,Year,if($(vDim)=2,Month,if($(vDim)=3,Date,if($(vDim)=4,store))))
Regards
suresh
Instead of nested if-lops you could use pick(match()) - take a look here: is nested if allowed in Average()?
- Marcus