topic Re: Bottom-up calculation for group drill down in QlikView

Bottom-up calculation for group drill down

Mon, 07 Apr 2014 08:10:12 GMT

I have a dimensions group which consist of A,B and C as dimension. I am using this group for drill down.

Now at the lowest level i.e C, I want to have 3 calculated expressions exp1,exp2 and exp3 as (exp1-exp2)

Now at the B level I want sum of all exp3 at C level having +ve values

Similarly at the A level I want sum of all exp3 at C level having +ve values

Is it possible in qlikview and how to achieve this?

Note: I dont need exp1,exp2 and exp3 for other levels except C. Its just that I need sum of exp3 at all the levels.

MK_QSL — Mon, 07 Apr 2014 08:13:53 GMT

Can you share your sample file?

Mon, 07 Apr 2014 08:19:33 GMT

Hi Manish,

I dont have a sample file as of now. The QVW I am working on is huge and contains client related data. So it will be dificult to share here.

I hope you understood the question right.

Thanks for your prompt reply and if you can help more that will be great.

Meanwhile I will see if I can post qvw with masked data here.

Regards,

Durgesh