topic Re: Suppress Values in Calculated Dimensions in QlikView

Suppress Values in Calculated Dimensions

Fri, 24 Jun 2016 10:00:52 GMT

Hello,

I want to show the sales forecast per week for my top 5 sellers till date in line chart.

The data is as follows:

Model_Name	Month_Week	Units Sold	Forecast_Run_1	Forecast_Run_2

The data is there for Jan to June however the forecast is only for the 4 weeks of June,2015.

I have achieved the same by creating a line chart Month_Week as one dimension and another calculated dimension Model which is as follows:

=If(Match(Model_Name,if(Aggr(Rank(Sum({1}Units_Sold)),Model_Name)<=5,Model_Name)),Model_Name,'Others')

I am getting the following result:

I am getting the required products,but also getting an Others field,which comes as a - if not included in the if condition for calculated dimension. I want to get rid of this field. I have tried using Dimension Limits but to no avail.

Please suggest a solution.

Re: Suppress Values in Calculated Dimensions

swuehl — Fri, 24 Jun 2016 10:22:22 GMT

Try using this as calculated dimension:

=Aggr( If(Rank(Sum({1}Units_Sold))<=5,Model_Name),Model_Name)

and enable 'Suppress when Value is NULL'

on dimension tab

Re: Suppress Values in Calculated Dimensions

Fri, 24 Jun 2016 10:31:53 GMT

Thanks Stefan,

This works. My first question on the community answered in record time.

I tried the 'Suppress when Value is NULL' option with my original expression, but it did not work.

Could you explain this solution in a bit more detail ?

Thanks.