topic Re: if(aggr(sum(... in QlikView

if(aggr(sum(...

carolin01 — Thu, 09 Jul 2015 09:37:25 GMT

Hi,

can anybody help me witht he correct variable syntax in this aggr-statement:

=if(aggr(Sum($(=vRevenueTotalMax)'$(vLagerSmaler)'&'$(vTopCustomer)',SoldToBusinessPartner)))

The Variable vLagerSmaler should give the user the option to choose > or <, the vTopCustomer should give the possibility to enter a value. This is used as calculated dimension to enable the user to filter the list of customers.

Best regards

Carolin

Re: if(aggr(sum(...

MK_QSL — Thu, 09 Jul 2015 09:40:18 GMT

What is your expression after replacing the Variables?

Re: if(aggr(sum(...

carolin01 — Thu, 09 Jul 2015 09:47:49 GMT

Hi,

the Statement without variables would be e.g.:

=if(aggr(Sum($(=vRevenueTotalMax)),SoldToBusinessPartner)>5000,SoldToBusinessPartner)

But also this doesn´t give me the result that I want...

Carolin

Re: if(aggr(sum(...

MK_QSL — Thu, 09 Jul 2015 09:52:33 GMT

May Be

SUM(Aggr(IF(SUM($(=vRevenueTotalMax))>5000, SoldToBusinessPartner),SoldToBusinessPartner)

Re: if(aggr(sum(...

carolin01 — Thu, 09 Jul 2015 09:55:46 GMT

Unfortunately no. The dimension then indcates "// Error in calculation"

Re: if(aggr(sum(...

jagan — Thu, 09 Jul 2015 09:59:01 GMT

Hi,

Can you attach sample file and your expected output?

Regards,

Jagan.