Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to pivot the data of rows into columns

Hi All,

I have a table where data will be like

2014-06-16_1337.png

But i want my data to be like

Location Num      Week       Sales

3013                  week1         2448

3013                  week2         2513

3020                  week1         3957

3020                  week2          3673         

And so, on .I have attached my QVW. Can someone help me with any suggestions ?

Thanks         

12 Replies
Partner
Partner

Please see attached file

View solution in original post

Partner
Partner

You deleted the 'key' field on the calendar table

calkey.JPG.jpg

Partner
Partner

Store the calendar table in a qvd:

store Calendar into Calendar.qvd;

DROP Table Calendar;

Calendar:

LOAD *,

  num(FiscalYearId & num(FiscalMonthOfYearId,'00') & num(FiscalWeekOfMonthId,'00')) as key

FROM

Calendar.qvd

(qvd);

qvd.JPG.jpg

View solution in original post