Solved: Re: Set analysis help - Qlik Community

Report Inappropriate Content · ‎2017-06-01

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

So I modified sum(ApprovedDemand)

as

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

but the chart says no Data to display.

What is wrong?

Anil_Babu_Samineni · ‎2017-06-01

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2017-06-01

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

shuck1985 · ‎2017-06-01

you are missing brackets.

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

should work like that

Report Inappropriate Content · ‎2017-06-01

Thank You,

It worked.

Report Inappropriate Content · ‎2017-06-01

Thanks,

Qlikview syntax check said expression ok for the wrong expression.