topic Re: Pivot Table - unable to pivot dimension date in QlikView

Pivot Table - unable to pivot dimension date

Anonymous — Fri, 14 Feb 2014 12:38:51 GMT

Hi All,

Need help with pivoting date column,tried number of times but unable to pivot date column.

please see attached docs(QVW and Screenshot).

Result should be same as screenshot attached and unable to hide column status with rgb values

Re: Pivot Table - unable to pivot dimension date

MK_QSL — Fri, 14 Feb 2014 12:42:37 GMT

Go to Presentation tab

and tick allow pivoting

Re: Pivot Table - unable to pivot dimension date

Fri, 14 Feb 2014 12:47:40 GMT

Hi Nitha

As Manish said, you need to check "allow pivoting" then you can drag and drop the dates to the top of the chart.

In order for status to be shown in the cells, the cell value expression should be the actual status and the cell colour expression needs to be the function that you have with RGB() in it.

See attached

Erica

Re: Pivot Table - unable to pivot dimension date

preminqlik — Fri, 14 Feb 2014 12:51:30 GMT

hi PFA

Re: Pivot Table - unable to pivot dimension date

mangalsk — Fri, 14 Feb 2014 13:04:51 GMT

Hello,

I have done as per your requirement

Re: Pivot Table - unable to pivot dimension date

Anonymous — Fri, 14 Feb 2014 14:03:03 GMT

Tried with Ticked allow pivoting still unable to pivot

Re: Pivot Table - unable to pivot dimension date

Anonymous — Fri, 14 Feb 2014 14:12:39 GMT

Hi Guys,

Thanks for all help,but i am not able to do pivoting
after ticking allow pivoting check box

Re: Pivot Table - unable to pivot dimension date

MK_QSL — Fri, 14 Feb 2014 14:12:53 GMT

here we go...

Re: Pivot Table - unable to pivot dimension date

Anonymous — Fri, 14 Feb 2014 14:41:03 GMT

Thanks guys for all help and able to pivot and successful.

All replies are correct
and unable to mark all correct and helpful.

Thanks

Nitha