Comma breaks set analysis expression in an Inline table load

NickHoff — Tue, 19 Feb 2019 16:26:26 GMT

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?

Re: Comma breaks set analysis expression in an Inline table load

rwunderlich — Tue, 19 Feb 2019 16:46:30 GMT

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

Re: Comma breaks set analysis expression in an Inline table load

NickHoff — Tue, 19 Feb 2019 18:49:37 GMT

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

topic Comma breaks set analysis expression in an Inline table load in QlikView

Comma breaks set analysis expression in an Inline table load

Re: Comma breaks set analysis expression in an Inline table load

Re: Comma breaks set analysis expression in an Inline table load