topic Re: Formulas on calculated fields in QlikView

Formulas on calculated fields

Fri, 06 Dec 2013 12:46:35 GMT

I have the following expression

Days OoS = count(if([Date Decarded]>0 AND [Resulting Stock]=0 and Branch='2002',([Product Code])))

I now need to take the result and multiply with retail price

I tried "sum( [Days OoS] * [Retail Price])" and "sum( count(if([Date Decarded]>0 AND [Resulting Stock]=0 and Branch='2002',([Product Code]))) * [Retail Price])"

Does not work.

Any ideas?

Regards

Fanie

Re: Formulas on calculated fields

MK_QSL — Fri, 06 Dec 2013 13:10:28 GMT

please upload your sample file.

Re: Formulas on calculated fields

Anonymous — Fri, 06 Dec 2013 15:05:05 GMT

Fanie,

The problem here is that you're trying to use one aggregation function (count) within another(sum):
sum(count(...))
It is not logical, hence not working. To make it work, you have to aggregate the internal aggregation function by some dimensions:
sum(aggr(count(...),<Dim1, Dim2, ...>))

I can't tell you what fields you have to aggregate by. Try to figure it out. Or, upload sample file, as Manish says.

Regards,
Michael

Re: Formulas on calculated fields

Fri, 06 Dec 2013 15:08:41 GMT

Hi Fanie

Without seeing the file its difficult to grasp this issue. Can you share the qvw please?

Steve