topic Re: regarding straight table in QlikView

regarding straight table

Tue, 04 Mar 2014 04:17:59 GMT

HI all

i have few questions recording straight table and i have attached an sample pic and i have to do like that can any one help me in solving in this solution

1. i want a separator for each product as shown in the fig A. in first chart

2. i want to merge multiple rows into single rows of measures as shown in FIG B AS IN Second chart

Re: regarding straight table

MK_QSL — Tue, 04 Mar 2014 07:13:03 GMT

You need to manually add a line as per your requirement but this is not a practical solution.

Re: regarding straight table

Peter_Cammaert — Tue, 04 Mar 2014 07:30:07 GMT

If your layout is fixed, assemble a seemingly single straight table by glueing multiple straight tables together. Omit the header in the bottom ones.

I should warn you: QlikView is not Excel...

Peter

Re: regarding straight table

ashwanin — Tue, 04 Mar 2014 07:31:15 GMT

I don't think that its possible to merge and reflect different data in same field.

Re: regarding straight table

Tue, 04 Mar 2014 07:43:57 GMT

hi manish i have added manually a line but this is not proper solution

Re: regarding straight table

Tue, 04 Mar 2014 07:44:40 GMT

is is possible in qlikview pivot table

Re: regarding straight table

MK_QSL — Tue, 04 Mar 2014 07:45:13 GMT

This is the only possible solution as far as I know.

It depends on you if you want others to answer or please close the thread by selecting appropriate answer

Re: regarding straight table

Tue, 04 Mar 2014 07:47:18 GMT

ok what about the merging of multiple rows in to single row as in second pic

Re: regarding straight table

Anonymous — Thu, 06 Mar 2014 22:29:42 GMT

you may be able to achieve that by turning on design grid and right clicking on the table cell, selecting custom format cells and removing borders in the window that opens up.

Re: regarding straight table

MK_QSL — Fri, 07 Mar 2014 07:13:28 GMT

use pivot table but that is also having limited advantage.