Variables Display Garbage After - QB Advanced Reporting

[#1]

‌When I go to Ctrl-Alt-V, almost all the installed variables have "Garbage after". I do not see any errors. Here is a photo:

[#2]

!!!!! Zhihong !!!!! and everyone else!!!

Thank you so much!!!

if( ([Account.Account Type] = 'Income'  or [Account.Account Type] = 'Other Current Liability' or [Account.Account Type] = 'Equity') and [Transactions.Debit Or Credit] = 'Credit',Transactions.Amount,

          if( ( [Account.Account Type] = 'Assest' or [Account.Account Type] = 'Expense') and [Transactions.Debit Or Credit] = 'Debit', -Transactions.Amount,

          if( ([Account.Account Type] = 'Income' or [Account.Account Type] = 'Other Current Liability' or [Account.Account Type] = 'Equity') and [Transactions.Debit Or Credit] = 'Debit',-Transactions.Amount,

          if(([Account.Account Type] = 'Assest' or [Account.Account Type] = 'Expense') and [Transactions.Debit Or Credit] = 'Credit', -Transactions.Amount)))) - Transactions.Amount

Ok.  Novice alert.  I use Quickbooks and Advanced Reporting (through Qlik) is part of the package.  In Advanced Reporting, Quickbooks already populates the variables and they make it clear not to touch them.

Mistake!!!

In the end, what I did was learn my data fields.  To do this, I ran QlikView to generate every single field that my Quickbooks uses.  I then painstakingly went through each of entries from the pre-installed variables and reentered the above variable.  What a learning experience!!! 

The moral of the story is for me to know my data! 

The other take-away is to master the obvious first.

Lol

Thank you so much!!!

[engishfaque]

Dear Jonathan,

It would be nice if you use Match function instead of writing multiple OR logical operators. After using Match function in your expression it will looks like smart expression. Match example is given below,

if(Match([Classified Account Type], 'Income', 'Liability', 'Equity')...

Kind regards,

Ishfaque Ahmed

[#4]

If you are using this expression in variable, then put this whole expression in single quote.

At the end u need this as a string not calculation.

[Anonymous]

Yes, to using QV, the first and most important thing is to figure out your data and the data model after the load script.

And great that you figure this out.

Zhihong