Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
Hi,
You have to try this :
For WeekDayAvg
avg( if ( WeekDay(Date) < 5 , Value ) )
For WeekEndAvg
avg( if ( WeekDay(Date) > 4 , Value ) )
Hi Martin,
Thank you for your reply. But this expression is not working.
Thanks,
Samay