Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
I didn't realize I could use the delimiter for a single Inline. The single quotes works as well. Thank you Rob.