topic Re: Help with Aggregation within a set analyisis expression in QlikView

Help with Aggregation within a set analyisis expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi Guys,

Wondering if someone can help, im trying to aggregate this set analysis expression by service_id , ive tried a few things and im not having any luck. It doesn't seem to change the values has anyone had this sort of problem before ?

sum(aggr(sum({1<service_state = {'installed'}, m_ref=(P({1<portfolio_class = {'Managed Networks', 'Public Cloud Services', 'Managed Apps (on public cloud)', 'Hybrid & Private Cloud Services', 'Managed AWS/azure platforms', 'Managed apps on AWS/azure'}, service_state = {'installed'}>}))>}service_annualised_arv),service_id))

Thanks

Sarah

Re: Help with Aggregation within a set analyisis expression

sunny_talwar — Mon, 24 Oct 2016 15:10:01 GMT

May be add your set analysis to outer aggregation also

Sum({1<service_state = {'installed'}, m_ref=(P({1<portfolio_class = {'Managed Networks', 'Public Cloud Services', 'Managed Apps (on public cloud)', 'Hybrid & Private Cloud Services', 'Managed AWS/azure platforms', 'Managed apps on AWS/azure'}, service_state = {'installed'}>}))>}

Aggr(Sum({1<service_state = {'installed'}, m_ref=(P({1<portfolio_class = {'Managed Networks', 'Public Cloud Services', 'Managed Apps (on public cloud)', 'Hybrid & Private Cloud Services', 'Managed AWS/azure platforms', 'Managed apps on AWS/azure'}, service_state = {'installed'}>}))>} service_annualised_arv), service_id))

Re: Help with Aggregation within a set analyisis expression

vinieme12 — Mon, 24 Oct 2016 15:14:01 GMT

can you try

sum(TOTAL <service_id> aggr(sum({1<service_state = {'installed'}, m_ref=(P({1<portfolio_class = {'Managed Networks', 'Public Cloud Services', 'Managed Apps (on public cloud)', 'Hybrid & Private Cloud Services', 'Managed AWS/azure platforms', 'Managed apps on AWS/azure'}, service_state = {'installed'}>}))>}service_annualised_arv),service_id))