topic Re: Adding in column in pivot table in QlikView

Adding in column in pivot table

rcorcoran — Mon, 18 May 2015 11:00:48 GMT

I have a pivot chart attached and I want to add in a column before it with the headings in chart 2 on the attached any help would be appreciated.

thanks

Message was edited by: rhona CORCORAN Attachment now has image of the way I want the chart to look.

sunny_talwar — Mon, 18 May 2015 13:12:14 GMT

Not entirely sure what you are trying to do? Would you be able to re-explain your requirement?

Best,

Sunny

rcorcoran — Mon, 18 May 2015 13:22:36 GMT

Hi Sunindia

I have now attached a document with image of example of what I need

Thanks

sunny_talwar — Mon, 18 May 2015 13:31:01 GMT

Why don't you create a inline table in your script and use the two new fields instead of ValueList() function?

LOAD * Inline [

Column1, Column2

Home Care Packages, Test 1

Home Care Packages, Test 2

Home Help Hours, Test 3

Nursing Homes Support Scheme (NHSS), Test 4

Public Beds, Test 5

];

and then use Column1 and Column 2 as your dimension

HTH

Best,

Sunny

rcorcoran — Mon, 18 May 2015 13:35:12 GMT

I am not sure that will work because of the way I have to calculate the expressions??