topic Re: KPI is not working in QlikSense. in App Development

KPI is not working in QlikSense.

Thu, 21 Apr 2016 20:24:24 GMT

Hi Folks,

I have a Temp Filter - Critical,Hot,Wild,Harm

when i select Critical, i want to show the Critical value in 2KPI's

please find the below queries..

Q1:-

=IF(Count({<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket)>0,

Count({<Temp={'Critical','Hot'},[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket))

Q2:-

=IF(Count({<[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket)>0,

Count({<[Type 1 Count]={'1'},WeekNo={">=$(=Max(WeekNo)-12)<=$(=Max(WeekNo))"}>}Ticket))

It was showing wrong values, Please correct me where i did mistake

sunny_talwar — Thu, 21 Apr 2016 20:43:53 GMT

When you say wrong values, what are you getting now? Value for both Critical and Hot?

Thu, 21 Apr 2016 20:47:56 GMT

yes.

if i select Temp as "Critical".

KPI1 is showing as 9.

KPI2 is showing as 1

but both showing same values.now showing wrong values..