topic Re: Put a condition on a dimension in QlikView

Put a condition on a dimension

Fri, 03 Apr 2015 18:09:14 GMT

I have created a pivot table that contains the following dimensions:

Division, Item, and Measure.

The other items are expressions that contain calculations based on what the user inputs for the year & quarter.

My dilemma is that I don't want items to appear if the shipment quantity for that item is 0. For instance, if the '2014 Q1 Data' column has 0 for the item then I don't want the item to appear at all.

Here's what the chart looks like:

I have tried the enable conditional on the item dimension but it's not working. Any other suggestions????

Here is what I put in the enable conditional:

=sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)},Measure={'Shipment Qty'}>}(Value))<>0

Re: Put a condition on a dimension

sunny_talwar — Fri, 03 Apr 2015 18:35:04 GMT

For each of your other expressions (except 2014 Q1 Data) you can use the following if condition:

=If([2014 Q1 Data] > 0, yourExpression)

Here [2014 Q1 Data] should match the exact label for the expression you want to use (hint: [2014 Q1 Data] will turn blue when it exactly matches the label)

HTH

Best,

Sunny

Re: Put a condition on a dimension

Anonymous — Fri, 03 Apr 2015 20:12:56 GMT

Or you can try to replace Item dimension with calculated dimension (and label it Item):

aggr(if(sum({<FYEAR={$(vCompYr)},QUARTER={$(vCompPrd)},Measure={'Shipment Qty'}>}(Value))<>0,Item),Item)

As always with calculated dimensions - don't forget to check "Suppress when Value is Null"

Re: Put a condition on a dimension

Mon, 06 Apr 2015 18:20:10 GMT

when I do the calculated dimension, it won't give any items at all

Re: Put a condition on a dimension

Anonymous — Mon, 06 Apr 2015 19:07:27 GMT

I would create a flag (1 or null) in the script at item, fiscal year, qtr (lowest level) based on whether shipment qty is 0 or not and use it in the calculated dimesion for item

Re: Put a condition on a dimension

Anonymous — Mon, 06 Apr 2015 21:52:06 GMT

Why not? Can you upload an example?