Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

helen_pip
Contributor II

Caption Movement

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 TimeApr-12May-12Jun-12
Median235
Maximum91011

TO:

Apr-12May-12Jun-12
Total TimeMedian235
Maximum91011

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

1 Solution

Accepted Solutions
Not applicable

Re: Caption Movement

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.

2 Replies
Not applicable

Re: Caption Movement

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
Contributor II

Re: Caption Movement

Thank you!  Works a treat!

Community Browser