Need a help in calculating Accuracy

[SatyaPaleti]

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

[prabhu0505]

using this expression

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

[MarcoWedel]

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