Syntax Help

regowins — Thu, 23 May 2013 21:43:33 GMT

Hi,

I need help with syntax in a chart exprssion.

The original fields used to be Ledger_Amt_USD and Ledger_Amt_Base

There is also a field called Currency_Field which has two values, BASE & USD.

The chart expression use to be Ledger_Amt_ $(=minstring(Currency_Field)) ....puts 'base' or 'usd' at the end of ledger_amt based on selection.

I had to change Ledger_Amt_USD to [Ledger Amt USD] and Ledger_Amt_Base to [Ledger Amt Base]. Is it possible to add 'Base' and 'USD' based on selection like before?

Thanks!

Re: Syntax Help

swuehl — Thu, 23 May 2013 22:54:36 GMT

Just give it a try:

[Ledger Amt $(=minstring(Currency_Field))]

The dollar sign expansion should work out also with your new field names.

topic Syntax Help in QlikView

Syntax Help

Re: Syntax Help