- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi everyone, problem with dates
Hi,
I've a table like that:
I've to count the days that my article "0421j141995" stay in each "Sede".
DEL means Entry and DUL means Exit.
For example this article star from "Sede" 1 for going in "Sede" 6 for staying here for 7 days, then it left "Sede" 6 for going in "Sede" 8 and it stay here for 18 days, etc..
How can I do it in Qlikview or sense?
Thank for everyone can answer.
Best Regards
Miriana
- « Previous Replies
-
- 1
- 2
- Next Replies »
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It works!
But it gives me this result..
Best regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
try replacing
- [Data]:
- Noconcatenate LOAD *,
- If(Codice=Peek(Codice) and Sede=Peek(Sede),Date#(Data-Peek(Data),'D')) as Day_nr
- ;
- LOAD * RESIDENT Data_temp Order By Codice, Recordnr ASC;
with
- [Data]:
- Noconcatenate LOAD *,
- If(Codice=Peek(Codice) and Sede=Peek(Sede),Date#(Data-Peek(Data),'D'),0) as Day_nr
RESIDENT Data_temp Order By Codice, Recordnr ASC;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry but with Noconcatenate it gives me this error:
Si è verificato il seguente errore:
Field not found
L'errore si è verificato qui:
[Data]: Noconcatenate LOAD *, If(Telaio=Peek(Telaio) and Sede=Peek(Sede),Date#([Data documento]-Peek([Data documento]),'D'),0) as Day_nr RESIDENT Data_temp Order By Codice, Recordnr ASC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Miriana,
It's not the Noconcatenate that gives the issue, you're not loading Codice. If you rename that field you should also order by the new fieldname at the end.
RESIDENT Data_temp Order By Codice, Recordnr ASC
RESIDENT Data_temp Order By Telaio, Recordnr ASC
Kind regards,
Jop
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sorry, I didn't see it.
I've replace Codice with Telaio now, but it gives me the same result of the table I've posted friday.
No matter, I'll do it in another way.
Thank you very much for the help.
Kind Regards
Miriana
- « Previous Replies
-
- 1
- 2
- Next Replies »