# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
New Contributor II

## Selecting Only Current Year Data for KPI

Beginner 101 questions:  How do I filter a KPI to just show the Current Year Data?  There is a Time Dimension with CY & PY for Current & Prior Year - see bar chart below.  When I select the measure for the KPI view it is summing both the CY & PY.  How do I set up to only sum the Current Year in the KPI then show a 2nd measure for the % change of CY Conversions / PY Conversions?

Thank you!

Tags (2)
1 Solution

Accepted Solutions
Partner

## Re: Selecting Only Current Year Data for KPI

I think that u have a dimension "Time" containing 2 Values? CY and LY?

then in ur KPI, for CY

change ur measure

from:

sum(Measure)

to

for current

sum({<Time={'CY'}>}Measure)

for last

sum({<Time={'LY'}>}Measure)

4 Replies
Valued Contributor

## Re: Selecting Only Current Year Data for KPI

can you explain a little bit more?

Honored Contributor III

## Re: Selecting Only Current Year Data for KPI

If your CY and PY are flags in your calendar,then

Current

Sum({<CY={1}>} Conversions)

Previous

Sum({<PY={1}>} Conversions)

Partner

## Re: Selecting Only Current Year Data for KPI

I think that u have a dimension "Time" containing 2 Values? CY and LY?

then in ur KPI, for CY

change ur measure

from:

sum(Measure)

to

for current

sum({<Time={'CY'}>}Measure)

for last

sum({<Time={'LY'}>}Measure)

New Contributor II

## Re: Selecting Only Current Year Data for KPI

Thanks Omar.  That did it.  Appreciate the 101 lesson.