topic Re: Switch Expression dimension in QlikView

Switch Expression dimension

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

Hi,

I have a question,

I have a bar chart like this:

Is it possible for me to switch the position between BRAND and MY EXPRESSION (DLV & REQ) ?

I also attach my data and sample file.

Really appreciate your help

thanks in advance.

MK_QSL — Mon, 21 Mar 2016 10:33:20 GMT

What is meant by

switch the position between BRAND and MY EXPRESSION (DLV & REQ) ?

Please elaborate !

sunny_talwar — Mon, 21 Mar 2016 10:34:26 GMT

This?

Script:

CrossTable (Name, Value, 2)

LOAD YEARMONTH,

BRAND,

REQ_QTY,

DLV_QTY

FROM

sample.xlsx

(ooxml, embedded labels, table is Sheet2);

Three Dimensions

YEARMONTH

Name

BRAND

Expression

Sum(Value)

ali_hijazi — Mon, 21 Mar 2016 10:35:39 GMT

possible if you have a record for Requested quantity and a record for Delivered quantity then next to each record you would put Flag as R or V

in this way you would use the Flag as a dimension

and you need to add the Brand as a dimension too

in your expression you would count the brands (how many times a brand was ordered or delivered)

is this what you aim for?

Anonymous — Mon, 21 Mar 2016 10:37:37 GMT

Yes that's my goal.

Thanks once again ! Really appreciate your help