Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

yanivvl0
Contributor III

Set Analysis Inconsiderate part of the condition.

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 :

seta_sumrange.PNG

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

THANKS !!

1 Solution

Accepted Solutions
Highlighted
payalgosar
Contributor II

Re: Set Analysis Inconsiderate part of the condition.

Hi,

Try below query.

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

View solution in original post

2 Replies
Highlighted
payalgosar
Contributor II

Re: Set Analysis Inconsiderate part of the condition.

Hi,

Try below query.

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

View solution in original post

yanivvl0
Contributor III

Re: Set Analysis Inconsiderate part of the condition.

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