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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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
Partner - Champion II
Partner - Champion II

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
Partner - Champion II
Partner - Champion II

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.