Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

KPI is not working in QlikSense.

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

sub2u444

2 Replies
MVP
MVP

Re: KPI is not working in QlikSense.

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

Not applicable

Re: KPI is not working in QlikSense.

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