Pivot chart visualization

[nareshthavidishetty]

Hi,

We are having an requirement to get the below design in qlikview.

Is it possible in qlikview and let me know how to get.

Thanks

[Frank_Hartmann]

have a look at the attached sample.

hope this helps

[nareshthavidishetty]

Hi,

Attached is the sample data.Please check once and let me know if there is an possibility.

Thanks..

[nareshthavidishetty]

Hi,

Let me know if the posted design is possible by using the attached sample data.

Thanks..

[Anonymous]

Hi Naresh,

Your sample data is different from your given data as result.

Will be great if u can share a sample of your actual data.

Thanks,

[#6]

hi naresh,

i think it is not possible in qlikview

why because you have diff headings and diff sub headings

[nareshthavidishetty]

Hi,

Attached is the sample app.Please check once.

Thanks..

[Anonymous]

In other way you can do this by applying mapping in script itself by creating one more column which should have values like Sign,Wet Sign..

Thanks,

[sushil353]

hi Naresh,

if you can make or transform data in the way given below then it is possible to replicate that you need..

Load * inline

[

location,Dim1,Category,Orders

17,Sign,Complete,13

17,Sign,Not Complete,2

17,WetSign,Contract(IL),

17,WetSign,HL,2

17,WetSign,GE,1

];

[#10]

CHECK THIS LINKS

Chart table Column sub headers

Create table in QV with multiple header rows