We help IT Professionals succeed at work.

Why doesn't my QlikView pivot tables pivot ?

Tocogroup
Tocogroup asked
on
1,201 Views
Last Modified: 2014-08-29
Hi,

I have a pivot table chart on a sheet in QlikView made up of 3 dimension columns and a single expression column. However, when I try to move one of the columns to the horizontal plane it doesn't allow me. I can move the columns around on the vertical axis, but not to the horizontal axis.

Is there a setting I'm unaware of ?

Regards
Toco
Comment
Watch Question

RobOwner (Aidellio)
CERTIFIED EXPERT
Most Valuable Expert 2015

Commented:
Can you attach your file as it's usually just a drag and drop

Author

Commented:
Sorry Rob. I found it. I just wasn't being precise enough. QV can be very particular at times.

Sending you the file is not always possible as it contains finance details of clients. For my own interest, how are you able to view my QV applications when they were built via a Personal Edition of QV ?
RobOwner (Aidellio)
CERTIFIED EXPERT
Most Valuable Expert 2015

Commented:
I have the enterprise edition so I can open any qvw file. Glad you found it anyway. Did tutu end yo just dragging them?
Understand you can't disclose the file, but there is an obfuscate function so you can share it (scrambles the data). Was just going to save me creating a demo but I may do it anyway

Author

Commented:
Yes, I just dragged and dropped. I'd done this before on another application but in this case it was being very reluctant, hence why I wondered if there was an enabling checkbox.

Interesting about the obfuscate function. That'll be useful. I'm assuming it's not called 'obfuscate' !!
RobOwner (Aidellio)
CERTIFIED EXPERT
Most Valuable Expert 2015

Commented:
Good assumption! But it's in the document or user settings menu, can't remember exactly

Author

Commented:
Yes you're right. It's on the 'Scrambling' tab in Document Properties of the Settings menu.
Thanks for that.
Owner (Aidellio)
CERTIFIED EXPERT
Most Valuable Expert 2015
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thanks again for your assistance.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.