topic Creating Target value in a pivot chart in QlikView

Creating Target value in a pivot chart

bushpalaamarnat — Thu, 26 Jul 2018 08:00:19 GMT

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.

BalaBhaskar_Qlik — Thu, 26 Jul 2018 12:50:38 GMT

You can refer Pareto Analysis:

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

BalaBhaskar_Qlik — Thu, 26 Jul 2018 12:52:36 GMT

And also these:

bushpalaamarnat — Thu, 26 Jul 2018 13:43:40 GMT

Hi ,

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

The out put should be like this