topic Re: distribute calculated expression value to cyclic group qlikview in QlikView

distribute calculated expression value to cyclic group qlikview

agni_gold — Sat, 22 Aug 2015 18:46:50 GMT

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

Re: distribute calculated expression value to cyclic group qlikview

petter — Sat, 22 Aug 2015 19:21:49 GMT

Is this want you want to get:

Re: distribute calculated expression value to cyclic group qlikview

agni_gold — Sun, 23 Aug 2015 07:50:04 GMT

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 .

Re: distribute calculated expression value to cyclic group qlikview

Kushal_Chawda — Sun, 23 Aug 2015 09:55:43 GMT

Try to do it in Back end

See the attached

Re: distribute calculated expression value to cyclic group qlikview

petter — Sun, 23 Aug 2015 10:33:02 GMT

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.

Re: distribute calculated expression value to cyclic group qlikview

agni_gold — Sun, 23 Aug 2015 12:27:13 GMT

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 )

Re: distribute calculated expression value to cyclic group qlikview

agni_gold — Sun, 23 Aug 2015 12:27:25 GMT

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 )

Re: distribute calculated expression value to cyclic group qlikview

petter — Sun, 23 Aug 2015 13:37:41 GMT

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