Caption Movement

[helen_pip]

Hello,

I am very new to Qlikview and am looking for advice

I need to put the caption to the left of a table as a merged cell

I.e. FROM:

Total Time	Apr-12	May-12	Jun-12
Median	2	3	5
Maximum	9	10	11

TO:

		Apr-12	May-12	Jun-12
Total Time	Median	2	3	5
	Maximum	9	10	11

Is there anyway the caption can be moved?

If not I am happy to make a dummy field in my LOAD statement, which will hold not data but would still require assistance in order to get the desired results

Thanks

Helen

[#2 · Accepted solution]

One way is to create a dummy field using the script:

'Total Time' as TotalTime

Then you can use a pivot table with the dimensions Total Time and your field for Median and Maximum. Under Chart Properties> Deselect 'Allow Pivoting' and select 'Always Fully Expanded' to make it look more like a straight table. Here is an example.

[helen_pip]

Thank you!  Works a treat!