topic Re: Click Donut KPI is Impacting in QlikView

Click Donut KPI is Impacting

selvakumara — Thu, 09 Nov 2017 19:55:21 GMT

I have Donut And KPI .

Donut - The donut have sub categories

KPI - It will display the total based on selection.

But, if i select any sub- categories in the Donut KPI also changing. Even I i have ignore all selections

My Expression :

Donut :

Measure : Count({$<[Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

Dimension : it will display sub categ of "xcvxcvxcv' "

KPI :

Count({1<[Month]={$(TestMultipleMonths)},[Group]=P([Group]),[Name] =P([Name]),[Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

Any Idea?

Thanks in advance.

Re: Click Donut KPI is Impacting

sunny_talwar — Thu, 09 Nov 2017 19:58:46 GMT

You don't want selections to impact donut? May be this

Count({1<[Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

Re: Click Donut KPI is Impacting

selvakumara — Fri, 10 Nov 2017 09:05:54 GMT

I want donut selection don't impact on KPI.

KPI :

Count({1<[Month]={$(TestMultipleMonths)},[Group]=P([Group]),[Name] =P([Name]),[Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

Re: Click Donut KPI is Impacting

sunny_talwar — Fri, 10 Nov 2017 12:13:05 GMT

May be try this

Count({1<[Month]={$(TestMultipleMonths)}, [Group] = $::[Group], [Name] = $::[Name], [Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)

Also, how do you define TestMultipleMonths? Is it an expression? If it is, then you might have to ignore all your selections within that variable's definition also

Re: Click Donut KPI is Impacting

selvakumara — Fri, 10 Nov 2017 19:10:37 GMT

if i selected multiple months [Month] = 2017-07,2017-08..............2017-11 means

TestMultipleMonths Calculation

=Concat( DISTINCT chr(39)&(Left([Month],4)-1)&'-'&Right([Month],2)&chr(39) , ',')

TestMultipleMonths - It will give values like '2016-07,2016-08..............2016-11'

Then I have used

Count({1<[Month]={$(TestMultipleMonths)}, [Group] = $::[Group], [Name] = $::[Name], [Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records).

Still KPI is changing, How can i apply

Thanks in advance.

Re: Click Donut KPI is Impacting

sunny_talwar — Fri, 10 Nov 2017 19:41:21 GMT

How about you try this

Count({1<[Month]=$::Month, [Group] = $::[Group], [Name] = $::[Name], [Mid-Group]={'xcvxcvxcv'}>} DISTINCT Records)