topic Re: Caption Movement in QlikView

Caption Movement

helen_pip — Fri, 14 Sep 2012 12:42:53 GMT

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
Total Time	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

Re: Caption Movement

Fri, 14 Sep 2012 13:11:50 GMT

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.

Re: Caption Movement

helen_pip — Fri, 14 Sep 2012 14:21:38 GMT

Thank you! Works a treat!