topic Re: Set Analysis greater than now() in QlikView

Set Analysis greater than now()

Wed, 02 Dec 2015 15:43:32 GMT

Hiya,

Can anyone help please before I go crazy!

I have the following expression as cumlative:

=count({<[ArriveDate]= {'$(vCurrentDayGB)'} >} [ED_Att_No])

However as its cumlative, the line carrys on the the rest of the day eventhough the event hasnt happened yet. Therefore I have created the following and none of them work!!!!! And I cant see why?

count({<[ArriveDate]= {'$(vCurrentDayGB)'} , [Hour]={"<='$(vHour)'"}>} [ED_Att_No])

=count({<[ArriveDate]= {'$(vCurrentDayGB)'} , [Hour]{"<='$(=hour(now()))'"} >} [ED_Att_No])

Re: Set Analysis greater than now()

sunny_talwar — Wed, 02 Dec 2015 17:42:13 GMT

Try this may be:

=Count({<[ArriveDate]= {'$(vCurrentDayGB)'}, [Hour] = {"$(='<=' & Hour(Now()))"}>} [ED_Att_No])

Re: Set Analysis greater than now()

Gysbert_Wassenaar — Thu, 03 Dec 2015 06:10:08 GMT

Just remove the single quotes around $(=hour(now())):

=count({<[ArriveDate]= {'$(vCurrentDayGB)'} , [Hour]{"<=$(=hour(now()))"} >} [ED_Att_No])

Re: Set Analysis greater than now()

raman_rastogi — Thu, 03 Dec 2015 08:30:15 GMT

=Count({<[ArriveDate]= {'$(vCurrentDayGB)'}, [Hour] = {'$(='<=' & Hour(Now()))'}>} [ED_Att_No])

Re: Set Analysis greater than now()

Anonymous — Thu, 03 Dec 2015 08:35:22 GMT

may be this:

=count({<[ArriveDate]= {'=$(=vCurrentDayGB)'} , [Hour]={'<=$(=hour(now()))'} >} [ED_Att_No])

Re: Set Analysis greater than now()

Thu, 03 Dec 2015 14:26:51 GMT

Hi,

these really dont work. Have realised if i remove the rolling average, the attendance line stops at the current hour, which is what i want.

However i need the rolling average line as well. there must be a solution?

Re: Set Analysis greater than now()

sunny_talwar — Thu, 03 Dec 2015 14:41:06 GMT

Not sure I understand, which chart is working and which one isn't??? Seems to me that both the charts are stopping at 20 hour

Re: Set Analysis greater than now()

Thu, 03 Dec 2015 14:50:36 GMT

its the attendance line that is wrong. that line should stop at 14.00, as 15-20 hours hasnt happened yet. whereas it does flat.

The average attendance is fine.

Re: Set Analysis greater than now()

Thu, 10 Dec 2015 13:53:06 GMT

its the attendance line that is wrong. that line should stop at 14.00, as 15-20 hours hasnt happened yet. whereas it does flat.

The average attendance is fine.