topic Re: Working with a KPI object in QlikView

Working with a KPI object

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a drill down that has been created, now i want a KPI object to only display the value of the second selection. How can i achieve this. For instance, my drill-down has INDUSTRY - SECTOR, the user is to select an industry then a sector. But i just want the value of the sector to be displayed only.

Thank you

Re: Working with a KPI object

Anonymous — Tue, 28 Nov 2017 17:33:40 GMT

Put the expression that you are using in a text box and it will display the value.

For example

='The Value is ' & sum(Sales)

Re: Working with a KPI object

MK9885 — Tue, 28 Nov 2017 21:00:04 GMT

Maybe

If(Getselectedcount(INDUSTRY)=1,

Your expression Here))

Whenever a value from INDUSTRY field is selected, it would rather give you sum or count of Sector but if nothing is selected, the KPI would show null.

It would be helpful if you tell us what is your expression in KPI?

Re: Working with a KPI object

Anil_Babu_Samineni — Wed, 29 Nov 2017 01:25:19 GMT

Perhaps this?

If(GetCurrentField([Group Name of Drill]) = 'SECTOR' or GetSelectedCount(INDUSTRY)=1, Measure)

Re: Working with a KPI object

jyothish8807 — Wed, 29 Nov 2017 05:47:17 GMT

Hi Abraham,

Like this ?

Re: Working with a KPI object

jyothish8807 — Wed, 29 Nov 2017 05:53:03 GMT

Or like this as suggested above:

Re: Working with a KPI object

Anonymous — Wed, 29 Nov 2017 09:46:10 GMT

Company Name	Industry	Total
Company A	Financial Services	50
Company B	Consumer Goods	40
Company C	Consumer Goods	10
Company D	Entertainment	20

My drill down is:

Industry

Company Name

When a user clicks on the industry, it displays the names of companies in that industry. I want a KPI to display the value of Total for a company selected from the drill down not for the industry. !

Re: Working with a KPI object

Anil_Babu_Samineni — Wed, 29 Nov 2017 13:08:53 GMT

From this, Can you explain in Case study like if Industry is filter from user is "Consumer Goods" What output you are expecting in text box?

Re: Working with a KPI object

Anonymous — Wed, 29 Nov 2017 14:00:19 GMT

i want a situation where if you click on [Consumer Goods], Company B and Company C will appear. Then the value on the KPI object will be the Total of either Company B (40) or Company C(10) based on the user's final selection.