topic Issue with formatting pivot table in mentioned format in QlikView

Issue with formatting pivot table in mentioned format

Thu, 23 Jan 2014 05:14:04 GMT

Hi all,

i am new in qlikview hence require a help in formatting issue

We have a simple table like

Fig 1:

Required output should be:

Fig 2:

Is there any way to present class in such format..if i tried to group class it displays group wise data in first column like

Fig 3:

Fig 2 is the requirement.. Can you guys help me on this..

Thanks in advance !

Sid

Anonymous — Thu, 23 Jan 2014 05:32:00 GMT

Without editing the script, this is the best I could do.

Gysbert_Wassenaar — Thu, 23 Jan 2014 09:21:39 GMT

Try changing the Indent setting on the Style tab of the properties window

Thu, 23 Jan 2014 12:57:47 GMT

Hi Gysbert,

I tried by indent setting it works buthas little issue,

Class column appear at the bottom (which i highlighted in Fig 1) above which there are standards and then first name,last name etc

We need other way round ,can we sort it like class comes first then standard down the line,then FN,LN etc

Fig 1 : with indent setting

Thu, 23 Jan 2014 13:12:09 GMT

Hi,

Got that.. Change Subtotals on top in presentation tab.

Thanks Guys for your help!!