topic Period chart, calendar in QlikView

Period chart, calendar

Anonymous — Thu, 22 Dec 2011 09:57:33 GMT

I want to create a periode selection that shows year, month, week and then date and days.

Something like the picture below.

mon	tue	wed	thu	fri	sat	sun
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21

My problem is that I cant figure out how to do that.

And yes I have tried the calendar object, but that one is just ugly. I do not like it, and it does not give me the dayname.

Also I want to create this in a container and I want to use it with both the date and dayofyear.

Any one know how to solve this?

Dan

Anonymous — Thu, 22 Dec 2011 11:28:46 GMT

You can disregard this. I found a way to solve it.

Dan

Thu, 01 Mar 2012 16:13:32 GMT

How did you solve it?

Im looking to do somthing like that, but I would also display a calculated sales number on each date i the calender.

Anonymous — Fri, 02 Mar 2012 08:15:25 GMT

Actually all I did was that I created a pivot chart with two dimensions and one expression.

The two dimensions I use is week and dayname.

Expression is weekdate. =WeekDate

Week(ActualStartTime) as Week,

Day(ActualStartTime) as WeekDate,

WeekDay(ActualStartTime) as DayName

Then I left click the DayName and drag it to the top of the chart.(Not sure what that is called)

One problem with this method is that if you do not have any sales on a given day, that day will not appear in the chart.

I assume I could correct this by adding an inline fucntion where I just create a set from 1 to 31 and called that weekdate

In your case I guess you would need the expression =sum(sales)

Dan