topic Averages by type in QlikView

Averages by type

danielnevitt — Fri, 23 Aug 2013 14:32:10 GMT

Hi,

I have a table that contains different costs. Is it possible to show the high, low and average for each cost type and then also show the trade number that represents these.

Example data is attached in the excel file.

Any help is much appreciated.

Regards,

Daniel

Re: Averages by type

Gysbert_Wassenaar — Fri, 23 Aug 2013 15:16:06 GMT

Not quite. See attached example. There are two trade numbers that have to low value for freight. In that case it's not possible to return a number. There are no trade numbers with a value that matches the average value for the description.

Re: Averages by type

danielnevitt — Fri, 23 Aug 2013 15:41:34 GMT

Hi,

Thank you for your reply.

Is it possible to show the % difference between each trade number and the avg?

Trade Description Value Avg %Diff

1011 Freight 1,000,000 808,333 23.71

1014 Freight 600,000 808,333 -25.78

Ideally I would then like to set to show only values over 20% and under -20%.

Is that possible?

Thanks,

Daniel

Re: Re: Averages by type

Gysbert_Wassenaar — Fri, 23 Aug 2013 16:58:46 GMT

See attached qvw.

Re: Averages by type

Fri, 23 Aug 2013 18:44:59 GMT

Buenas tardes,

Podría probar agregar una expresión (sum(Value) / sum(TOTAL Value))*100

Saludos.