Qlik Community

Qlik Sense App Development

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

Announcements
See why Qlik is recognized as a Leader for the 10th year in a row – and discover how Qlik can help put your business in the lead. Get Report
Highlighted
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)

Highlighted
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?