Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Putting 2 or more dimensions below each other in a straight table

Hi

I am needing to put more than one dimension in a table so that they are below each other instead of next to each other like it normally does so it would look something like this:

DimensionsData
Store 1100 000
Store 2150 000
Store 375 000
Store 450 000
375 000
Product 125 000
Product 2125 000
Product 3150 000
Product 475 000
375 000
Region 1225 000
Region 2150 000
375 000

Does anyone have any suggestions of how to achieve this? Using cyclical dimensions and things like that are not going to work as they need the report in this format for a specific reason.

Thanks

Colleen

2 Replies

Re: Putting 2 or more dimensions below each other in a straight table

use same field name for this in your script load.

Re: Putting 2 or more dimensions below each other in a straight table

You have to load a table like this

Store:

LOAD * INLINE [

    Store, StoreAmt

    Store 1, 100 000

    Store 2, 150 000

    Store 3, 75 000

    Store 4, 50 000

];

Product:

load * Inline

[

  Product , ProdAmt

    Product 1, 25 000

    Product 2, 125 000

    Product 3, 150 000

    Product 4, 75 000

];

Region:

LOAD * Inline

[

  Region,RegionAmt

    Region 1, 225 000

    Region 2, 150 000

];

Final:

LOAD

    Store as Dimensions,

    StoreAmt as Data

Resident Store;

Concatenate

LOAD

  Product as Dimensions,

  ProdAmt as Data

Resident Product;

Concatenate

LOAD

Region as Dimensions,

RegionAmt as Data

Resident Region;

Community Browser