Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How to make KPIs change depending on clicks made on a graph?

Hi,

I have 3 KPIs that show, Unique Visitors, page views and Visits. I have data for each of these KPIs for the last 13 months but only want one months worth of data to show at any one time. I have a simple line graph plotting the changes M.o.M for these values, that I want to be able to click to select a month on the graph and the KPIs to the side then change to reflect that month. Does anyone know how to do this?

The current formula I have for the KPIs (as I want it to default to the latest month if no selection is made) are as follows:

(Sum(IF((Type='Unique Visitors' and [Month]='01/07/2016'),[Value])))

Is this even possible?

Thank you!

2 Replies

Re: How to make KPIs change depending on clicks made on a graph?

Try something like this:

Sum({<Type = {'Unique Visitors'}, Date = {"$(=Max(Date))"} [Value])

katharinakostka
New Contributor III

Re: How to make KPIs change depending on clicks made on a graph?

Hi Louisa,

yes, it should be possible.

What Sunny did, was to change your formula using what is called "Set Analysis".

I too think, that this should do the trick.

However I still have a question: Do you have full date values (including day) in the field called [Month]?

I ask, because if this would be the case, I find it most likely, that you propably might not have a [Date] field, as suggested for use as in Sunny's example and might have to adapt it a little bit by changing "Date" to "Month". But if you have a [Date] field, you will do just fine.