Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Can you define exactly your needed here?
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.
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