topic Re: problem in dimension calculation in QlikView

problem in dimension calculation

Wed, 09 Oct 2013 07:10:28 GMT

Hii All,

I am using Add calculated dimension and providing expression as =sum({<str_coa_description={'Total Revenue','Revenue from operations','EBITDA','EBITDA Margin','PBT(before Exceptional & Extraordinary items)'}>}str_coa_description) which is giving me error in calculating dimensions.....my task is to add only these column values in dimension of straight table where str_coa_description is one of my field.

please help.

Re: problem in dimension calculation

Gysbert_Wassenaar — Wed, 09 Oct 2013 07:15:09 GMT

You need to put an aggr around your expression: aggr( ...yourexpression..., Dim1, Dim2, ...etc). Replace Dim1, Dim2, ...etc with the other regular dimensions of your straight table.

BTW str_coa_description sounds like it's a description, not a number. Trying to sum a text field won't work.

Re: problem in dimension calculation

CELAMBARASAN — Wed, 09 Oct 2013 07:18:08 GMT

Hi,

In dimension Direct Sum, Count functions are not allowed it should be used with the help of Aggr. Also you trying to Sum the string field(Text). Sum can be used for Numeric field

I Hope you need something like this

=Aggr(If(Match(str_coa_description, 'Total Revenue','Revenue from operations','EBITDA','EBITDA Margin','PBT(before Exceptional & Extraordinary items)'), str_coa_description), str_coa_description)

Or simply

If(Match(str_coa_description, 'Total Revenue','Revenue from operations','EBITDA','EBITDA Margin','PBT(before Exceptional & Extraordinary items)'), str_coa_description)

Hope it helps

Re: problem in dimension calculation

Wed, 09 Oct 2013 07:30:07 GMT

it is again giving me same problem by using aggr(), and the second method you sent giving me no value...any other way to handle it?

Re: problem in dimension calculation

CELAMBARASAN — Wed, 09 Oct 2013 07:51:00 GMT

Could you please attach sample file.

Also could you tell me what expression you are using?