KPI is not working

[#1]

Hi Folks,

Please find the below QikSene app snippet.

When i am trying to select Type as "Type2", In Type1 and Type3 is shown as "0". But here its showing some value. Its an error.

please correct the below code..

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),'')

Regards,

Sub2u444

[awhitfield]

HI Subba,

are you able to upload your QVF please?

Andy

[sunny_talwar]

Not sure, but may be this:

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),'')

[#4]

Hi Sunny,

Thanks for Your reply.

Its not working.

sub2u444‌

[#5]

I am sorry.

[#6 · Accepted solution]

Try this

=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))

[#7]

Thanks Vijay.

Its working fine.