topic Re: Formula in QlikView

Formula

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI can someone guide me to correct this formula ?

=IF(num

(Interval

(Date

(Min({$<Date={">==$(StartDate)<=$(EndDate)"},

Department-={'Finance'} ,

Server= P(Windows)

>}FixedDate),'YYYY-MM-DD hh:mm')

Date(min

({$<Date = {">=$(StartDate)<=$(EndDate)"},

//Lead_Type={'NEW'},

Server= P(Windows)

>}ActaulTime),'YYYY-MM-DD hh:mm'),'mm'))< 1/24/60*30,

Count({$<Date = {">=$(StartDate)<=$(EndDate)"},

Server= P(Windows)

>}INstallations)

becuase under expression after >}FixedDate),'YYYY-MM-DD hh:mm')

nothing is turning into blue , Date, count are graded out and appears to be noramll text

Thanks

Re: Formula

jonathandienst — Tue, 20 Sep 2016 09:50:13 GMT

Are StartDate and EndDate fields that vary from row to row in your chart/table? If so, then the set expression will not work, as the expression is evaluated once for the whole chart and not on a row by row basis.

Also remember that QV field bames are case sensitive, so INstallation is not the same field as Installation.

Re: Formula

smilingjohn — Tue, 20 Sep 2016 09:53:57 GMT

But still its giving the exact result

Re: Formula

smilingjohn — Tue, 20 Sep 2016 09:55:50 GMT

HI jonanthan ,

Now i want to show how many times the installation was made that is count of installations , which are less than 30 mints .

but its not working