Comma breaks set analysis expression in an Inline table load

[NickHoff]

Hello,

I have the following INLINE table with a simple expression which works correctly when I create a SET variable = "=@SurgicalNetRev" .

NetRevenueOption:
LOAD * INLINE [
    @NetRevOptionNum, NetRevOption, @NetRevField, @IPNetRevField, @OPNetRevField, @GrossRevField, @IPGrossRevField, @OPGrossRevField, @NRCases, @SurgicalNetRev
    1, Cash Reimbursement, ActualReimbursement, IPActualReimbursement, OPActualReimbursement, ChargesWCash, IPChargesWCash, OPChargesWCash, CashCases, SUM({$<SurgicalCases = {1}>}ActualReimbursement)
    2, Standard Reimbursement, StandardReimbursement, IPStandardReimbursement, OPStandardReimbursement, GrossPatientRevenue, IPCharges, OPCharges, Cases, SUM({$<SurgicalCases = {1}>}StandardReimbursement)
    3, Expected Payment, GrossReimbursement, IPGrossReimbursement, OPGrossReimbursement, ChargesWExpReimb, IPChargesWExpReimb, OPChargesWExpReimb, ExpReimbCases, SUM({$<SurgicalCases = {1}>}GrossReimbursement)
    4, Cleared Payments, ClearedPayments, IPClearedPayments, OPClearedPayments, ClearedCharges, ClearedIPCharges, ClearedOPCharges, ClearedCases, SUM({$<SurgicalCases = {1}>}ClearedPayments)
];

My problem comes when I want to add more than one condition in my set analysis expression.  Adding a "," breaks apart the expression and my variable is set to only include the portion prior to the comma.

i.e.

SUM({$<SurgicalCases = {1}, CostedIND = {1}>}ActualReimbursement)

My set variable is SUM({$<Surgical={1}

How can I get the expression in the INLINE table to include everything including and after the comma?

[rwunderlich · Accepted solution]

I can suggest two alternatives:

1. Place single quotes around the value in the inline load. 

2. Use a different delimiter, for example |.  You would need to change all your commas and then add the clause:

delimiter is '|'

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[NickHoff]

I didn't realize I could use the delimiter for a single Inline.   The single quotes works as well.  Thank you Rob.