This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a column of years, months and a column of temperature of every month
I need to make the avarage between the same month of diferents years
The avarage of all the Januarys, Februarys.....
@Askquestioncan you share a sample data and the expected output ?
Month | Temperature
Jan/20 | 10
Fev/20 | 15
Jan/21 | 20
Fev/21 | 25
Month | Temperature | Month Avarage
Jan/20 | 10 | 15
Fev/20 | 15 | 20
Jan/21 | 20 | 15
Fev/21 | 25 | 20
data:loadDate#(Month, 'MMM/YYYY') as MonthYear,Month(Date#(Month, 'MMM/YYYY')) as Month,Temperature;load * inline [Month, Temperature
left join (data)loadMonth,avg(Temperature) as Month_Averageresident datagroup by Month;
Very thank you it worked!
But there's a problem I forgot to say
I have 2 diferents cities and I need to calculate their months saparely with this method it made the avarage of both how can I fix it?
left join (data)loadMonth,
City,avg(Temperature) as Month_Averageresident datagroup by Month, City;
It worked very well thank you so much!!!!
you can simply load the data in the script and use aggr in your expression.
Avg(Aggr(Sum(Temp),Month,City)) this will work
Great. If you can please mark solution(s) so thread can be marked appropriately.