topic Re: Planning Data from Excel 2 in QlikView

Planning Data from Excel 2

Fri, 08 Nov 2013 11:00:12 GMT

I have made a planning table in excel and put this to QV:

CrossTable(Jan, Data)

LOAD F1,

Jan,

Feb,

Mar,

Apr,

May,

Jun

FROM

D:\Planning.xlsx

(ooxml, embedded labels, table is Sheet1);

Now I want to link this with a calendar function. So I want to see in March e.g. I have 100 active subscription plan was 120.

Calender is a key in the subscription data and in calendar data. How could I link it now with the cross table?

bruno_m_santos — Fri, 08 Nov 2013 11:06:05 GMT

Instead of put months "Jan, Feb, Mar, " I suggest to use the first day of month 01-01-2013, 01-02-2013.

You can link them directly.

Thanks

Bruno

Fri, 08 Nov 2013 11:11:37 GMT

This I have made - but my Calendar has only one field: #DATE

In the cross table I have one field per month

salto — Fri, 08 Nov 2013 11:15:55 GMT

Hi,

please find attached my approach.

I have created a calendar and linked the Month field in the Calendar to the Month field from the Excel table.

Hope this helps!

bruno_m_santos — Fri, 08 Nov 2013 11:17:22 GMT

Add a new line to script in calendar table.

Date(monthstart(#DATE), 'MMM-YYYY') AS MonthYear

Fri, 08 Nov 2013 12:16:19 GMT

Thanks - this works!