topic Re: Column hide in pivot table in QlikView

Column hide in pivot table

vardhancse — Wed, 17 Jun 2015 04:38:45 GMT

Hi,

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

Re: Column hide in pivot table

PrashantSangle — Wed, 17 Jun 2015 04:51:32 GMT

Hi,

Use Conditional from Expression tab.

Regards

Re: Column hide in pivot table

avinashelite — Wed, 17 Jun 2015 05:01:17 GMT

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

Re: Column hide in pivot table

vardhancse — Wed, 17 Jun 2015 05:07:14 GMT

Can I have any sample syntax need to be followed

Re: Column hide in pivot table

PrashantSangle — Wed, 17 Jun 2015 05:22:50 GMT

Hi,

Write any condition which is always false

1=2

regards

Re: Column hide in pivot table

qlikmsg4u — Wed, 17 Jun 2015 05:26:33 GMT

Re: Column hide in pivot table

jagan — Wed, 17 Jun 2015 05:32:41 GMT

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.

Re: Column hide in pivot table

Anonymous — Wed, 17 Jun 2015 05:35:55 GMT

Hi ,

Try This

Re: Column hide in pivot table

Siva_Sankar — Wed, 17 Jun 2015 05:37:25 GMT

Check the steps here https://community.qlik.com/docs/DOC-3562

Re: Column hide in pivot table

vardhancse — Wed, 17 Jun 2015 06:18:44 GMT

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

Re: Column hide in pivot table

Wed, 17 Jun 2015 06:38:53 GMT

Hi Sasi,

You can use Conditional Enabling.

Properties ---> Dimensions -)--->select Used Dimensions Which one you need to hide ---> Setting for Selection Dimension --> Check conditional Enable below you can write --- Condition...

Ramya.

Re: Column hide in pivot table

vardhancse — Wed, 17 Jun 2015 06:45:25 GMT

Used condition:

=if(Year=2012,RGB(255,255,255),if(sum(Sales)>after(sum(Sales)) or sum(Sales)>before(sum(Sales)),Red(),Green()))

in the YOY expression.

Result is:

Can any one please let me know how to merge 2012 ans 2013 under YOY, or

completely remove 2012 under YOY or

Merge 2012 and 2013

gwassenaar‌ can please help me out.

Re: Column hide in pivot table

jagan — Wed, 17 Jun 2015 08:07:43 GMT

Hi,

PFA file for solution.

Regards,

jagan.

Re: Column hide in pivot table

hariprasadqv — Wed, 17 Jun 2015 08:13:32 GMT

-Enable expression on condition.

Re: Column hide in pivot table

Gysbert_Wassenaar — Wed, 17 Jun 2015 10:46:56 GMT

Use a straight table instead of a pivot table. See attached example.