Creating Target value in a pivot chart

[bushpalaamarnat]

Hello All,

i am trying to insert a target field (like SFA = 70% and SFB is 10%) in the below table of the qlik view. and my current expression is as following:

NUM(IF(SUM({<CALCULATION_TYPE = {'SFA'}>}[FC: VALUE ERROR]) / SUM({<CALCULATION_TYPE = {'SFA'}>}[ACTUAL VALUE]) > 1, 0,

IF(SUM({<CALCULATION_TYPE = {'SFA'}>}[FC: VALUE: (Vol x NSV Rate)]) * SUM({<CALCULATION_TYPE = {'SFA'}>}[ACTUAL VALUE]) <= 0, 0,

1-(SUM({<CALCULATION_TYPE = {'SFA'}>}[FC: VALUE ERROR]) / SUM({<CALCULATION_TYPE = {'SFA'}>}[ACTUAL VALUE])))), '##.00%')

Could you please advise how to do it. I have created an inline table as follows but still not getting the out put.

[balabhaskarqlik]

You can refer Pareto Analysis:

Re: Pareto Analysis

Num(Sum({<[Customer ID] = {"=Rank(Sum(Revenue)) < (Count(TOTAL DISTINCT [Customer ID])*0.20) + 1"}>}Revenue)/Sum(Revenue), '##.0%').

[balabhaskarqlik]

And also these:

https://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis

http://www.learnallbi.com/pareto-chart-in-qlikview/

https://community.qlik.com/blogs/qlikviewdesignblog/2014/09/15/abc-analysis

[bushpalaamarnat]

Hi ,

Target value i have it as inline table in the script.

The out put should be like this