KPI is not working in QlikSense.

[#1]

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‌

[sunny_talwar]

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

[#3]

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