topic Re: how to group months in the same field? in QlikView

how to group months in the same field?

Tue, 04 Sep 2012 14:38:00 GMT

Hi All,

I have a field with name as "Month".It contains the data of "Jan,Feb,.......,Dec"

Month:

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

If my table structure is like this.

Tab:

Prod,

Month

How can i made upto lastmonth(i.e,Jan to Aug) as one group and remaining months like(i.e,Sep to Dec) as one group in the same filed "Month"

and my end result is, i need to plot the count of "Prod" based on the month groups in a bar chart.

Thanks for any response

Regards

Kumar

Re: how to group months in the same field?

whiteline — Tue, 04 Sep 2012 15:48:25 GMT

As there are only 12 months (and it is not a subject to change) I think you can just Create Inline statement to connect your Month fields with MonthGroup field.

Re: how to group months in the same field?

Tue, 04 Sep 2012 16:18:15 GMT

Hi,

Some how i am achieving it like this

if(Month(DateField)*1<=9,'UptolastMonth','remainingMonths') as Group,

But i am troubling to show total months as another value in that group.

Regards

Kumar

Re: how to group months in the same field?

whiteline — Tue, 04 Sep 2012 16:23:15 GMT

LOAD * INLINE [

Month, ChartDimension

Jan, UptolastMonth

Feb, UptolastMonth

Mar, UptolastMonth

Apr, UptolastMonth

May, UptolastMonth

Jun, UptolastMonth

Jul, UptolastMonth

Aug, UptolastMonth

Sep, remainingMonths

Oct, remainingMonths

Nov, remainingMonths

Dec, remainingMonths

Jan, TotalMonth

Feb, TotalMonth

Mar, TotalMonth

Apr, TotalMonth

May, TotalMonth

Jun, TotalMonth

Jul, TotalMonth

Aug, TotalMonth

Sep, TotalMonth

Oct, TotalMonth

Nov, TotalMonth

Dec, TotalMonth

];