topic Re: editing aggr expression in QlikView

editing aggr expression

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

Hi Everyone

Can someone help me how can i modify below expression

with this condition: if HOURS is >6 but <12

Sum({<WEEK = {"$(=MaxString(WEEK))"}>}Aggr(If(Count({<WEEK = {"$(=MaxString(WEEK))"}>}DEVICE)=1,1,0) and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS)<=6, DEVICE))*-1

Thanks and hope to hear from you.....

Re: editing aggr expression

Anonymous — Fri, 14 Jul 2017 14:58:30 GMT

Sum({<WEEK = {"$(=MaxString(WEEK))"}>}Aggr(If(Count({<WEEK = {"$(=MaxString(WEEK))"}>}DEVICE)=1,1,0) and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS)<=12 and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS)>6, DEVICE))*-1

Re: editing aggr expression

sunny_talwar — Fri, 14 Jul 2017 15:04:26 GMT

May be this

Sum({<WEEK = {"$(=MaxString(WEEK))"}>} Aggr(

If(Count({<WEEK = {"$(=MaxString(WEEK))"}>}DEVICE) = 1 and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS) > 6 and Only({<WEEK = {"$(=MaxString(WEEK))"}>}HOURS) < 12,1,0), DEVICE))*-1

Re: editing aggr expression

Anonymous — Fri, 14 Jul 2017 15:26:38 GMT

Hi Sunny & Robin,

Both your formula works well..

thanks and have a good day!