Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
NickBentley
Contributor III
Contributor III

Set Analysis calculation

I am using the 2 expressions in a straight table below to calculate sales data for when the temperature is either above 30 or between 25 -30. 

=sum({<[Store Max Temp]={">=30"}>}Sales_Value)

=sum({<[Store Max Temp]={">=25<30"}>}Sales_Value)

These are working fine when only 1 store is selected. 

However, when multiple stores are selected sales numbers appear in both columns when really I would like just the average temperature of the stores combined to be the  [Store Max Temp]  calculated. 

Is there a way of calculating the average before the set analysis take effect? 

Thanks in Advance! 

2 Replies
sergio0592
Specialist III
Specialist III

In your chart, try with :

=avg(sum({<[Store Max Temp]={">=30"}>+<[Store Max Temp]={">=25<30"}>    }Sales_Value))
NickBentley
Contributor III
Contributor III
Author

Thanks for your reply sergio0592. 

Unfortunately it is not returning the solution I am after. 

Need to find away of averaging the store temperatures before the set analysis is appraised.