topic Re: Expressions as Dimensions? in QlikView

Expressions as Dimensions?

semgem12 — Wed, 25 Nov 2020 16:16:04 GMT

Hello

I hope someone can help, I have searched the community but not really sure what to search on.

I have data in this format

and I would like to produce a Qlikview (v12.02) table that looks like this

It seems like I need a pivot table where the initial dimension is Brand but then Qty and Weight need to be dimensions too.

Is this possible? Thanks for any help.

vinieme12 — Thu, 23 Mar 2017 11:06:08 GMT

As below

temp1:

CrossTable(Type,ActualValue,1)

LOAD Brand,

[Actual Qty] as QTY,

[Actual Weight] as WEIGHT

// [Budget Qty],

// [Budget Weight]

FROM

(html, codepage is 1252, embedded labels, table is @1);

FACT:

CrossTable(Type,BudgetValue,1)

LOAD Brand,

// [Actual Qty],

// [Actual Weight],

[Budget Qty]as QTY,

[Budget Weight] as WEIGHT

FROM

(html, codepage is 1252, embedded labels, table is @1);

Concatenate

Load * Resident temp1;

drop table temp1;

semgem12 — Thu, 23 Mar 2017 15:44:21 GMT

Thank you for replying so quickly. This is just what I wanted.