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: 
Not applicable

Monthly Trend

I generate a report everyday about no of products from one place. I want to display the average number of products from those places in front of the days numbers. How to do that?

Eg. Let for today Place - A, B, C

                         Products - 2,6,4

Similarly for a month I generate this report everyday. I want to introduce a column with average products so that I have an idea.
Please help

3 Replies
ecolomer
Master II
Master II

Can you prepare a set of data?

VishalWaghole
Specialist II
Specialist II

Hi Akshay please elaborate more, it doesn't gives more clarification.

Upload some dummy data and expected output.

-- Regards,

Vishal Waghole

Agis-Kalogiannis
Employee
Employee

Although I admit that a sample data set would be useful in this case, have you tried doing something like:

avg(aggr(count(Products), Place))

Regards

Agis