Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

doubt on Quater

In my pivot table i should show the months from Jan to Dec and also Quater's Q1, Q2, Q3, Q4

but when I select Janaury month the data in the Q1 is only showing Jan data but I should see all the three months data

and also for the the other Q2,Q3,Q4 for this one how should we write the Expression

1 Reply
Employee
Employee

Re: doubt on Quater

Not sure what you have in your script, but something like this can help.

Quarters:

LOAD * INLINE [

Month, Quarter

1,Q1

2,Q1

3,Q1

4,Q2

5,Q2

6,Q2

7,Q3

8,Q3

9,Q3

10,Q4

11,Q4

12,Q4

];

Bill

Community Browser