Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Creator II
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

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

consider aggr one also? What does that mean?