Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jordanhertl
New Contributor III

How to filter KPI to only one quarter of data?

Filter.png

I have two graphics here. The top one is showing an average of all 4 quarters. How do I filter it to only show the latest quarter (Q4 2017)?

Thanks!

4 Replies
zebhashmi
Valued Contributor

Re: How to filter KPI to only one quarter of data?

=only({<date = {Q4 2017}>}yourMasure)

jasonmomoa
Contributor

Re: How to filter KPI to only one quarter of data?

In this case, you'll need to use Set Analysis.

Take as example the top chart is displaying expression Avg([Sales]) while the bottom chart is displaying Sum([Sales]) by Quarter-Year.

The first one should be modified to Avg({<[Quarter-Year]={''Q4 2017"}>}[Sales]). However, does it make sense to have an average for just 1 value?

Hope the unser provided you some insights. Regards,

jordanhertl
New Contributor III

Re: How to filter KPI to only one quarter of data?

It would just be the average of 1 quarter vs 4. Not really 1 value, many values over 1 quarter.

So this would be in the Measure Expression I assume?

dwforest
Valued Contributor

Re: How to filter KPI to only one quarter of data?

Assuming the Quarter is driven off a master calendar and you don't want to have to re-work the KPI each quarter...

Something like:

Avg({<[Quarter-Year]={"=$(MaxString({[Date]=Today()})>} [Quarter-year])"}>} [Sales])

Community Browser