Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Planning Data from Excel 2

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?

1 Solution

Accepted Solutions
Specialist II
Specialist II

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!

View solution in original post

5 Replies
Partner
Partner

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

Not applicable

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

In the cross table I have one field per month

Specialist II
Specialist II

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!

View solution in original post

Partner
Partner


Add a new line to script in calendar table.

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

Not applicable

Thanks - this works!