Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

Column hide in pivot table

Hi,

Have a requirement is that I want to hide some columns in the pivot table is that possible./

14 Replies
PrashantSangle

Hi,

Use Conditional from Expression tab.

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
avinashelite

use conditional hiding of the dimension and expression  in the chart properties

vardhancse
Specialist III
Specialist III
Author

Can I have any sample syntax need to be followed

PrashantSangle

Hi,

Write any condition which is always false

like

1=2

regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
qlikmsg4u
Specialist
Specialist

noval.png

jagan
Partner - Champion III
Partner - Champion III

Hi Sasi,

Check this link

Adhoc reporting in Qlikview

You can use Enable Conditional option in Dimension/Expressions tab to show/hide on a conditional basis.

Hope it helps you.

Regards,

Jagan.

Anonymous
Not applicable

Hi ,

Try This

Test.png

Siva_Sankar
Master II
Master II

vardhancse
Specialist III
Specialist III
Author

Hi Thanks for you reply.

But that is Adhoc reporting is not my reporting.

PFA QVW.

Have one pivot table ans year is a dimension.

But all the time want to display only 2013 column, so expecting to hide YOY-2012 column

Sales_YOY.JPG