topic Re: How to create a Calendar in the following type? in QlikView

How to create a Calendar in the following type?

Tue, 24 Jul 2012 09:07:31 GMT

Hi,

I need to create a calendar so that i can make an ad-hoc range selection when viewing the report.

the data i have is as follows:

Material Month Order#

M01 2012-01 540

M01 2012-02 560

M01 2012-03 640

M01 2012-04 580

M01 2012-05 510

M02 2012-01 340

M02 2012-02 360

M02 2012-03 140

M02 2012-04 580

M02 2012-05 810

and the I can imagine that the calendat i need for start month and endmonth should be like this:

2012

Jan Feb Mar Apr

May Jun Jul Aug

Sep Oct Nov Dec

Could you pls help?

Regards

Jerry

Re: How to create a Calendar in the following type?

jonathandienst — Tue, 24 Jul 2012 09:25:12 GMT

Jerry

The simplest way to this is to use two variables, say vMinDate and vMaxDate and allow the user to enter these via an input box or calendar. Then use these variables in your expressions. Lets assume you use calendar boxes for the time being (we can refine that later):

Lets assume when you loaded month it was loaded as a datefield:

LOAD...

Date(Date#(Month, 'YYYY-MM'), 'YYYY-MM') As Month

Something like:

Sum({<Month = {">=$(=Date('$vMinDate)', 'YYYY-MM')) <=$(=Date('$vMinDate)', 'YYYY-MM'))"} Amount)

(Check for closing brackets etc).

I think that's right. The date manipulation is because you are not using a standard date format. If you upload a sample of your model, I could test this in place and get it working for you.

Hope that helps

Jonathan

Re: How to create a Calendar in the following type?

Tue, 24 Jul 2012 09:38:35 GMT

Hi Jonathan,

So kind of you.

I have practiced an example and

I have tried the expression to display

Sum({<Month = {">=$(=Date('$vMinDate)', 'YYYY-MM')) <=$(=Date('$vMinDate)', 'YYYY-MM'))"} Amount)

however, i failed.

could you pls help?

Regard

Jerry

Re: How to create a Calendar in the following type?

jonathandienst — Wed, 25 Jul 2012 16:06:07 GMT

Jerry

Not sure where you tried the expression, but as this model bears little in common with your original post, its not surprising that it does not work.

There were also some syntax errors in my post , my bad!

Here's the solution.

Regards

Jonathan

Re: How to create a Calendar in the following type?

Mon, 30 Jul 2012 07:14:20 GMT

Hi Jonathan,

can't run it, still trying to find the solution.

anyway, thanks for your kindly help