topic Re: YTD expression in QlikView

YTD expression

ilanbaruch — Thu, 04 Apr 2019 07:59:53 GMT

hi all

in my model i have a kpi object with bellow expression :

Count({$<StatusFlag={'1'},YYYY = {$(#=max(YYYY)-1)},YearToDate={'YTD'} > } distinct order_id)

it is working well when changing values in year field, but when adding Quarter to selection it is retrieving 0 value

i dont want to add <Qurter=> to ignore quarter selection, is it possible to adapt the expression to retrieve the correct value ?

advanced thanks

Re: YTD expression

sunny_talwar — Thu, 04 Apr 2019 12:57:03 GMT

Is your Quarter field includes both Quarter and Year or is it just Quarter? Meaning, do you store it like this Q1 or Q12019? If it stored with year, do you have another Quarter field which isn't stored with year?

Re: YTD expression

ilanbaruch — Wed, 10 Apr 2019 06:35:59 GMT

Hi Sunny,

i have both with and without year

YearQuarterNum- 20181,20182,20183

Quarter - Q1,Q2,Q3

Re: YTD expression

sunny_talwar — Wed, 10 Apr 2019 11:23:15 GMT

And you are making selection in Quarter field and not YearQuarterNum field?