topic Set analysis help in QlikView

Set analysis help

Wed, 25 Nov 2020 16:16:04 GMT

I want a chart to display the measures of one "Region" only,

So I modified sum(ApprovedDemand)

sum({<Region='Region 1'>}ApprovedDemand)

but the chart says no Data to display.

What is wrong?

Anil_Babu_Samineni — Thu, 01 Jun 2017 09:39:32 GMT

Make sure whether "Region 1" is the correct value or not. And syntax should be like below

sum({<Region= {'Region 1'} >}ApprovedDemand)

shuck1985 — Thu, 01 Jun 2017 09:40:48 GMT

you are missing brackets.

sum({<Region={'Region 1'}>}ApprovedDemand)

should work like that

Thu, 01 Jun 2017 09:44:47 GMT

Thank You,

It worked.

Thu, 01 Jun 2017 09:45:54 GMT

Thanks,

Qlikview syntax check said expression ok for the wrong expression.