topic Re: Previoues Year value showing wrong in QlikView

Previoues Year value showing wrong

Rajesh — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to display current yr & previous value in Text object like below with current yr Selection(2018) value is correct but 2017 value not correct.

With 2017 Year selection its showing correct value=648

Text object expression is :

=Max(Year) & ': ' & Num(Count({<Year=, Quarter=, Month=, DateType={'Opened'},Incident_problem= {'Problem'}, Date={">=$(=YearStart(Max(Date))) <=$(=Max(Date))"}>}number), '#,##0')

& Chr(10) & (Max(Year)-1) & ': ' & Num(Count({<Year=, Quarter=, Month=, DateType={'Opened'},Incident_problem= {'Problem'}, Date={">=$(=YearStart(AddYears(Max(Date), -1))) <=$(=AddYears(Max(Date), -1))"}>}number), '#,##0')

Can any one suggest where i am doing wrong.

Thanks

Rajesh

Re: Previoues Year value showing wrong

sunny_talwar — Thu, 10 May 2018 11:42:30 GMT

May be try this

=Max(Year) & ': ' & Num(Count({<Year=, Quarter=, Month=, DateType={'Opened'},Incident_problem= {'Problem'}, Date={">=$(=YearStart(Max(Date))) <=$(=Max(Date))"}>}number), '#,##0')

Re: Previoues Year value showing wrong

Rajesh — Thu, 10 May 2018 11:51:30 GMT

Thanks bro..

its working

Re: Previoues Year value showing wrong

Rajesh — Thu, 10 May 2018 12:01:26 GMT

Hi Sunny,

In which scenario we should write this

Date={">=$(=YearStart(AddYears(Max(Date), -1))) <=$(=AddYears(Max(Date),-1))"}

Re: Previoues Year value showing wrong

sunny_talwar — Thu, 10 May 2018 12:03:08 GMT

If you want to show YTD previous year....