Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prasad_dumbre
Partner - Creator
Partner - Creator

Hiding a Expression in Pivote Table

Hi All,

Can you please guide me in fullfilling below req.

I have attached sample QVW

Capture.PNG

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

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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.

View solution in original post

6 Replies
swuehl
MVP
MVP

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.

Not applicable

Try Set analysis

Not applicable

May be this will work

Kushal_Chawda

Hi Prasad,

Please find the attched application.

I have used valuelist for required dimension & expression.

Regards,

Kushal chawda

Kushal_Chawda

You can further simplify as attched

prasad_dumbre
Partner - Creator
Partner - Creator
Author

@Swuehl & Kushal,

Capture1.PNG

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. . .