topic Re: KPI is not working in App Development

KPI is not working

Thu, 21 Apr 2016 10:52:12 GMT

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 — Thu, 21 Apr 2016 10:53:47 GMT

HI Subba,

are you able to upload your QVF please?

Andy

sunny_talwar — Thu, 21 Apr 2016 10:55:55 GMT

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

Thu, 21 Apr 2016 11:05:44 GMT

Hi Sunny,

Thanks for Your reply.

Its not working.

Thu, 21 Apr 2016 11:05:59 GMT

I am sorry.

Thu, 21 Apr 2016 11:33:04 GMT

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

Thu, 21 Apr 2016 12:29:00 GMT

Thanks Vijay.

Its working fine.