topic Displaying Max Month in QlikView

Displaying Max Month

raghavsurya — Tue, 21 Sep 2010 07:57:03 GMT

Hi All,

I have requirement to display the Sales comparison for the (Max month) and (Max Month -1). Since I can't calculate Max month if I use Jan, Feb etc) I have named them as 1,2,3 etc to calculate the data for Max month.

Also I have mapped the month and calendar month in the below order

Month Calendar.Month Sales

1 Jan 10,000

2 Feb 20,000

3 Mar 30,000

and so on........

Now I want to display the Calendar.Month value for the Max month value in the text box. For Example I have a guage chart wherein the values for (Max month) and (Max month-1) displayed. I also want to put text box next to the values to identify to which calenda.month it belongs to.

For example

text Box Guage chart values

Mar 30,000

Feb 20,000

Can anybody suggest how I can do this.

Thanks and Regards,

Raghav

Displaying Max Month

jonathandienst — Tue, 21 Sep 2010 08:52:55 GMT

If you create a "dual" field, then it will have both a text form and a numeric form. You could create a month dual like this:


MONTHS:
LOAD Dual(Name, Val) AS dlMonth;
LOAD * INLINE [
 Name, Val
 Jan, 1
 Feb, 2
 ..
 Dec, 12
];

When loading from your data source, you can now say myField AS dlMonth if myField contains a numeric from 1-12 or the month name as included in dlMonth.

dlMonth will display text in a text box and can be sorted numerically. You can also force the text representation with text(dlMonth) or force the numeric form with num(dlMonth) if you wish to override QV's choice of form.

Hope that helps

Jonathan

Displaying Max Month

raghavsurya — Wed, 22 Sep 2010 10:14:59 GMT

Hi Jonathan,

Thanks a lot. I shall implement this suggestion and get back to you.

Thanks and Regards,

Raghav

Displaying Max Month

raghavsurya — Thu, 23 Sep 2010 08:53:58 GMT

HI Jonathan,

I tried putting the logic suggested by you. But I am not able to get the desired result. I have attached the qvw file for your reference. Can you please help me out.

Thanks and Regards,

Raghav

Displaying Max Month

Thu, 23 Sep 2010 20:55:32 GMT

Hi Raghav

Hope this can solve the problem

Regards!

Displaying Max Month

raghavsurya — Fri, 24 Sep 2010 06:51:14 GMT

Hey..

Thanks a lot. This solved my requirement.

Regards,

Raghav