Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
OmarBenSalem
Esteemed Contributor

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)

OmarBenSalem
Esteemed Contributor

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. 

Community Browser