# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for
Did you mean:
Creator II

## convert if condition to set analysis

Hi All,

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]))

Creator II
Author

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]))

MVP

consider aggr one also? What does that mean?

Community Browser