Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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
Highlighted

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?