3 Replies Latest reply: Aug 24, 2016 5:08 AM by Marcus Sommer RSS

    SetAnalysis usage in Qliksense Script Getting Error

    suresh m

      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