topic Qlikview 80-20 issue in QlikView

Qlikview 80-20 issue

sayanpwc — Tue, 27 Feb 2018 15:56:06 GMT

Hello friends,

Need an urgent help regarding one problem I am facing. My business requirement is to show count of material /Vendors in terms of sales percentage in a chart where in the chart x axis will represent the sales percentage sections. i. e 0-80 %,81-90%,91-100% and based on that count of material will be calculated through BAR.

So basically user want to see what is the count of material that contributes to 80% sales, what is the percentage of materials that contributes to 81-90% sales and so on...

For ex:

Material Sales % of Total Sales

A 100 5 %

B 200 10%

C 300 15%

D 300 15%

E 500 25%

F 500 25%

G 100 5%

So total sales is 2000. Based on that % total sales is calculated in front end. So according to that top 80% contributor materials are E,F,C,D.

So in my chart under x axis value 0-80% count of material should be 4(C,D,E,F), and rest 20 % count of material is 3(A,B,G).

How can i show this in a bar chart? Please help me.Appreciated for the help.

Re: Qlikview 80-20 issue

sunny_talwar — Tue, 27 Feb 2018 17:47:50 GMT

Look here

80-20 Analysis problem in Qlik

Re: Qlikview 80-20 issue

pablolabbe — Tue, 27 Feb 2018 19:24:54 GMT

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

Re: Qlikview 80-20 issue

sayanpwc — Tue, 27 Feb 2018 20:46:19 GMT

=Aggr(

If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.8, 'A',

If(Rangesum(Above(Sum({1} Sales)/Sum({1} total Sales),1,RowNo()))<0.9, 'B',

'C')),

(Product,(=Sum({1} Sales),Desc))

)

this syntax giving syntax error. Please reply what is the problem in the syntax.

Re: Qlikview 80-20 issue

sunny_talwar — Tue, 27 Feb 2018 20:49:10 GMT

Did you try clicking okay to see if you get any result?

Re: Qlikview 80-20 issue

sayanpwc — Tue, 27 Feb 2018 20:50:39 GMT

yes,.showing error in expression

Re: Qlikview 80-20 issue

sunny_talwar — Tue, 27 Feb 2018 20:55:07 GMT

My bad, which version of QlikView are you using? I assumed that you might be using Qlik Sense, but if you are using QlikView, this functionality is only available after QV12.1 or above

Re: Qlikview 80-20 issue

sayanpwc — Tue, 27 Feb 2018 21:00:47 GMT

is it? i am using qlikview 11.

Re: Qlikview 80-20 issue

sayanpwc — Tue, 27 Feb 2018 21:01:31 GMT

its giving syntax error. dnt know if it version issue

Re: Qlikview 80-20 issue

sunny_talwar — Wed, 28 Feb 2018 00:08:10 GMT

This won't work in QV11.2... May be look at this thread for not so pretty work around ABC Analysis in Qlikview