Set a conditional per dimension without having dimension in the chart?

Fri, 01 Mar 2013 17:13:41 GMT

Hello,

I'm trying to perform an if/then statement against a list of dimension values and then get the total of those values. However, the tricky part is that I don't want all those dimension rows showing in the table... I'd like it to be a summary/totals table.

I have attached an example. You can see in the DETAILS table the calculation and totalling works fine becuase all the dimension values are in each row (dimension = ACCOUNT).

However when I try and SUMMARY table and try to display *just the total' of the rows of the DETAILS TABLE, it is not considering the per row/per dimension value calculation becuase that dimension is not included in the table.

So in the attached example I'm trying to get $38,500 to display in the SUMMARY table.

Any ideas?

Thanks.

Re: Set a conditional per dimension without having dimension in the chart?

CELAMBARASAN — Fri, 01 Mar 2013 17:24:56 GMT

Hi,

Use Aggr function based on the dimension you used in the detail chart for summary.

Check with this expression

Sum(Aggr(if (sum ({$< YEAR = {$(=max(YEAR))}>}[INVOICE])= 0,

sum ({$< YEAR = {$(=max(YEAR)-1)}>}[PAYMENT])), ACCOUNT))

Hope it helps

Celambarasan

topic Set a conditional per dimension without having dimension in the chart? in QlikView

Set a conditional per dimension without having dimension in the chart?

Re: Set a conditional per dimension without having dimension in the chart?