topic Re: Monthly Trend in Qlik Learning Discussions

Monthly Trend

Thu, 04 Sep 2014 21:22:31 GMT

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

Re: Monthly Trend

ecolomer — Thu, 04 Sep 2014 21:37:42 GMT

Can you prepare a set of data?

Re: Monthly Trend

VishalWaghole — Fri, 05 Sep 2014 05:09:58 GMT

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

Upload some dummy data and expected output.

-- Regards,

Vishal Waghole

Re: Monthly Trend

Agis-Kalogiannis — Fri, 05 Sep 2014 08:29:57 GMT

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