topic Need a help in calculating Accuracy in QlikView

Need a help in calculating Accuracy

SatyaPaleti — Wed, 05 Aug 2015 18:33:50 GMT

Hi Folks,

Attached is the data...

I want to create line chart by using expression 1-(fabs([Quantity])/[Real Qty]) and dimension is Date.

But I am Unable to see the values

I am getting output as following

Result should be in percentage.. Here I am getting output. it's displaying only 100% I want to show all the data.

Could any one one help how to resolve this issue. It's Really Needful

Thank you,

Satya Paleti

Re: Need a help in calculating Accuracy

prabhu0505 — Wed, 05 Aug 2015 18:47:09 GMT

using this expression

=1-(fabs(sum(Quantity))/sum([Real Qty]))

Re: Need a help in calculating Accuracy

MarcoWedel — Wed, 05 Aug 2015 21:13:40 GMT

Hi,

as already said, you are missing an aggregation function to define the type of aggregation of your multiple Quantity and Real Quantity values per date.

Another thing you could change is to load your dates without time values like this:

LOAD DayName(Date) as Date,
     Timestamp(Date) as Timestamp, 
     Quantity, 
     [Real Qty]
FROM https://community.qlik.com/servlet/JiveServlet/download/838507-179189/data2.xls (biff, embedded labels, table is Sheet1$);

The result could look like:

hope this helps

regards

Marco