Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!

1 Solution

Accepted Solutions
OmarBenSalem

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)

View solution in original post

4 Replies
zebhashmi
Specialist
Specialist

can you explain a little bit more?

sasiparupudi1
Master III
Master III

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

Current

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

Previous

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

OmarBenSalem

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)

Anonymous
Not applicable
Author

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