Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Joining Cross Table with data and calendar

I have a cross table of data like below:

CrossTable(FiscalMonth, Data, 3)

LOAD Key,

     Category,

     Year,

     Jan,

     Feb,

     Mar,

     Apr,

     May,

     Jun,

     Jul,

     Aug,

     Sep,

     Oct,

     Nov,

     Dec

That I need to link to both the data (Category AS AEA_EUROPE) and also need to link the month and year to the calendar (either FiscalMonth and FiscalYear or FiscalMonthYear) but when I connect the both, I get loops. What is the best way to get them all linked without getting these loops?

Thanks

11 Replies
Highlighted
Creator
Creator

Yey that worked! Thank you

Highlighted
Creator
Creator

Actually Jerry,

Instead of using:

AEA_DATA:

FiscalMonthYear as AEA_FiscalMonthYear,

Key,

Category as AEA_EUROPE,

AEAData

I used this:

AEA_DATA:

Load

Key,

Category AS AEA_EUROPE,

Month&'-'&Year AS AEA_FiscalMonthYear,

AEAData

Because of my Month and Year fields...

And it worked initially when only a specific month was selected. But when I want to view all of the months together as a years view, the data returns the same amount of each month, rather than calculating different amount like its meant to.

Here is the results I am getting for the year view of Jan and Feb:

jan and feb.PNG

When actually it should be showing these results:

jan.PNGfeb.PNG

I think its a subtotal of the whole year but displaying it on every month? Not sure why some have 0 though. Any ideas?