topic Pivot table column name orientaion in QlikView

Pivot table column name orientaion

madhumitha — Thu, 16 Nov 2017 05:52:15 GMT

Hello All,

I am trying to achieve the below orientation for my pivot table. Could you please help me with a work around?

I have pivoted 3 dims, month, week and date.

I need to show data alone in vertical orientation, where rest should be horizontal.

Thanks in advance.

Re: Pivot table column name orientaion

marcus_sommer — Thu, 16 Nov 2017 08:56:31 GMT

It's not possible to mix a horizontal and vertical displaying within a single object. Maybe this is an workaround: Re: Vertical Data Text in Pivot Table whereby in your case I would just use the day() from your date because the month- and year-information is already displayed.

- Marcus

Re: Pivot table column name orientaion

madhumitha — Thu, 16 Nov 2017 12:07:12 GMT

Thanks Marcus.