Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Link a KPI with a row or a cell in a table

I guys,

I have a question. can i connect a KPI with the table in the left side? Like in the picture, when i click on the KPI Max(Hora_sal-Hora_ing) automatically select the correct row in the table or something like that.

Regards,

Gerd Neumann

Captura de pantalla 2015-11-18 a las 10.28.24 a.m..png

Tags (3)
4 Replies

Re: Link a KPI with a row or a cell in a table

Looks like QlikSense. You will get help, if you posted in Qliksense Place.

In QV, we can do like this.

If it is Text Box -> Actions Tab ->

Select Field -> Hora_sal-Hora_ing

Search String =Max(Hora_sal-Hora_ing)

brunobertels
Valued Contributor

Re: Link a KPI with a row or a cell in a table

Hello

Not available in Qliksense. But you can change the color of the cell or the line in your tab depending of kpi mesure.

Bruno

Employee
Employee

Re: Link a KPI with a row or a cell in a table

Not a KPI object but I think you can do this with a 'filter pane' object. It lacks the nice formatting however

In this scenario the field used for the filter is a measure calculation: 

max(  total aggr( sum(Sales) , Country) )

Capture.PNG

Capture2.PNG

Alternatively, you would need to use some extensions. to do the drilling.  you can use the single configurator API to call a qlik sense sheet and pass in a selection. But the custom KPI object would need to be well... custom to dynamically generate the right link.

reddys310
Honored Contributor II

Re: Link a KPI with a row or a cell in a table

Hi Gerd,

For the functionality you are looking for, you need to go ahead and build an extension. There is no such functionality available with the table but you have the leverage to build one for yourself.