Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Re: Joining Cross Table with data and calendar

Yey that worked! Thank you

Highlighted
Creator
Creator

Re: Joining Cross Table with data and calendar

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?