Discussion board where members can get started with Qlik Sense.
Can we create a custom table using Qlik sense?
I have territory-wise sales data. I want to create a table denoting the distinct number of territories with above average sales and distinct number of territories with below average sales.
I have created an Inline table with values 'High' and 'Low'.
Can anybody guide me through this. Attached is the sample data set with the second tab showing the rough kind of output that is required.
what do you mean with Above and Below ?
Above- # territories having sales more than the average sales
Isn't this the same thing as the last question on the other post? or is this different?
=if(sum( [Total Sales])> avg(TOTAL [Total Sales]),...
=if(sum( [Total Sales])< avg(TOTAL [Total Sales]),...