Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

callan_dooley
New Contributor

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

Re: Crosstable with two columns.

Try this

CrossTable (WeekNum, Figures, 2)

LOAD Year,

    KPI,

    WEEK01,

    WEEK02,

    WEEK03,

    WEEK04,

    WEEL05

FROM ...;

1 Reply

Re: Crosstable with two columns.

Try this

CrossTable (WeekNum, Figures, 2)

LOAD Year,

    KPI,

    WEEK01,

    WEEK02,

    WEEK03,

    WEEK04,

    WEEL05

FROM ...;

Community Browser