distribute calculated expression value to cyclic group qlikview

[agni_gold]

In attached excel , i have data ,

and attached qvw has my situation ,

Calculated account C , is not distributing as per my cyclic group.

please help

[petter]

Is this want you want to get:

[agni_gold]

Hi Peter ,

Thanks for your great help ,

but it is not generic , actually in case D account came in picture and if it is B-C, then this will fail .

Is there any other way to do this as i was written in my application .

[Kushal_Chawda]

Try to do it in Back end

See the attached

[petter]

Well I think it is generic - especially if you change the number 3 on line 6 into NoOfRows(). Then it will allow for any number of rows being generated by the dimension.

Yes it is multiple other ways of doing it. It is also possible to do it in your load script. But doing pre-aggregations in your data model with QlikView is seldom considered best practice - especially when the aggregations are simplistic as is the case here.

[agni_gold]

Yes , it will be generic , but the thing is if we have new account D which is the C-B then there will be problem .

Basicaly i have 9 accounts  , for 4 accounts i have values from database , but rest 5 are calculated from others (either substraction , sum , division )

[agni_gold]

Yes , it will be generic , but the thing is if we have new account D which is the C-B then there will be problem .

Basicaly i have 9 accounts  , for 4 accounts i have values from database , but rest 5 are calculated from others (either substraction , sum , division )

[petter]

Then you just have to adjust the expression accordingly.That is only natural and shouldnt pose a problem.