topic Re: Script if/And expression in QlikView

Script if/And expression

ZoeM — Sat, 16 Nov 2024 04:55:49 GMT

Hi Community.

I am building a Key Performance Indicator in a text box and I want to set some parameters on the value shown (%).

If no Year is selected in the listbox available, I want the KPI to show this years current status, if a year is selected I want the KPI to be the selected years status.

This is my expression:

=If(IsNull(GetFieldSelections(Year)),( ((Sum([FDJ Final S/O])/Sum([FDJ Final NTEI]))*Sum([FDJ Final NTEI]))/sum([FDJ Final NTEI]) and Year=Year(Today())) )

But I am getting a zero value. Without setting the Year, I am getting an average of all years.

Any help rendered will be valuable.

Thanks!

Re: Script if/And expression

sunny_talwar — Wed, 19 Dec 2018 15:27:11 GMT

May be try this

=If(GetSelectedCount(Year) = 0,
 (
  (
   (
    Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final S/O])/
    Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final NTEI])
   )
   *
   Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final NTEI])
  )
  /
  Sum({<Year = {"$(=Year(Today()))"}>} [FDJ Final NTEI])
 ),
 (
  (
   (
    Sum([FDJ Final S/O])/
    Sum([FDJ Final NTEI])
   )
   *
   Sum([FDJ Final NTEI])
  )
  /
  Sum([FDJ Final NTEI])
 )
)

Re: Script if/And expression

ZoeM — Wed, 19 Dec 2018 16:27:48 GMT

Thanks Sunny. That worked as a charm.

I appreciate the speedy reply.