topic How to aggregate date in QlikView

How to aggregate date

Anonymous — Wed, 26 May 2010 11:26:26 GMT

Hi there,

i have to maintain one excel sheet where data is pasted daily. I have to take weekday avg.((mon + tue + wed + thu + fri ) / 5) and weekend day avg.((sat. + sun)/2) and weekly avg. I cant able to write expression that can do this in qlikview. please help me .

Re. :How to aggregate date

martin59 — Wed, 26 May 2010 11:32:09 GMT

Hi,

You have to try this :

For WeekDayAvg

avg( if ( WeekDay(Date) < 5 , Value ) )

For WeekEndAvg

avg( if ( WeekDay(Date) > 4 , Value ) )

Re. :How to aggregate date

Anonymous — Thu, 27 May 2010 11:24:22 GMT

Hi Martin,

Thank you for your reply. But this expression is not working.

Thanks,

Samay