topic Re: Set Analysis Inconsiderate part of the condition. in QlikView

Set Analysis Inconsiderate part of the condition.

yanivvl0 — Tue, 17 Jan 2017 08:27:57 GMT

hi to all ,

i have Expression with SetAnalysis :

sum ( {$<Is_Current={1} ,Current_ConstructionStage={"<42"} ,Current_ConstructionStage={">=7"} >} HousingUnits )

while compute - i see that the Current_ConstructionStage={"<42"} is Inconsiderate :

i expect to see 22 but it sum also the 52 HousingUnits ...

THANKS !!

Anonymous — Tue, 17 Jan 2017 08:32:42 GMT

Hi,

Try below query.

sum ( {$<Is_Current={1} ,Current_ConstructionStage={">=7<42"} >} HousingUnits )

yanivvl0 — Tue, 17 Jan 2017 11:21:46 GMT

Thank you Payal - GREAT HELP , didn't knew that QV can understand something like >=7<42 ...