Layout Issue

[mhmmd_srf]

Hi All,

How to get below kind of layout in Qlikview. Pivot Table or Staright Table is not giving me this kind of look and Feel.

Please help.

Thanks,

Sarif

[kaushiknsolanki]

HI,

I dont think its possible, simply because Qlik is not Excel.

I would recommend that you look for Qlik NPrinting for such formatting.

Regards,

Kaushik Solanki

[sdmech81]

Use staright table..

But above lables month unit and month sales etc u can use tect objects to bring it to that view to some extent.

Sachin

[ramasaisaksoft]

it is possible with Pivot Table .

just create

item no,item name,field 1 (Month Units,Month sales,Year Units,Year Sales),Expressions  4 (Actual ,plan,variance,% tot pln)

now you can click on field 1 and drag that field as a row on top of the pivot table.

check once

Vertical calculation on a horizontal dimension in pivot table

else