topic Chart Dimension should be restricted by Expression Availability in QlikView

Chart Dimension should be restricted by Expression Availability

Anonymous — Tue, 16 Feb 2016 06:59:21 GMT

I have a chart with Dimension as Material(A).The Expression are Consumption(B) and Consumption Limits(C).

Now I don't have all the Consumption limits(C) available readily for all the Material(A).

I should show only materials(A) which has Consumption limits others should be hided.

When the consumption limits is available then we can show the other Materials(A).

In other words Material (A) which doesnt have Consumption limits(NULL or Zero) should be not shown in chart

What formulae or calculated dimension should be written in the chart.

Re: Chart Dimension should be restricted by Expression Availability

Mark_Little — Tue, 16 Feb 2016 08:32:16 GMT

Hi,

I would use a calculated dimension, something like

IF(ISNULL([Consumption Limits]) = 0 or [Consumption Limits] <> 0, Material)

Mark

Re: Chart Dimension should be restricted by Expression Availability

sunny_talwar — Tue, 16 Feb 2016 09:45:09 GMT

I think you can adjust your expressions to handle this as well:

1st Expression for Consumption:

If(Column(2) > 0, ConsumptionExpression)

2nd Expression for Consumption Limit:

ConsumptionLimitsExpression

and then make sure to have 'Suppress Zero Values' checked on the presentation tab.

NOTE: it is important to have order of expression right because we are using Column() function. Here it is checking if Column(2) (the expression for ConsumptionLimitsExpression > 0 or not) So if you change these two expressions around then use the column number for your consumptionLimitsExpression.

I hope this will help.

Best,

Sunny