Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jrahul9797
Contributor

Custom Table creation

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.

4 Replies
YoussefBelloum
Esteemed Contributor

Re: Custom Table creation

hi,

what do you mean with Above and Below ?

jrahul9797
Contributor

Re: Custom Table creation

Above- # territories having sales more than the average sales

.

Re: Custom Table creation

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

YoussefBelloum
Esteemed Contributor

Re: Custom Table creation

try this,

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

or

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

find attached

Community Browser