2 Replies Latest reply: Feb 17, 2018 4:23 PM by RANJIT KAKADE RSS

    Is there any specific limitations for number of Measures Values we can pass through Valuelist Function??

    RANJIT KAKADE

      Hi Qlik Experts,

       

      I have one issue with Value list() function.,I am trying to pass measure values through valuelist function but I am only able pass

      6-measure values through the same function .Is there any constraint/limitation for the same.,PFB Details and kindly assist me on the

      same issue

      Note:PFB Screenshot for more details.,if you look at in Column A,Column B only six values are displaying because I am unable to pass the more values than 6 -measures

       

      Valuelist-Issue-Capture.PNG

       

      PFB details for Expression passesd for Column A & Column B:

       

      =if(ValueList('Swift Transfer In','Swift Transfer Out',

      'Overdraft Interest',

      'Interest Due TPS',

      'Interest Due 11AM (S10)',

      'Interest Due FTD (I6)',

      'Interest Due Main (S1)',

      'Term Maturity Funds',

      '11AM TRANSFER',

      ' ',

      ' ',

      'Cuscal Sec Dep Int',

      'TPS Funds',

      'TPS Interest',

      'TWT Interest',

      'ABACUS',

      'CUSCAL Dividend',

      'CBS Fee',

      'BPAY',

      'Bank Balance Transfer',

      'Sun Daily',

      'Sun Pro Monthly',

      'DC FEE INCORRECT REV',

      'SMP JNL',

      'O/DRAFT QTLY SERV. FEE',

      'INTEGRIS S/FALL PMNT',

      'ATHENA S/FALL PMNT',

      'merchant fees',

      'COLLECTIONS SERVICE',

      'CUFSS Levy',

      'New FTD',

      ' ',

      'D/E Credits',

      'D/E Debits',

      'D/E Credit Rtns',

      'D/E Debit Rtns',

      'D/E Aust Mil Bank',

      'D/E Aust Mil Bank',

      'M/C MEM CHEQ CR',

      'M/C ACC Transfer',

      'M/C Bank 80',

      'M/C Outward Transfer',

      'M/C Returns',

      'ATM Issuer DC - WDL + ENQ',

      'ATM EFT REF#',

      'ATM SETTLEMENT REDICARD',

      'ATM BRANCH CASH ADJ',

      'ATM FEES',

      'REDIATM SETTLEMENT',

      'ATM DARWIN',

      'ATM Stirling',

      'ATM Robertson',

      'ATM HOLSWORTHY',

      'ATM Edinburgh',

      'Kapooka ATM',

      'Enogerra ATM',

      'Navy Canteen',

      'Larrakeyah ATM',

      'Cerberus ATM',

      'Puckapunyal ATM',

      'Watson ATM',

      'Albatross ATM',

      'Lavarack ATM',

      'Laverton ATM',

      'ATH SUBSERVICER FEE',

      'ATH DISTRIBUTION',

      'New ATM',

      'Branch Cash',

      'LOAN SEC',

      'LOAN FUNDINGS',

      'VISA IBS RV Fee',

      'VISA')='Swift Transfer In',Sum({1<FLAG ={'POSITIVE'},Column_D={"I*"}>}Column_E),

       

       

      if(ValueList('Swift Transfer In','Swift Transfer Out',

      'Overdraft Interest',

      'Interest Due TPS',

      'Interest Due 11AM (S10)',

      'Interest Due FTD (I6)',

      'Interest Due Main (S1)',

      'Term Maturity Funds',

      '11AM TRANSFER',

      ' ',

      ' ',

      'Cuscal Sec Dep Int',

      'TPS Funds',

      'TPS Interest',

      'TWT Interest',

      'ABACUS',

      'CUSCAL Dividend',

      'CBS Fee',

      'BPAY',

      'Bank Balance Transfer',

      'Sun Daily',

      'Sun Pro Monthly',

      'DC FEE INCORRECT REV',

      'SMP JNL',

      'O/DRAFT QTLY SERV. FEE',

      'INTEGRIS S/FALL PMNT',

      'ATHENA S/FALL PMNT',

      'merchant fees',

      'COLLECTIONS SERVICE',

      'CUFSS Levy',

      'New FTD',

      ' ',

      'D/E Credits',

      'D/E Debits',

      'D/E Credit Rtns',

      'D/E Debit Rtns',

      'D/E Aust Mil Bank',

      'D/E Aust Mil Bank',

      'M/C MEM CHEQ CR',

      'M/C ACC Transfer',

      'M/C Bank 80',

      'M/C Outward Transfer',

      'M/C Returns',

      'ATM Issuer DC - WDL + ENQ',

      'ATM EFT REF#',

      'ATM SETTLEMENT REDICARD',

      'ATM BRANCH CASH ADJ',

      'ATM FEES',

      'REDIATM SETTLEMENT',

      'ATM DARWIN',

      'ATM Stirling',

      'ATM Robertson',

      'ATM HOLSWORTHY',

      'ATM Edinburgh',

      'Kapooka ATM',

      'Enogerra ATM',

      'Navy Canteen',

      'Larrakeyah ATM',

      'Cerberus ATM',

      'Puckapunyal ATM',

      'Watson ATM',

      'Albatross ATM',

      'Lavarack ATM',

      'Laverton ATM',

      'ATH SUBSERVICER FEE',

      'ATH DISTRIBUTION',

      'New ATM',

      'Branch Cash',

      'LOAN SEC',

      'LOAN FUNDINGS',

      'VISA IBS RV Fee',

      'VISA')='Swift Transfer Out',Sum({1<FLAG ={'NEGATIVE'},Column_D={"I*"}>}Column_E),

       

       

      if(ValueList('Swift Transfer In','Swift Transfer Out',

      'Overdraft Interest',

      'Interest Due TPS',

      'Interest Due 11AM (S10)',

      'Interest Due FTD (I6)',

      'Interest Due Main (S1)',

      'Term Maturity Funds',

      '11AM TRANSFER',

      ' ',

      ' ',

      'Cuscal Sec Dep Int',

      'TPS Funds',

      'TPS Interest',

      'TWT Interest',

      'ABACUS',

      'CUSCAL Dividend',

      'CBS Fee',

      'BPAY',

      'Bank Balance Transfer',

      'Sun Daily',

      'Sun Pro Monthly',

      'DC FEE INCORRECT REV',

      'SMP JNL',

      'O/DRAFT QTLY SERV. FEE',

      'INTEGRIS S/FALL PMNT',

      'ATHENA S/FALL PMNT',

      'merchant fees',

      'COLLECTIONS SERVICE',

      'CUFSS Levy',

      'New FTD',

      ' ',

      'D/E Credits',

      'D/E Debits',

      'D/E Credit Rtns',

      'D/E Debit Rtns',

      'D/E Aust Mil Bank',

      'D/E Aust Mil Bank',

      'M/C MEM CHEQ CR',

      'M/C ACC Transfer',

      'M/C Bank 80',

      'M/C Outward Transfer',

      'M/C Returns',

      'ATM Issuer DC - WDL + ENQ',

      'ATM EFT REF#',

      'ATM SETTLEMENT REDICARD',

      'ATM BRANCH CASH ADJ',

      'ATM FEES',

      'REDIATM SETTLEMENT',

      'ATM DARWIN',

      'ATM Stirling',

      'ATM Robertson',

      'ATM HOLSWORTHY',

      'ATM Edinburgh',

      'Kapooka ATM',

      'Enogerra ATM',

      'Navy Canteen',

      'Larrakeyah ATM',

      'Cerberus ATM',

      'Puckapunyal ATM',

      'Watson ATM',

      'Albatross ATM',

      'Lavarack ATM',

      'Laverton ATM',

      'ATH SUBSERVICER FEE',

      'ATH DISTRIBUTION',

      'New ATM',

      'Branch Cash',

      'LOAN SEC',

      'LOAN FUNDINGS',

      'VISA IBS RV Fee',

      'VISA')='Overdraft Interest',Sum({1<Column_D={ "O*"}>}Column_E),

      if(ValueList('Swift Transfer In','Swift Transfer Out',

      'Overdraft Interest',

      'Interest Due TPS',

      'Interest Due 11AM (S10)',

      'Interest Due FTD (I6)',

      'Interest Due Main (S1)',

      'Term Maturity Funds',

      '11AM TRANSFER',

      ' ',

      ' ',

      'Cuscal Sec Dep Int',

      'TPS Funds',

      'TPS Interest',

      'TWT Interest',

      'ABACUS',

      'CUSCAL Dividend',

      'CBS Fee',

      'BPAY',

      'Bank Balance Transfer',

      'Sun Daily',

      'Sun Pro Monthly',

      'DC FEE INCORRECT REV',

      'SMP JNL',

      'O/DRAFT QTLY SERV. FEE',

      'INTEGRIS S/FALL PMNT',

      'ATHENA S/FALL PMNT',

      'merchant fees',

      'COLLECTIONS SERVICE',

      'CUFSS Levy',

      'New FTD',

      ' ',

      'D/E Credits',

      'D/E Debits',

      'D/E Credit Rtns',

      'D/E Debit Rtns',

      'D/E Aust Mil Bank',

      'D/E Aust Mil Bank',

      'M/C MEM CHEQ CR',

      'M/C ACC Transfer',

      'M/C Bank 80',

      'M/C Outward Transfer',

      'M/C Returns',

      'ATM Issuer DC - WDL + ENQ',

      'ATM EFT REF#',

      'ATM SETTLEMENT REDICARD',

      'ATM BRANCH CASH ADJ',

      'ATM FEES',

      'REDIATM SETTLEMENT',

      'ATM DARWIN',

      'ATM Stirling',

      'ATM Robertson',

      'ATM HOLSWORTHY',

      'ATM Edinburgh',

      'Kapooka ATM',

      'Enogerra ATM',

      'Navy Canteen',

      'Larrakeyah ATM',

      'Cerberus ATM',

      'Puckapunyal ATM',

      'Watson ATM',

      'Albatross ATM',

      'Lavarack ATM',

      'Laverton ATM',

      'ATH SUBSERVICER FEE',

      'ATH DISTRIBUTION',

      'New ATM',

      'Branch Cash',

      'LOAN SEC',

      'LOAN FUNDINGS',

      'VISA IBS RV Fee',

      'VISA')='Interest Due TPS',0.00,

      if(ValueList('Swift Transfer In','Swift Transfer Out',

      'Overdraft Interest',

      'Interest Due TPS',

      'Interest Due 11AM (S10)',

      'Interest Due FTD (I6)',

      'Interest Due Main (S1)',

      'Term Maturity Funds',

      '11AM TRANSFER',

      ' ',

      ' ',

      'Cuscal Sec Dep Int',

      'TPS Funds',

      'TPS Interest',

      'TWT Interest',

      'ABACUS',

      'CUSCAL Dividend',

      'CBS Fee',

      'BPAY',

      'Bank Balance Transfer',

      'Sun Daily',

      'Sun Pro Monthly',

      'DC FEE INCORRECT REV',

      'SMP JNL',

      'O/DRAFT QTLY SERV. FEE',

      'INTEGRIS S/FALL PMNT',

      'ATHENA S/FALL PMNT',

      'merchant fees',

      'COLLECTIONS SERVICE',

      'CUFSS Levy',

      'New FTD',

      ' ',

      'D/E Credits',

      'D/E Debits',

      'D/E Credit Rtns',

      'D/E Debit Rtns',

      'D/E Aust Mil Bank',

      'D/E Aust Mil Bank',

      'M/C MEM CHEQ CR',

      'M/C ACC Transfer',

      'M/C Bank 80',

      'M/C Outward Transfer',

      'M/C Returns',

      'ATM Issuer DC - WDL + ENQ',

      'ATM EFT REF#',

      'ATM SETTLEMENT REDICARD',

      'ATM BRANCH CASH ADJ',

      'ATM FEES',

      'REDIATM SETTLEMENT',

      'ATM DARWIN',

      'ATM Stirling',

      'ATM Robertson',

      'ATM HOLSWORTHY',

      'ATM Edinburgh',

      'Kapooka ATM',

      'Enogerra ATM',

      'Navy Canteen',

      'Larrakeyah ATM',

      'Cerberus ATM',

      'Puckapunyal ATM',

      'Watson ATM',

      'Albatross ATM',

      'Lavarack ATM',

      'Laverton ATM',

      'ATH SUBSERVICER FEE',

      'ATH DISTRIBUTION',

      'New ATM',

      'Branch Cash',

      'LOAN SEC',

      'LOAN FUNDINGS',

      'VISA IBS RV Fee',

      'VISA')='Interest Due 11AM (S10)',Sum({1<Customer_Name={"I*"},Column_D = {'11AM'}>}Column_E),

       

       

      if(ValueList('Swift Transfer In','Swift Transfer Out',

      'Overdraft Interest',

      'Interest Due TPS',

      'Interest Due 11AM (S10)',

      'Interest Due FTD (I6)',

      'Interest Due Main (S1)',

      'Term Maturity Funds',

      '11AM TRANSFER',

      ' ',

      ' ',

      'Cuscal Sec Dep Int',

      'TPS Funds',

      'TPS Interest',

      'TWT Interest',

      'ABACUS',

      'CUSCAL Dividend',

      'CBS Fee',

      'BPAY',

      'Bank Balance Transfer',

      'Sun Daily',

      'Sun Pro Monthly',

      'DC FEE INCORRECT REV',

      'SMP JNL',

      'O/DRAFT QTLY SERV. FEE',

      'INTEGRIS S/FALL PMNT',

      'ATHENA S/FALL PMNT',

      'merchant fees',

      'COLLECTIONS SERVICE',

      'CUFSS Levy',

      'New FTD',

      ' ',

      'D/E Credits',

      'D/E Debits',

      'D/E Credit Rtns',

      'D/E Debit Rtns',

      'D/E Aust Mil Bank',

      'D/E Aust Mil Bank',

      'M/C MEM CHEQ CR',

      'M/C ACC Transfer',

      'M/C Bank 80',

      'M/C Outward Transfer',

      'M/C Returns',

      'ATM Issuer DC - WDL + ENQ',

      'ATM EFT REF#',

      'ATM SETTLEMENT REDICARD',

      'ATM BRANCH CASH ADJ',

      'ATM FEES',

      'REDIATM SETTLEMENT',

      'ATM DARWIN',

      'ATM Stirling',

      'ATM Robertson',

      'ATM HOLSWORTHY',

      'ATM Edinburgh',

      'Kapooka ATM',

      'Enogerra ATM',

      'Navy Canteen',

      'Larrakeyah ATM',

      'Cerberus ATM',

      'Puckapunyal ATM',

      'Watson ATM',

      'Albatross ATM',

      'Lavarack ATM',

      'Laverton ATM',

      'ATH SUBSERVICER FEE',

      'ATH DISTRIBUTION',

      'New ATM',

      'Branch Cash',

      'LOAN SEC',

      'LOAN FUNDINGS',

      'VISA IBS RV Fee',

      'VISA')='Interest Due FTD (I6)',Sum({1<Customer_Name={"I*"},Column_D = {"S*"}>}Column_E)

      ))))))

       

       

       

      Thanks & Best regards,

      Ranjit Kakade.

        • Re: Is there any specific limitations for number of Measures Values we can pass through Valuelist Function??
          Digvijay Singh

          What do you mean by unable to pass, as I see you have mentioned only 6 measures in your expression, also I think your expression can be simplified using pick/match. Something like below. Why do you have duplicate values in value list? I see more than one '' entries as well.

           

          Pick(Match(

               Valuelist(

          'Swift Transfer In','Swift Transfer Out','Overdraft Interest','Interest Due TPS','Interest Due 11AM (S10)','Interest Due FTD (I6)','Interest Due Main (S1)','Term Maturity Funds','11AM TRANSFER',' ',' ','Cuscal Sec Dep Int','TPS Funds','TPS Interest','TWT Interest','ABACUS','CUSCAL Dividend','CBS Fee','BPAY','Bank Balance Transfer','Sun Daily','Sun Pro Monthly','DC FEE INCORRECT REV','SMP JNL','O/DRAFT QTLY SERV. FEE','INTEGRIS S/FALL PMNT',

          'ATHENA S/FALL PMNT','merchant fees','COLLECTIONS SERVICE','CUFSS Levy','New FTD',' ','D/E Credits','D/E Debits','D/E Credit Rtns','D/E Debit Rtns','D/E Aust Mil Bank','D/E Aust Mil Bank','M/C MEM CHEQ CR','M/C ACC Transfer','M/C Bank 80','M/C Outward Transfer','M/C Returns','ATM Issuer DC - WDL + ENQ','ATM EFT REF#',

          'ATM SETTLEMENT REDICARD','ATM BRANCH CASH ADJ','ATM FEES','REDIATM SETTLEMENT','ATM DARWIN',

          'ATM Stirling','ATM Robertson','ATM HOLSWORTHY','ATM Edinburgh','Kapooka ATM','Enogerra ATM','Navy Canteen',

          'Larrakeyah ATM','Cerberus ATM','Puckapunyal ATM','Watson ATM','Albatross ATM','Lavarack ATM','Laverton ATM',

          'ATH SUBSERVICER FEE','ATH DISTRIBUTION','New ATM','Branch Cash','LOAN SEC','LOAN FUNDINGS',

          'VISA IBS RV Fee','VISA'),

          'Swift Transfer In','Swift Transfer Out','Overdraft Interest','Interest Due TPS','Interest Due 11AM (S10)','Interest Due FTD (I6)','Interest Due Main (S1)','Term Maturity Funds','11AM TRANSFER',' ',' ','Cuscal Sec Dep Int','TPS Funds','TPS Interest','TWT Interest','ABACUS','CUSCAL Dividend','CBS Fee','BPAY','Bank Balance Transfer','Sun Daily','Sun Pro Monthly','DC FEE INCORRECT REV','SMP JNL','O/DRAFT QTLY SERV. FEE','INTEGRIS S/FALL PMNT',

          'ATHENA S/FALL PMNT','merchant fees','COLLECTIONS SERVICE','CUFSS Levy','New FTD',' ','D/E Credits','D/E Debits','D/E Credit Rtns','D/E Debit Rtns','D/E Aust Mil Bank','D/E Aust Mil Bank','M/C MEM CHEQ CR','M/C ACC Transfer','M/C Bank 80','M/C Outward Transfer','M/C Returns','ATM Issuer DC - WDL + ENQ','ATM EFT REF#',

          'ATM SETTLEMENT REDICARD','ATM BRANCH CASH ADJ','ATM FEES','REDIATM SETTLEMENT','ATM DARWIN',

          'ATM Stirling','ATM Robertson','ATM HOLSWORTHY','ATM Edinburgh','Kapooka ATM','Enogerra ATM','Navy Canteen',

          'Larrakeyah ATM','Cerberus ATM','Puckapunyal ATM','Watson ATM','Albatross ATM','Lavarack ATM','Laverton ATM',

          'ATH SUBSERVICER FEE','ATH DISTRIBUTION','New ATM','Branch Cash','LOAN SEC','LOAN FUNDINGS',

          'VISA IBS RV Fee','VISA'),

          Sum({1<FLAG ={'POSITIVE'},Column_D={"I*"}>}Column_E),

          Sum({1<FLAG ={'NEGATIVE'},Column_D={"I*"}>}Column_E),

          Sum({1<Column_D={ "O*"}>}Column_E),

          0.00,

          Sum({1<Customer_Name={"I*"},Column_D = {'11AM'}>}Column_E),

          Sum({1<Customer_Name={"I*"},Column_D = {"S*"}>}Column_E)