Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
acgomes
Partner - Contributor III
Partner - Contributor III

Show measure column in a dimension column if dimension value is equal to specific value on pivot table

Hello,

I have this Pivot Table organized like this, 1 row dimension, 1 column dimension and 3 measures, something like this

  Dimension B Value A Dimension B Value B Dimension B Value C
  Measure 1 Measure 2 Measure 3 Measure 1 Measure 2 Measure 3 Measure 1 Measure 2 Measure 3
Dimension A Value X x x x x x x x x x
Dimension A Value Y x x x x x x x x x
Dimension A Value Z x x x x x x x x x

 

I would like that Measure 3 was only displayed when Dimension B Value is equal to B or C, is that possible?

In other words, I want to hide what is in yellow.

I tried to use the field 'Show Column If' of Measure 3 with the expression below, but I did not manage to make this work. Im my mind, this should be enough.

If( Match([Dimension B], 'Value B', 'Value C') >= 1, 1, 0 )

Thanks

Labels (1)
1 Solution

Accepted Solutions
Timario
Contributor III
Contributor III

Hi. You can't hide only  measure from Values only for 1 dimension. Expression for hide values in measure works for all (valueA, valueB, valueC)

View solution in original post

7 Replies
sidhiq91
Specialist II
Specialist II

@acgomes  Could you please provide some sample data? I will try to help you out.

Timario
Contributor III
Contributor III

Hi. 

For hide, you can use only expression, without if and values after comma.  For example:

Match([Dimension B], 'Value B', 'Value C')

acgomes
Partner - Contributor III
Partner - Contributor III
Author

Hello,

Thanks for the answers. 

@sidhiq91 I attached a .qvf with data that should reproduce the scenario. 

@Timario , unfortunaly, your suggestion did not work or I implemented incorretly in the .qvf attached using the following expression Match(dimensionB, 'valueB', 'valueC').

I need to hide only the column crossed.

acgomes_0-1662153414007.png

rgds

Timario
Contributor III
Contributor III

Hello. You can't hide only 1 measure only for ValueA in pivot table. Expression for hide values in measure works for all (valueA, valueB, valueC)

acgomes
Partner - Contributor III
Partner - Contributor III
Author

That is also the impression I had, unfortunatelly. I guess "Show measure if" instead of "Show column if" would be a bit clearer.

Thanks.

 

Timario
Contributor III
Contributor III

Hi. You can't hide only  measure from Values only for 1 dimension. Expression for hide values in measure works for all (valueA, valueB, valueC)

acgomes
Partner - Contributor III
Partner - Contributor III
Author

Guess I will suggest this as an idea. The measure we are using only make sense to appear for certain values of the dimension. Also, this is not the type of situation where I can make a measure for each dimension value with set analysis (unpredictable and many dimension values).