topic Re: Trending of sales in App Development

Trending of sales

ranibosch — Wed, 18 Oct 2017 14:22:13 GMT

Hi, I've got a field called TRENDING CODES.

In this field I've got the following values:

1. MFGTYPE

2. PACKSIZE

each of the above mentioned fields are then linked to anothre table called dimension values.

so basically it can be broken down as follows:

1. MFGTYPE:

a. hand pack

b. machine pack

2. PACKSIZE:

a. 30g

b. 100g

c. 450 g

i would like to create a trending chart where i group the sum of sales per month for MFGTYPE hand pack vs machine pack

and then another chart where i compare the same as above, but only for the pack sizes.

how do i do this on the object in my design?????

Re: Trending of sales

felipedl — Wed, 18 Oct 2017 18:42:52 GMT

Hi Rani,

You would need to use set analysis for this.

I've attached a sample QVW with some dummy data for you so that you can see how it's done.

Felipe.

Re: Trending of sales

ranibosch — Thu, 19 Oct 2017 13:03:46 GMT

Hi Felip,

I cannot open the file, due to it not being created on my personal computer.

could you perhaps send a screenshot?

Re: Trending of sales

felipedl — Thu, 19 Oct 2017 13:11:55 GMT

Sure Rani,

Code for this is in the Sample.txt file and expression in Expressions.txt.

Felipe.

Re: Trending of sales

ranibosch — Thu, 19 Oct 2017 14:06:06 GMT

THANK YOU VERY MUCH!

Re: Trending of sales

felipedl — Thu, 19 Oct 2017 14:07:02 GMT

No problem, glad to help .

Re: Trending of sales

ranibosch — Fri, 20 Oct 2017 11:18:35 GMT

Hi there,

I've got one more question.

what will my expression look like if I want to add another condition to it.. for example:

sum of the machine pack sales specifically for the WWS business unit?

Re: Trending of sales

felipedl — Fri, 20 Oct 2017 11:20:31 GMT

Hi Rani,

Would be something like this:

sum({<[Data Type Description]={"machine pack"},[Business Unit]={"WWS"}>}[Sales Value])

Felipe.