topic Re: Break lines in (Pivot) Table.. How? in QlikView

Break lines in (Pivot) Table.. How?

hansdevr — Thu, 18 Feb 2016 08:22:34 GMT

Hi Everyone,

I need some help with presentation of data from two tables, Dossiers and Claims. A Dossier can hold a number of claims and I want to totalize damages per dossier. The field Recourse is only available at Dossier level. To clear this up, here's a diagram of my tables:

I want to make a list on the screen (which can be exported to Excel) which would look like this:

As you can see, each group of claims is preceded by a single line showing totals for those claims.

What's the best way of achieving this?

Any help would be very welcome!

Re: Break lines in (Pivot) Table.. How?

Gysbert_Wassenaar — Thu, 18 Feb 2016 17:16:30 GMT

Export the basic data to Excel and do the rest in Excel. Qlikview is not a spreadsheet application. Trying to use Qlikview like a spreadsheet is going to be extremely cumbersome.

Re: Break lines in (Pivot) Table.. How?

hansdevr — Fri, 19 Feb 2016 06:44:24 GMT

Yes, you're right of course, but there are so many tricks in QV I haven't as yet discovered, that I thought it was worth the while to ask...

Bedankt, Gijsbert!