Discussion board where members can learn more about Qlik Sense App Development and Usage.
I have the following results (pivot table) State A State BCompany A avg(DurationDays)
-- State A State BCompany A 5 4Compnay B 3 12
Now they want to get a horizontal summary may be in seperate table
They Want Company A 9 days Company B 15 days
tried things like aggr(avg(DurationDays),StateDescription) with the dimension company, but then i get null values
how to fix this ?
Go to Solution.
Use Company as dimension
Sum(Aggr(Avg(DurationDays), Company, State))
What do you want to do? Sum the averages or average the averages or something else?
If you want the sum of averages try something like this: Sum(aggr(avg(DurationDays),CompanyNameDimensionHere,StateDescription))
If you are using a straight table then try :
Can you plz elaborate little more