Discussion board where members can get started with Qlik Sense.
I need help in calculating average of months value, i have a column which has value and other is month.
Here if we take example for Shoe average comes to 3754121, how can i get this figure by using some expression in Qlik Sense.
How is your table looks like?
I have change the question now...
You can simplify this in straight table
If this is in Text box
Load Item, Num(Avg(Value),'#,##0') as Value Resident Table Group By Item;