How to aggregate date

[Anonymous]

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 .

[martin59]

Hi,

You have to try this :

For WeekDayAvg

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

For WeekEndAvg

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

[Anonymous]

Hi Martin,

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

Thanks,

Samay