please could some one help me. I have posted this a couple of days before but no luck.
I am so stuck and very new to qlikview.
I have a table showing volumes per interval (hour) for June month per weekday (i.e Mon, tues, wed etc). I know what to know on average for the month of June how many volumes I received on a Mon, Tue, Wed etc. In example below June month got 4 Fridays therefore on Fridays we receive on average 29 calls between 8 and 9 and on average 44 calls between 9 and 10.
how do I write it in my expression field.
thank you very much
|Hour_Int||volume||Ave per day|