topic Re: Subaggregation in QlikView

Subaggregation

Wed, 13 Mar 2013 16:07:27 GMT

Hi all,

Is it posible to make subagregation for example in table box?

I will need to have subtotal from vertical fields,

For example

Gross Sales 1000

Quantity rebates -100

Net I Sales 900 As Subtotal from Gross Sales and Quantity rebates

Price Discount -200

Net Invoice 700 As Subtotal from Net I Sales and Price discount

Is it posible to do in some other object in QV?

Thanks

Re: Subaggregation

Gysbert_Wassenaar — Wed, 13 Mar 2013 17:05:20 GMT

Yes and no. Qlikview is not a spreadsheet program. Trying to use it as one will be painful. But of course it is possible if you're not afraid to get hurt. See here.

Re: Subaggregation

Fri, 15 Mar 2013 16:05:06 GMT

Gysbert,

Thank you very much, I think this will be very helpfull.

I will need time to digets all this :-)....

I have weekend for that.

Thank you very much again.

Greetings from Belgrade..

Re: Subaggregation

Wed, 20 Mar 2013 12:56:02 GMT

Gysbert,

I almost got it , but still have problem with blanks in P&L view, i only have it on the top of the P&L report.

It is strange because source table where the field 's' is stored have s an everything on right spot.

So I put number in Profit and loss template table and insert it in the report and hide, not so elegant solution but works.

Thank you very much again...