Custom Table creation

[Anonymous]

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.

[YoussefBelloum]

hi,

what do you mean with Above and Below ?

[Anonymous]

Above- # territories having sales more than the average sales

.

[sunny_talwar]

Isn't this the same thing as the last question on the other post? or is this different?

[YoussefBelloum]

try this,

=if(sum( [Total Sales])> avg(TOTAL [Total Sales]),...

or

=if(sum( [Total Sales])< avg(TOTAL [Total Sales]),...

find attached