Quer on Quarters

Thu, 15 Oct 2009 13:15:59 GMT

Hi all,

I want to define quarters for the months.From fiscal Year Apr-Mar.Apr is Q1.If any one of you have idea

about this pleas share with me.

Note

I trield also using inline wizard

Quer on Quarters

Thu, 15 Oct 2009 14:10:24 GMT

Hi,

I don't understand waht exactly you want, but I've used the following solution:

Data_Table:
LOAD
"Date",
Year("Date") as Year,
Month("Date") as Month,
Value;
SQL SELECT
"Submit_Date",
"Value"
FROM "table1";

Quarters:
LOAD * INLINE [
Month, Desc, Order
1, Q1, 1
2, Q1, 1
3, Q1, 1
4, Q2, 2
5, Q2, 2
6, Q2, 2
7, Q3, 3
8, Q3, 3
9, Q3, 3
10, Q4, 4
11, Q4, 4
12, Q4, 4
];

I hope this help you.

Best regards.

topic Quer on Quarters in QlikView

Quer on Quarters

Quer on Quarters