Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

‌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 .

Anonymous
Not applicable
Author

Check this, may be handy for you:

Qlik Branch

igdrazil
Creator III
Creator III

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