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
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.
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.
