Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
shamsu_mk
Creator
Creator

Date group

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;

Test.JPG

1 Reply
shamsu_mk
Creator
Creator
Author

Hi

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

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