Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Linking KPI to sheet depending upon the KPI itself

Hi All,

I have 4 KPIs on my main sheet. All these KPIs are being shown based on calculations done in variables.

Now i want to link these KPIs to a bar chart on another sheet.

Does qliksense has any such functionality through which the selected KPI leads to that very bar chart ?

I will explain via example.

img1.jpg

All these 4 KPI are shown using variables. The maximum 4 values are calculated in variables and are then shown. The names Rule1, Rule2 and so on are stored in 4 different vaiables based on max 4 values.

Now if user clicks on KPI for Rule1, another sheet opens up showing bar graph for rule1.

img2.jpg

Again the heading Rule1 is a variable.

Now the problem is that i want this bar graph to dynamically to Rule2 if user clicks the KPI for Rule2 on the first sheet.

Is this achievable in qlik sense?

Please guide me in this regard.

Thanks in advance.

Disha Ahuja

3 Replies
paul_scotchford
Valued Contributor

Re: Linking KPI to sheet depending upon the KPI itself

‌hhave you looked at the navigation options for the kph object? This should give you what you wish to achieve if I understand the question correctly .

balrajahlawat
Esteemed Contributor

Re: Linking KPI to sheet depending upon the KPI itself

Check this, may be handy for you:

Qlik Branch

igdrazil
Contributor III

Re: Linking KPI to sheet depending upon the KPI itself

If i understand you correct, you want your KPI to switch to different sheets, with bar charts on them, depending on your value in each specific KPI.

As given by Qlik Sense you can't make the link-function dependent on your KPI value. You could use balrajahlawat‌ 's link to the Sheet Navigation, and place a navigation object under each KPI to link to different sheets, but even with this extension you can't make it dependent on a value, to which sheet you go (at least for now).

Hope i could help you.

Regards

Chris

Community Browser