Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
alaeddinekacem
Contributor II
Contributor II

Hide unneeded rows in qlik view 11

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.capture3.PNG

22 Replies
YoussefBelloum
Champion
Champion

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
Master II
Master II

Hi Alaa,

Please refer the attachment.

It can be achieved by modifying your dimension.

Br,

KC

Best Regards,
KC
alaeddinekacem
Contributor II
Contributor II
Author

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.aaa.PNG

alaeddinekacem
Contributor II
Contributor II
Author

Hello Jyothish, aaa.PNG

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
Champion
Champion

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

alaeddinekacem
Contributor II
Contributor II
Author

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.

alaeddinekacem
Contributor II
Contributor II
Author

Hello,

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

Any help please ?

Best regards,

Alâa Eddine.

YoussefBelloum
Champion
Champion

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

alaeddinekacem
Contributor II
Contributor II
Author

Hello,

i open qlikview my desktop thanks to campany server.

Best regards,

Alâa Eddine.