topic Re: Average Daily Value in QlikView

Average Daily Value

vvvvvvizard — Tue, 09 Jul 2019 13:01:31 GMT

SAY MY expression IS sum(sALES)

i have a week cycle week ( so i need to divide by number of days in that week )

I have a half year cycle , so i need to divide by number of days in that year-half

Year cycle , i need to divide by number of days in year

quarter cycle .. so i need to divide by number of days in that quarter

each is a separate expression for each cycle using a condition

The latest period in year for eg has a few days as its not year end , that is the complication so i cant just say 365

Re: Average Daily Value

acsaggar — Tue, 09 Jul 2019 16:29:34 GMT

It seems to me you need to create a master calendar with flags (0/1) for the various dates.

E.g

isinQTD

isinYTD

isinMTD

isinCurrweek

these flags should exist down to the day level so each day has a flag for every time period. then you can use a set analysis expression for each flag, and aggregate using avg.

Re: Average Daily Value

Brett_Bleess — Wed, 31 Jul 2019 18:29:09 GMT

Below is a link to a query I ran on the Design Blog that might be of help along with what the other posted provided:

https://community.qlik.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&filter=location&location=blog-board:qlik-design-blog&q=calendar

Hopefully one or more of the posts may help you get to where you need to be here.

Regards,
Brett