topic Two Calender wise analysis in one Report in QlikView

Two Calender wise analysis in one Report

Thu, 24 Feb 2011 10:08:32 GMT

Hello,

I want two calender (Financial Calender as well as Normal Calender ) wise analysis in one report :

Expression :sum(sales) Dimension: MonthYear

i.e When I am selecting calender month or year then I want sales according to Calender MonthYear

and when I am selecting financial month or year then I want sales according to Financial Month Year.

Kindly Help me,

Thanks in advance.

maneshkhottcpl — Thu, 24 Feb 2011 10:19:19 GMT

Hi Yogesh,

Please share ur sample application with requirment.

Thu, 24 Feb 2011 10:31:52 GMT

Hi Yogesh,

please see the attached example for help (Script part).

Good luck!

Rainer

Thu, 24 Feb 2011 14:08:02 GMT

Hi Rainer,

Thank u for quick reply.

But My requirement is :

There is one indication or List Box having Normal Calender (Jan to Dec ) and Financial Calender (Apr to Mar)

When I am Selecting Normal Calender, Chart will show Sales according to Month (Sorting Jan to Dec)

When I am Selecting Financial Calender, Chart will show Sales according to Month (Sorting Apr to March)

If any doubt, Please reply.

Anonymous — Thu, 24 Feb 2011 14:54:08 GMT

Hi Yogesh,

I solved this by using 2 seperat calanders, one connected to one date-field the other to an other.
Is this what you are looking for?