topic Only Display a Dimension for a specific Expression in QlikView

Only Display a Dimension for a specific Expression

Wed, 27 Feb 2013 22:45:00 GMT

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

Re: Only Display a Dimension for a specific Expression

Thu, 28 Feb 2013 01:38:46 GMT

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.

Re: Only Display a Dimension for a specific Expression

Thu, 28 Feb 2013 11:31:55 GMT

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

Re: Only Display a Dimension for a specific Expression

Thu, 28 Feb 2013 16:38:55 GMT

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.