Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
thymenkristen
Contributor III
Contributor III

Show the average of dataset per ProductCagegory in straighttable.

HI all,

Currently I'm working on a customer churn project. Therefore we are preparing a dataset which contains several variables. After the first attempts of creating a model, we decided to include some more variables.

In this case, I'm trying to realize to show  the Total  'Orderfrequency' avg(DagenTussenOrdersProduct) for each ProductCategory (ProductCategorie).

My goal is to show the outcome displayed in the 2nd column (see table below), in a straight table which shows per customer all productcategories with the 'total average orderfrequency' in each row.

thymenkristen_0-1627650471657.png

The dimensions of this straight table are: Customernumber, RepLevel2, RepLevel3 and Productcategorie.

thymenkristen_1-1627650769942.png

For now I can only get the total of the OrderFrequency, but im interested in the individual values of the first table.

Expression used in straighttable: =avg(TOTAL {1<DebiteurNummer=, RepLevel2=, Replevel3=>} DagenTussenOrdersProduct)

I'm looking forward to your replies.

Thanks in advance!

Regards,

Kristen

0 Replies