How to find averege.

[#1]

Hi,

How to find average i qlikview I'm facing some issue with this plz explain with supporting documents.

Thanks

[sunny_talwar]

What is the expected output here? and you mentioned Avg by month, but there is no month field in your application

[santiago_respane]

Hi,

First you need a month field, or at least add it as a calculated dimension. Supposing you create your field it would be like this:

LOAD [Shop ID],

          Trancation,

          SaleDate,

          MONTH(SaleDate) as SaleMonth

FROM (ooxml, embedded labels, table is Sheet1);

And then you create a chart and add it as a dimension.

Please let me know if this helps.

Kind regards,

[#4]

Thanks Sunny.

i need to find 

1)average sales per month

2)average sales per Store

3)Average sales per city

4)Average sales per client

above  attachment i sample data (from date we can find month). please guide me what expression should i write and what is my dimension. please

[sunny_talwar]

Have you tried creating a cycle group with Month, Store, City, client as dimensions and Avg(Sales) as Expression?

[#6]

ok i got it thanks. but now i have small doubt if  i have three fields

Tranction ID

Shop ID

Month

My requirement is average trancation count of a shop in a month.

[sunny_talwar]

May be like this:

Dimension:

Shop ID

Month

Expression:

Avg(Aggr(Count([Transaction ID]), SaleDate, Month, [Shop ID]))

[#8]

Thanku Sunny,

Please guide me any thing wrong in this app please. !

[Anil_Babu_Samineni]

Try to take these dimensions into one Dimensions and then Try...