topic Re: SetAnalysis usage in Qliksense Script Getting Error in App Development

SetAnalysis usage in Qliksense Script Getting Error

suresh_qv50 — Mon, 22 Aug 2016 07:20:08 GMT

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

Re: SetAnalysis usage in Qliksense Script Getting Error

marcus_sommer — Mon, 22 Aug 2016 13:18:20 GMT

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

Re: SetAnalysis usage in Qliksense Script Getting Error

suresh_qv50 — Wed, 24 Aug 2016 09:06:19 GMT

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

Re: SetAnalysis usage in Qliksense Script Getting Error

marcus_sommer — Wed, 24 Aug 2016 09:08:38 GMT

Instead of nested if-lops you could use pick(match()) - take a look here: is nested if allowed in Average()?

- Marcus