Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
jherrerae
New Contributor

KPI CY vs. PY

Hi all.

I'm trying to compare de number of POD's of any year vs. number of POD's of previous year.

But it doesn't work!!!

Any Year

=Count({$<Year={$(=Year(Fecha))}>}Viaje)

Previous Year:

=Count({$<Year={$(=(Year(Fecha)+1))}>}Viaje)

But the result is...

Captura.PNG

Tags (2)
3 Replies

Re: KPI CY vs. PY

Previous year should be -1

=Count({$<Year={$(=(Year(Fecha)-1))}>}Viaje)

jherrerae
New Contributor

Re: KPI CY vs. PY

Not, because "Fecha" is the date of the POD.

Anywey, Is the same result

Highlighted

Re: KPI CY vs. PY

Not sure I understand?