Select only 1 Value

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I'd like to select only one value from a field.

My Field will be Region=North America and measure will be sum(value1)+sum(value2)+sum(value3)

So the end result I need is sum(value1)+sum(value2)+sum(value3) for only North America

I've tried set analysis function, sum(aggr function as well but could not make it work.

Dimension = Region

Values in Region are North America, Europe, Asia, Oceanic, Africa

Measure= sum(value1)+sum(value2)+sum(value3)

End result= value for only North America region.

I need end result for region wise

Thanks.

topic Select only 1 Value in QlikView