topic Re: Date Function Challenges in QlikView

Date Function Challenges

Sun, 25 May 2014 19:54:46 GMT

Friends/Colleagues,

I will feel much obliged if you please provide Date Function to calculate the following.

How can I accomplish the following by each YEAR (2011 - 2012) and MONTH ( 1-12) on a Bar Chart?

Q1. Aggregate/Sum of "No Of Hits" for the "Previous Day"? E.g. Assuming today is 12/20/2011 it would be "6"

Q2. Aggregate/Sum of "No of Hits" for the "Month to Date"? E.g. Assuming today is 12/20/2011 it would be "18"

Q3. Aggregate/Sum of "No of Hits" for the "Year to Date"? E.g. Assuming today is 12/20/2011 it would be "21"

Date	No Of Hits
11/18/2011	1
11/19/2011	2
12/1/2011	3
12/5/2011	4
12/18/2011	5
12/19/2011	6
12/20/2011	0

Thank You. Happy Memorial Day

MBBS

Note: Please see attchment for more example

Re: Date Function Challenges

hic — Mon, 26 May 2014 20:08:22 GMT

First, you need to create a master calendar, i.e. an additional table with all date attributes. See more here and search on the forum for a master calendar.

Secondly, you should create a field "DagsAgo" in your master calendar, that you can use for your first question. See more here.

Thirdly, you should create flags in your calendar, e.g. "IsInYTD", that mark whether this day is within the year/month to date. See more here or search the forum for ytd or yoy.

HIC

Re: Date Function Challenges

Tue, 27 May 2014 14:08:16 GMT

Dear Mr. Cronström,

I highly appreciated your quick response. I will look into your suggestions

and make a sincere effort to solve my problem.

I am really happy to take a note of the fact that this community is

really/truly active and someone is always out there to look into unanswered

questions/issues and ready to help.

Thank you and may GOD bless you.

With Kindest Regards,

Sam David

On Mon, May 26, 2014 at 3:08 PM, Henric Cronström