Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Crosstable with two columns.

Hello,

We have data like this, I was wondering how would be the best way to get this into Qlik.

I know i need to crosstable but i need 4 Filters.

I need

  • Year
  • KPI
  • WeekNum
  • Figures (This being the data)

Capture.PNG

Thank!

1 Solution

Accepted Solutions
sunny_talwar

Try this

CrossTable (WeekNum, Figures, 2)

LOAD Year,

    KPI,

    WEEK01,

    WEEK02,

    WEEK03,

    WEEK04,

    WEEL05

FROM ...;

View solution in original post

1 Reply
sunny_talwar

Try this

CrossTable (WeekNum, Figures, 2)

LOAD Year,

    KPI,

    WEEK01,

    WEEK02,

    WEEK03,

    WEEK04,

    WEEL05

FROM ...;