Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
rbielicke
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?  Screen Shot 2018-03-18 at 6.06.13 PM.pngScreen Shot 2018-03-18 at 6.06.18 PM.png

Thank you!

Tags (2)
1 Solution

Accepted Solutions
Partner
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
zebhashmi
Valued Contributor

Re: Selecting Only Current Year Data for KPI

can you explain a little bit more?

sasiparupudi1
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
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)

rbielicke
New Contributor II

Re: Selecting Only Current Year Data for KPI

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