Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
vishnus85
Partner - Creator
Partner - Creator

Two dimensional table in qlikview ?

Hi All,

I have a requirement here for which i need your guidance.

I have procedure dates as one dimension, and surgeon names as a different dimension.

The TurnAroundTime for each case is available.

Customer wants this data to be shown in the below format.

Its like a two dimensional table.

TOTChartModel.JPG.jpg

If I create a stright table with procedure date as dimension, and give turnover time for each surgeon as each seperate expression I can achieve this. But I have so many surgeon names and I cannot add as many expressions as the number of surgeons.

Kindly help.

Thanks in advance.

Vishnu

1 Solution

Accepted Solutions
Not applicable

Hi,

Please use Pivot Table and add both procedure date and surgeon name as dimensions. You can then drag surgeon name onto the top.

View solution in original post

2 Replies
Not applicable

Hi,

Please use Pivot Table and add both procedure date and surgeon name as dimensions. You can then drag surgeon name onto the top.

vishnus85
Partner - Creator
Partner - Creator
Author

Wow,

This was quick !!

I had created a pivot table but I never knew a dimension could be dragged and put on the top like this.

Thanks ylchuang !!!