Hide unneeded rows in qlik view 11

[Anonymous]

Hello,

I tried here to calculate the forecast accuracy of products expressing in percentage. My aim is to deal with the products that have a bad accuracy ( less than 80%) so i want to let in my chart only the product that they have a bad accuracy and do hide finally products with accuracy upper than 80%.

How can I do, please?

Best regards,

Alâa Eddine.

[jyothish8807]

Sure, no problem. In this case will it be possible for you to share your sample application ?

You can attach the sample by clicking "Use Advanced editor"

Br,

KC

[Anonymous]

Hello KC,

i do not know how to do this. Is there any other idea, please?

Thank you,

Alâa Eddine.

[jyothish8807]

Try this:

replace your SalesYearMonth dimension with below . You have to then modify your cyclic field as well using the same logic, just replace SalesYearMonth  with other fields.

=aggr(If(

If ((1- (sum (fabs(aggr(sum ([SalesActualSales])

, SalesSubsidiaryCode_CD, SalesAggregatedBrand_CD,SalesYearMonth) -

aggr(sum ([SalesForecastM-2]), SalesSubsidiaryCode_CD, SalesAggregatedBrand_CD,SalesYearMonth)))/sum(aggr(sum([SalesActualSales]),

SalesSubsidiaryCode_CD, SalesAggregatedBrand_CD,SalesYearMonth ))) < 0

or sum(aggr(sum([SalesActualSales]), SalesSubsidiaryCode_CD, SalesAggregatedBrand_CD

,SalesYearMonth))= 0),0

,1- (sum (fabs(aggr(sum ([SalesActualSales]), SalesSubsidiaryCode_CD,

SalesAggregatedBrand_CD,SalesYearMonth)

- aggr(sum ([SalesForecastM-2]), SalesSubsidiaryCode_CD, SalesAggregatedBrand_CD,

SalesYearMonth)))

/sum(aggr(sum([SalesActualSales]), SalesSubsidiaryCode_CD,

SalesAggregatedBrand_CD,SalesYearMonth ))))

> '0.8',null(),SalesYearMonth),SalesYearMonth)