topic Re: Two dimensional table in qlikview ? in QlikView

Two dimensional table in qlikview ?

vishnus85 — Fri, 14 Feb 2014 01:17:19 GMT

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

Re: Two dimensional table in qlikview ?

Fri, 14 Feb 2014 01:25:30 GMT

Hi,

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

Re: Two dimensional table in qlikview ?

vishnus85 — Fri, 14 Feb 2014 03:50:22 GMT

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