Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

tmumaw
Valued Contributor

Months with No Date

Good morning everyone,

I have this table which has monthly buckets for debits, credits and year.  The different buckets represent the months. Something like this:

C01 C02  C03  C04  C05  C06  C07  C08  C09  C10  C11  C12   D01  D02  D03  D04  D05  D06  D07  D08  D09  D10  D11  D12  YEAR

My report need to be formatted something like this:

Jan        Credit     Debit   Bal

Feb.......

Mar.......

Etc......

How can I get each bucket to represent a month ?

Thanks

Tags (1)
6 Replies

Re: Months with No Date

May be this

Month(Date#(PurgeChar(FieldName, 'CD'), 'M')) as Month

tmumaw
Valued Contributor

Re: Months with No Date

Each one of those fields at the top are months

C01  jan

D01  jan

C02  Feb

D02  Feb

Re: Months with No Date

Yes, I get that.... and I am guessing your data looks like this

FieldName

C01

D01

C02

D02

C03

.

.

.

Right?

tmumaw
Valued Contributor

Re: Months with No Date

No.  My data looks like this.  One record contains all months.

C01 C02  C03  C04  C05  C06  C07  C08  C09  C10  C11  C12   D01  D02  D03  D04  D05  D06  D07  D08  D09  D10  D11  D12  YEAR

Re: Months with No Date

Then may be you need to use The Crosstable Load to transform your data so that C01 and D01 can be changed to Jan and so on....

Partner
Partner

Re: Months with No Date

date(date#(right(Fieldname,2),'MM')) as MonthStart

Monthname(date(date#(right(Fieldname,2),'MM'))) as Month-Year,

Month(date(date#(right(Fieldname,2),'MM'))) as Month