Variable in Chart Formular

carolin01 — Thu, 12 Dec 2013 14:22:35 GMT

Hello together,

I´m trying to write the following formular:

sum({$<FYear = {$(vPreviousFY)}, FDay =< {'$(vFDay)}', OrderPhase_Desc = {'Revenue'}>}NettAmount$(vCurrency))

The variable vFDay indicates a number e.g. 74. This is the number of the Fiscal Day that I assigned to the day yesterday according to our corporate calendar. Also in the previous year there has been a day with a day number 74 assigned to it. I´m now trying to calculate the sum of the previsous year where the FDay =< 74.

How can I do calculations including the =< sign?

Many thanks for all kind of ideas.

Best regards

Carolin

Re: Variable in Chart Formular

michael_maeuser — Thu, 12 Dec 2013 14:25:35 GMT

um({$<FYear = {$(vPreviousFY)}, FDay = {'<$(vFDay)'}, OrderPhase_Desc = {'Revenue'}>}NettAmount$(vCurrency))

Re: Variable in Chart Formular

carolin01 — Thu, 12 Dec 2013 15:40:04 GMT

Thank you - perfect!!!

topic Re: Variable in Chart Formular in QlikView

Variable in Chart Formular

Re: Variable in Chart Formular

Re: Variable in Chart Formular