topic Re: Scripting challenge in QlikView

Scripting challenge

gorterzelf7 — Sat, 16 Nov 2024 02:17:52 GMT

Hello all,

I have a challenge. I hope there are some clever people here who can help me.

I have for my products a sell date. There are 5 different fases before we can sell the products. The fase lengths are different for each product.

I would like to calculate my amounts for each fase per product per year/week. So i know which amount in which weeks i got.

I have tried to make a simulations of the data in excel and an excel with the outcome in QlikView or QlikSense. If somebody would like to try to get the outcome in QlikView or QlikSense and post the app or qvw here, you would be my hero of the day:-)

With kind regards,

Martijn

Re: Scripting challenge

Vegar — Sun, 06 Oct 2019 21:35:59 GMT

I used the following script to create this table:

LOAD * inline [ Sell date, Product, Amount ]; for each _letter in 'A','B','C','D', 'E' Concatenate LOAD [Sell date], Product, [Fase startdate $(_letter)] as [Fase startdate] , [Year $(_letter)] as [Year], [Week $(_letter)] as [Week], '$(_letter)' as Fase, Amount as [Fase $(_letter)] FROM [$(vL.ImportPath)\Gorterzelf7.xlsx] (ooxml, embedded labels, table is Blad1); next _letter

Re: Scripting challenge

gorterzelf7 — Mon, 07 Oct 2019 07:45:46 GMT

Thank you so much Vegar this should do the trick:-)