Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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