Crosstable with two columns.

[Anonymous]

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)

Thank!

[sunny_talwar · Accepted solution]

Try this

CrossTable (WeekNum, Figures, 2)

LOAD Year,

    KPI,

    WEEK01,

    WEEK02,

    WEEK03,

    WEEK04,

    WEEL05

FROM ...;