# QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Creator II

## convert if condition to set analysis

Hi All,

can you please help me to convert this into set analysis

actual one

=SUM(AGGR(IF([Gate DRD]=1

AND  [Gate Status]='Open' AND NOT(ISNULL([PLM Project ID]))

AND [Gate Actual Start Date]<>'-'

AND [Gate Actual End Date]<>'-'

, Networkdays([PLM Project Actual Start Date],[Gate Actual End Date])),[Gate DRD],[Gate Status],[Gate Actual Start Date],[Gate Actual End Date],[PLM Project ID]))

i have converted  like below but not working because of network days

=Aggr(Sum({<[Gate DRD]={1}

,  [Gate Status]={'Open'},PLM_NullFlag={1}

, [Gate Actual Start Date]-={'-'}

,[Gate Actual End Date]-={'-'}

,Network_PLM_GATE>}[PLM Project ID]),[Gate DRD],[Gate Status],[Gate Actual Start Date],[Gate Actual End Date])

3 Replies
MVP

May be this

Sum({<[Gate DRD] = {1}, [Gate Status] = {'Open'}, PLM_NullFlag = {1}, [Gate Actual Start Date] -= {'-'}, [Gate Actual End Date] -= {'-'}, Network_PLM_GATE>} Networkdays([PLM Project Actual Start Date],[Gate Actual End Date]))

Highlighted
Creator II

Not working above one

can you convert this, consider aggr one as well

SUM(AGGR(IF([Gate DRD]=1

AND  [Gate Status]='Open' AND NOT(ISNULL([PLM Project ID]))

AND [Gate Actual Start Date]<>'-'

AND [Gate Actual End Date]<>'-'

, Networkdays([PLM Project Actual Start Date],[Gate Actual End Date])),[Gate DRD],[Gate Status],[Gate Actual Start Date],[Gate Actual End Date],[PLM Project ID]))

Highlighted
MVP

consider aggr one also? What does that mean?