Weekly due date in table

[#1]

Hi Master QS,

I have problem to make a report in table format like this :

The data i have is in column A-D

Can i make Due Date then W1 - Wn in Qlik Sense? !

[brunobertels]

Hi

Does something like this respond to your requierment ?

[#3]

Hai Bruno,

Thanks for ur respons,

Can 1 get summary above in table not pivot table  because i still export it to Excell, pivot table can't export to Excell file.

Note : Amount / week get from due date.

[brunobertels]

Hi

Like that ?

:

see attached app last sheet

[#5]

Thanks allot bruno bertels,

it helpfull, so i still must add expression manual to make W1,W2 - Wn ? can i make automaticly?

[brunobertels]

Hi

Not sure to understand what you mean by " make automaticly".

First way consisted in adding mesure sum(amount) with an If statement and named each mesure as W1, W2 etc

second approach with calculated dimension :

add this to your script :

LOAD

    Name,

    AMOUNT,

    "Invoice Date",

    "Lead Time (Days)",

    if(

week([Invoice Date]+[Lead Time (Days)])=2,AMOUNT,0) as "W2",

    if(

week([Invoice Date]+[Lead Time (Days)])=3,AMOUNT,0) as "W3",

    if(

week([Invoice Date]+[Lead Time (Days)])=4,AMOUNT,0) as "W4",

    if(

week([Invoice Date]+[Lead Time (Days)])=5,AMOUNT,0) as "W5",

    if(

week([Invoice Date]+[Lead Time (Days)])=6,AMOUNT,0) as "W6",

    if(

week([Invoice Date]+[Lead Time (Days)])=7,AMOUNT,0) as "W7",

    if(

week([Invoice Date]+[Lead Time (Days)])>=8,AMOUNT,0) as "W>=8"

from ....

this time it will add several dimension W1, W2 etc

just drag and drop those dimensions in your table.

You may have this :

note that by this way Totals line not available

bruno