Two dimensional table in qlikview ?

[vishnus85]

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.

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

[#2 · Accepted solution]

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]

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