Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Formula

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

3 Replies
Highlighted

Re: Formula

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Creator III
Creator III

Re: Formula

But still its giving the exact result

Highlighted
Creator III
Creator III

Re: Formula

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