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.

[YoussefBelloum]

Hi,

you have 3 measures on the table above ? Actual sales, Frocast, Accuracy, right ?

on each one of them, use a set analysis to filter your data the way you want.

would you be able to share your expressions ?

[jyothish8807]

Hi Alaa,

Please refer the attachment.

It can be achieved by modifying your dimension.

Br,

KC

[Anonymous]

Hello Youssef,

i want to filter SUB/Agg Brand Accuracy. I want to hide all Accuracy values greater than 80% to do my analysis only on products with accuracy values <0.8.

Thnak you.

[Anonymous]

Hello Jyothish,

i want to filter SUB/Agg Brand Accuracy. I want to hide all Accuracy values greater than 80% to do my analysis only on products with accuracy values <0.8.

This is the formula :

= 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 )))).

Thank you.

[YoussefBelloum]

alaeddinekacem Read carefully Jyothish answer, open his app and apply the calculated dimension on your app.. it is working

[Anonymous]

Hello,

i do nt know where i can find this, i am new here. Can you send me the attachment, please?

Best regards,

Alâa Eddine.

[Anonymous]

Hello,

i find the attachment but i do not know how to open it.

Any help please ?

Best regards,

Alâa Eddine.

[YoussefBelloum]

no problem, we're here to assist. how do you open Qlikview apps ? do you have Qlik desktop ?

[Anonymous]

Hello,

i open qlikview my desktop thanks to campany server.

Best regards,

Alâa Eddine.