Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

panipat1990
Contributor II

TO MAKE ONE COMMON DATE

Dear Team,

i stuck a requirement.i have one table where two date's fields. i want to make them a common date.How is possible.kindly help me for resolving this issue.for this i am sharing data.

In data two field delviery date and doc date. i want to make them one field this is common date(Link Date)

1 Solution

Accepted Solutions

Re: TO MAKE ONE COMMON DATE

Glad you liked it.

Please close your thread if your question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful


thanks


regards


Marco

22 Replies
el_aprendiz111
Valued Contributor

Re: TO MAKE ONE COMMON DATE

Hi

LOAD

Date(Date#(KeepChar([Doc. Date],'0123456789'), 'DDMMYYYY'),'DD/MM/YYYY')AS [Doc. Date],
Date(Date#(KeepChar([Del. Date],'0123456789'), 'DDMMYYYY'),'DD/MM/YYYY')AS [Del. Date],
Purch.Doc.,
Article,
PGr,
Item,
[Net price],
Quantity,
[Net Value],
[GR Qty]
FROM
[..\..\..\..\..\..\..\..\..\Documents\Downloads\Sale.txt]
(
txt, codepage is 1252, embedded labels, delimiter is '\t', msq);


panipat1990
Contributor II

Re: TO MAKE ONE COMMON DATE

Hi

I want to make them these two date's as a common date

vishsaggi
Esteemed Contributor III

Re: TO MAKE ONE COMMON DATE

What you mean by common date here? You have DocDate and DelDate having different dates, you want to make DocDate and DelDate have same dates as DocDate or IF you want to combine two dates as One single column which field date should be displayed? 

el_aprendiz111
Valued Contributor

Re: TO MAKE ONE COMMON DATE

Hi,

LOAD Date(Date#(KeepChar([Doc. Date],'0123456789'), 'DDMMYYYY'),'DD/MM/YYYY')AS [common date],
Purch.Doc.,
Article,
PGr,
Item,
[Net price],
Quantity,
[Net Value],
[GR Qty]
FROM
[..\..\..\..\..\..\..\..\..\Documents\Downloads\Sale.txt]
(
txt, codepage is 1252, embedded labels, delimiter is '\t', msq);



LOAD Date(Date#(KeepChar([Del. Date],'0123456789'), 'DDMMYYYY'),'DD/MM/YYYY')AS [common date],
Purch.Doc.,
Article,
PGr,
Item,
[Net price],
Quantity,
[Net Value],
[GR Qty]
FROM
[..\..\..\..\..\..\..\..\..\Documents\Downloads\Sale.txt]
(
txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

EXIT Script;

panipat1990
Contributor II

Re: TO MAKE ONE COMMON DATE

Actually i done this way but i want to do another way for solving. suppose my qvd size 3gb.if i concatenate above same.then size increase.this is not optimize way .kindly guide me another way for solving

panipat1990
Contributor II

Re: TO MAKE ONE COMMON DATE

I want to make one common field common date

vishsaggi
Esteemed Contributor III

Re: TO MAKE ONE COMMON DATE

What dates needs to be in your CommonDate field?

el_aprendiz111
Valued Contributor

Re: TO MAKE ONE COMMON DATE

Hi,

TMP:
LOAD
Date(Date#(KeepChar([Doc. Date],'0123456789'), 'DDMMYYYY'),'DD/MM/YYYY')AS [common date],
Purch.Doc.,
Article,
PGr,
Item,
[Net price],
Quantity,
[Net Value],
[GR Qty]
FROM
[..\..\..\..\..\..\..\..\..\Documents\Downloads\Sale.txt]
(
txt, codepage is 1252, embedded labels, delimiter is '\t', msq);



LOAD Date(Date#(KeepChar([Del. Date],'0123456789'), 'DDMMYYYY'),'DD/MM/YYYY')AS [common date],
Purch.Doc.,
Article,
PGr,
Item,
[Net price],
Quantity,
[Net Value],
[GR Qty]
FROM
[..\..\..\..\..\..\..\..\..\Documents\Downloads\Sale.txt]
(
txt, codepage is 1252, embedded labels, delimiter is '\t', msq);


NoConcatenate


SALES:
LOAD
[common date],
Purch.Doc.,
Article,
PGr,
Item,      
sum([Net price]) AS [Net price],
SUM(Quantity)    AS Quantity,
SUM([Net Value]) AS [Net Value],
SUM([GR Qty])    AS [GR Qty]
Resident TMP
Group BY
[common date],
Purch.Doc.,
Article,
PGr,
Item
;

DROP Table TMP;
EXIT Script;

panipat1990
Contributor II

Re: TO MAKE ONE COMMON DATE

Dear Sir,

Kindly tell me how to identified this is document date and this del date From Common date.

Community Browser