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: 
Not applicable

Only Display a Dimension for a specific Expression

Hi,

I need to suppress a dimension (Month) in a Pivot Table so that it only displays for a specific expression.

Expressions                    Sales                            Purchases     

Dimension - Month     Jan. Feb. Mar. Total      'No Month Dimension to be displayed''

Amount                       10   20    30       60               15

Any help would be appreciated.

Tony

3 Replies
Not applicable
Author

For the secondary Dimension (say it's the field "Month"), instead use a Calculated Dimension:

if( [PrimaryDim] = 'Purchases', Null(), [Month] )

PrimaryDim is whatever the field for your first dimension.

Then you may want to set the Null Symbol to empty on the Presentation tab.

Not applicable
Author

Hi Donald,

Thanks for the reply.

I'm trying to use your suggestion but without success.

Could you use the attached qvw to suggest a way.

Thanks

Tony

Not applicable
Author

Sorry, I misunderstood your requirement.

I'm not sure you can effectively suppress a dimension in your chart for just one of your expressions.  The expressions will be evaluated in the context of the dimensions.

You can vary the expression, of course.  You can even vary the expression based on the context of its dimension.  But neither will help you, here.

I suppose you could create a table just for your Purchases and park it right next to your Sales table.

Perhaps someone else will see somehting I'm missing here.