Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

kakaderanjit53
Contributor III

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

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

NoteSmiley TongueFB 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.

Tags (1)
1 Solution

Accepted Solutions
Digvijay_Singh
Honored Contributor III

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

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)




2 Replies
Digvijay_Singh
Honored Contributor III

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

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)




kakaderanjit53
Contributor III

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

Thanks alot Sir for providing simple but important solution.,was unable to recognize the same solution

earlier.

Community Browser