topic Re: Hiding a Expression in Pivote Table in QlikView

Hiding a Expression in Pivote Table

prasad_dumbre — Sat, 06 Jul 2013 16:54:50 GMT

Hi All,

Can you please guide me in fullfilling below req.

I have attached sample QVW

In this, I want to hide Calulation 2 under Budget , But It should be visible under Actual.

Re: Hiding a Expression in Pivote Table

swuehl — Sat, 06 Jul 2013 17:07:55 GMT

A pivot table will show all expressions for all dimension values.

The only way I can think of to achieve something similar is by converting your expressions into an additional dimension and check your ExpressionDim in your single expression to select the correct expression.

Please check attached.

Re: Hiding a Expression in Pivote Table

Sat, 06 Jul 2013 17:22:06 GMT

Try Set analysis

Re: Hiding a Expression in Pivote Table

Sat, 06 Jul 2013 17:34:03 GMT

May be this will work

Re: Hiding a Expression in Pivote Table

Kushal_Chawda — Sun, 07 Jul 2013 06:37:02 GMT

Hi Prasad,

Please find the attched application.

I have used valuelist for required dimension & expression.

Regards,

Kushal chawda

Re: Hiding a Expression in Pivote Table

Kushal_Chawda — Sun, 07 Jul 2013 08:46:49 GMT

You can further simplify as attched

Re: Hiding a Expression in Pivote Table

prasad_dumbre — Mon, 08 Jul 2013 05:41:53 GMT

@Swuehl & Kushal,

Can we use this thing where we can put conditions like

=if(WildMatch(A/B,'*Budget*'),0,1)

to achieve the same result ? Coz my actual scenario is too complex & have to think twice before making any mojor changes in expresions or backend . . .

But still thanks to both of you, as your solutions shown me some way to achieve this. . .