Expression

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

Hi ,

How to write the expression for Inbound Units and Inbound Value.

As, in the script ,

load

'IO' as [Type Indicator],

[Trans Date],

product_key,

0 as division_key,

[ordered_quantity] as [Quantity],

[inbounds_value] as [Sales Value],

0 as [Cost of Sales]

FROM [..\00 QVD Source\InboundOrders.qvd](qvd)

where fiscal_year = 2016

and fiscal_period=10

and product_key=160

;

division_key is 0 .

How to write the set analyis ignoring the division_key as Inbound is not dependent on division_key.

Thus, the value is linked to NULL Main Division.

Sample attached.

Thanks,

Re: Expression

sunny_talwar — Wed, 11 May 2016 14:14:05 GMT

Try it with the TOTAL qualifier. Not sure which fields need to be used based on your actual data, but I guess you can play around with it. So far I have this for you

SUM({<[Type Indicator] = {'IO'} >} TOTAL [Sales Value])

topic Expression in QlikView

Expression

Re: Expression