topic Re: Pivot chart visualization in QlikView

Pivot chart visualization

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Pivot chart visualization

Frank_Hartmann — Wed, 23 Nov 2016 12:53:56 GMT

have a look at the attached sample.

hope this helps

Re: Pivot chart visualization

nareshthavidishetty — Wed, 23 Nov 2016 19:55:36 GMT

Hi,

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

Thanks..

Re: Pivot chart visualization

nareshthavidishetty — Thu, 24 Nov 2016 03:24:48 GMT

Hi,

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

Thanks..

Re: Pivot chart visualization

Anonymous — Thu, 24 Nov 2016 04:12:02 GMT

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,

Re: Pivot chart visualization

Thu, 24 Nov 2016 04:54:07 GMT

hi naresh,

i think it is not possible in qlikview

why because you have diff headings and diff sub headings

Re: Pivot chart visualization

nareshthavidishetty — Thu, 24 Nov 2016 05:12:01 GMT

Hi,

Attached is the sample app.Please check once.

Thanks..

Re: Pivot chart visualization

Anonymous — Thu, 24 Nov 2016 05:17:16 GMT

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,

Re: Pivot chart visualization

sushil353 — Thu, 24 Nov 2016 05:21:23 GMT

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

];

Re: Pivot chart visualization

Thu, 24 Nov 2016 05:54:43 GMT

CHECK THIS LINKS

Chart table Column sub headers

Create table in QV with multiple header rows

Re: Pivot chart visualization

Thu, 24 Nov 2016 05:57:18 GMT

LIKE THIS ONLY POSSIBLE

Re: Pivot chart visualization

sushil353 — Thu, 24 Nov 2016 06:54:31 GMT

Please find attached..

see if this helps you..