topic Re: convert if condition to set analysis in QlikView

convert if condition to set analysis

Anonymous — Wed, 08 Nov 2017 14:04:25 GMT

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

Re: convert if condition to set analysis

sunny_talwar — Wed, 08 Nov 2017 14:06:42 GMT

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

Re: convert if condition to set analysis

Anonymous — Wed, 08 Nov 2017 14:22:35 GMT

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

Re: convert if condition to set analysis

sunny_talwar — Wed, 08 Nov 2017 14:25:28 GMT

consider aggr one also? What does that mean?