Date group

shamsu_mk — Fri, 30 Nov 2018 07:42:03 GMT

Hello Expirts

Please find a script and its chart as a picture. The chart is explaining the analysis of posting date and document date in a particular month. An example here is Nov 18. You can see in the picture some October document is appearing Nov because October documents are posted Nov. I want all October numbers as in one date or name like Prior_period in the beginning, then Nov numbers are day by day. Can you please help ?

LOAD FileName,
    DocumentNo as     DocumentNo_AP,
     Type,
     [Doc. Date] as     [Doc. Date_AP],
     [Pstng Date] as     [Pstng Date_AP],
     if(Period > 12,12,Period) as Period,
     [G/L Account] as     [G/L Account_AP],
     CoCd,
     Year,

   FROM
[Y:\Financial Statements\CBOB Closures\CBOB-D\QV Project\Shamsu\FI Dash Board\FBL1N.qvd]
(qvd);
//====================================================================================
FBL1NDoc:
LOAD
     DocumentNo as DocumentNo_AP,
   [Doc. Date] as [Doc. Date_AP]

FROM
[Y:\Financial Statements\CBOB Closures\CBOB-D\QV Project\Shamsu\FI Dash Board\FBL1N.qvd]
(qvd);

FBL1NPost:
LOAD
     DocumentNo as    DocumentNo_AP,
     [Pstng Date] as [Pstng Date_AP]

FROM
[Y:\Financial Statements\CBOB Closures\CBOB-D\QV Project\Shamsu\FI Dash Board\FBL1N.qvd]
(qvd);

DateBridge:

LOAD
      DocumentNo_AP,
      [Doc. Date_AP]as Dategroup2,
     'FBL1NDoc' as DateType2
     Resident FBL1NDoc;

LOAD
      DocumentNo_AP,
     [Pstng Date_AP] as Dategroup2,
     'FBL1NPost' as DateType2
     Resident FBL1NPost;

Re: Date group

shamsu_mk — Fri, 30 Nov 2018 08:31:19 GMT

I think we need to apply some condition in expressions but i did not mention my expressions in my post. So please find below the dimension and the expression for your reference.

Expressions

------------

DocDt =count(Distinct {$<DateType2={'FBL1NDoc'}>} DocumentNo_AP)

PostDt =count(Distinct {$<DateType2={'FBL1NPost'}>} DocumentNo_AP)

Dimension = Dategroup2

------------

topic Re: Date group in QlikView

Date group

Re: Date group