Trend or progression calculation from the launch of product

[tsagarrao]

I would like to calculate the trend of a Product sales trend  (%change) by product from its launch date in Qlikview. The sample data was attached.

The last two columns need to derive in Qlikview and would like to see the last column as Trend. I need your help

prat1507

stalwar1‌

marcowedel‌

anilbabu‌

[Anil_Babu_Samineni]

Can you define exactly your needed here?

[tsagarrao]

I need the sales difference for a product when it launched to latest date. If a product launched on 2nd of a month, what was the sales trend on 24 th with respect to 2nd of the month.

[MarcoWedel · Accepted solution]

Hi,

maybe one solution might be:

Num(FirstSortedValue(TOTAL<[Product Type]> Onlinesales/Totalsales,-weekDt)-FirstSortedValue(TOTAL<[Product Type]> Onlinesales/Totalsales,weekDt),'0%')

hope this helps

regards

Marco