Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pivoting in Adhoc report

Hi All,

I'm trying to do pivoting in Adhoc report I created but unfortunately can not put the dimension on top of chart !

Does anybody know where the problem is with the Adhoc?

Thanks,

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Pivoting in Adhoc report

Yes.

I found the problem.

If you have many Dimension and expression for some reason it does not work or at least in my case

I tried to reduce the dimensions and do the pivot and then add the dimensions then it worked.

Thanks for the reply.

Nima

View solution in original post

5 Replies
Highlighted
Specialist
Specialist

Re: Pivoting in Adhoc report

Check that Allow pivoting is set on Presentation tab.

Pivoting is a little tricky with a mouse. Are blue lines appearing when you grab the dimension label ?

Jonathan

Highlighted
Not applicable

Re: Pivoting in Adhoc report

Thanks , but it is not the case. I'm able to move the dimensions back and forth but not able to put it on the top !!!!

Highlighted
Specialist
Specialist

Re: Pivoting in Adhoc report

Are you sure it is a pivot table and not a straight table ?

Jonathan

Highlighted
Not applicable

Re: Pivoting in Adhoc report

Yes.

I found the problem.

If you have many Dimension and expression for some reason it does not work or at least in my case

I tried to reduce the dimensions and do the pivot and then add the dimensions then it worked.

Thanks for the reply.

Nima

View solution in original post

Highlighted
Not applicable

Re: Pivoting in Adhoc report

Hi Nima ,


Can you please explain how it was achieved?