topic Set expression in QlikView

Set expression

arusiva89 — Thu, 28 Oct 2021 12:45:26 GMT

I need to calculate the sum of Revenue which has Datatype in $ (Expected result is 140 for below table).Is that possible to get it through set expression

Region	Type	Measure
R1	Revenue	100
R1	DataType	$
R2	Revenue	30
R2	DataType	%
R3	Revenue	40
R3	DataType	$
R4	Revenue	10
R4	DataType	D

Re: Set expression

Lisa_P — Thu, 28 Oct 2021 23:39:07 GMT

You can load the data using a Generic load (put Generic before load statement) and you will get 2 tables in the data model.

This will allow you to calculate the Sum(Revenue) where DataType is $ using set analysis

Sum({<DataType={$}>}Revenue)

Re: Set expression

arusiva89 — Fri, 29 Oct 2021 02:28:50 GMT

Thanks for the explanation!