Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
HI Subba,
are you able to upload your QVF please?
Andy
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),'')
I am sorry.
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))
Thanks Vijay.
Its working fine.