Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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? !
Hi
Does something like this respond to your requierment ?
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.
Hi
Like that ?
:
see attached app last sheet
Thanks allot bruno bertels,
it helpfull, so i still must add expression manual to make W1,W2 - Wn ? can i make automaticly?
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