Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor

Working with changing raw data

Hi

I am looking for some guidance on how to work with some raw data I have.

I upload data via Excel, several column headers are titled e.g. 'Jan 2017', 'Feb 2017', 'Mar 2017' ... 'Dec 17' and so on for 12 months.  This file will be updated monthly and the raw data date columns is rolling which also mean the columns header names will change each month.  i.e. the next month 'Jan 17' data will not be there but 'Jan 18' will appear.

My problems with working with this is that I need to write some IF statements based on these columns.  How can I write my IF statements in my script if the header names will change each month?  Without having to change my formulas every month too

1 Solution

Accepted Solutions
Highlighted

Re: Working with changing raw data

I would suggest using a crosstable load to transpose your data or you can ignore the excel labels and use @1, @2, ....

The Crosstable Load

View solution in original post

2 Replies
Highlighted

Re: Working with changing raw data

I would suggest using a crosstable load to transpose your data or you can ignore the excel labels and use @1, @2, ....

The Crosstable Load

View solution in original post

Highlighted
Contributor

Re: Working with changing raw data

Thanks I went with the simple ignoring the excel label option