topic sum(if(Aggr(sum( not allowed in QlikView

sum(if(Aggr(sum( not allowed

Thu, 16 Jun 2011 23:38:19 GMT

Hi,

does anyone understand why qlikview does not accept an if statement around the following?

sum(if(Aggr(
sum({< eng_costcenter_key = {$(vCostCenter)},hours_month = {'$(=date($(vReportingDate)))'}, Z_directe_code_flag = {1},statusCode={'OPN'}>} timeAmount),
engagementId) = 0, 1))

example:

if(

sum(if(Aggr(
sum({< eng_costcenter_key = {$(vCostCenter)},hours_month = {'$(=date($(vReportingDate)))'}, Z_directe_code_flag = {1},statusCode={'OPN'}>} timeAmount),
engagementId) = 0, 1))

>1, do something) is not allowed.

thank you

sum(if(Aggr(sum( not allowed

gussfish — Fri, 17 Jun 2011 00:31:03 GMT

In what context are you using this statement? e.g. is it for the color of a calculated dimension of a bar chart, or the value of a variable that's used in an expression in a ...

And in what sense does QlikView not accept the statement? If it's merely that the expression editor is putting red squiggly lines under it, but it otherwise is producing correct results, that's not really an issue. So what is the precise symptom?

sum(if(Aggr(sum( not allowed

Fri, 17 Jun 2011 08:24:48 GMT

Hi, thanks.

Well it does not return any values. (only -), if I remove the outer if, it works fine.

for your information. I am creating a kpi dashboard. So in one table, i put: if kpi is 11 then..... (the aggr function)

if 12, then some other...

Re: sum(if(Aggr(sum( not allowed

jonathandienst — Fri, 17 Jun 2011 10:18:14 GMT

Can you run the first example in a tex box, or is it only useful as a chart expression? Better still, I suggest that you post your model, or a sample, to help disagnose the problem.

Regards

Jonathan