qvd issue ? urgent

[#1]

Hi All,

I have a qvd  data with no.of customer codes..

for testing purpose I have taken randomly 3 customer codes in Excel , I have worked on that..

So Balance amount & Overdue amounts are coming fine with that 3 customer codes ...

When I am using QVD by replacing that Excel, I am getting Overdue amount Entire column is Zero...

Help me on this ..

Regards,

Helen

[anbu1984]

Can you post the script

[maxgro]

and qvd and xls?

[#4]

FT_OS:

LOAD 

  OST_MAIN_ACNT_CODE as MS_MAIN_ACNT_CODE,

  OST_SUB_ACNT_CODE as CUST_CODE1,

  OST_SUB_ACNT_CODE,

  OST_DOC_NO,

    OST_DRCR_FLAG,

if(isnull(OST_FC_ADJ_AMT),0,OST_FC_ADJ_AMT) as OST_FC_ADJ_AMT,

if(isnull(OST_FC_ORG_AMT),0,OST_FC_ORG_AMT) as OST_FC_ORG_AMT,

// Sum(OST_FC_ORG_AMT-OST_FC_ADJ_AMT) as DebtorsOutStandingAmount,

// if(OST_DUE_DT<Today(),sum(OST_FC_ORG_AMT-OST_FC_ADJ_AMT)) as DebtorsOverdueAmount,

  OST_DOC_DT,

  date#(date(OST_DUE_DT,'MM/DD/YYYY')) as OST_DUE_DT,

//  date(OST_DUE_DT)as OST_DUE_DT ,

  if(isnull(OST_FC_ADJ_AMT),0,OST_FC_ADJ_AMT)-OST_FC_ORG_AMT as diff_val

//from

//D:\DSO.csv

//(txt, utf8, embedded labels, delimiter is ',', msq);

Resident Gen where wildmatch(OST_SUB_ACNT_CODE,'100793','101242','102115');

Because of Date format for OST_DUE_DT & Today

Regards,

Helen

[Anonymous]

Helen,

Maybe QV is not recognizing your number format. So try like this adapting your input and output number format:

load customer

        num(num#(amountfield, '0.#0'), '0,##') as amountfield

from yoursource;

Marc.

[#6]

Initially your QVD did not had the customer codes, did you recreated the QVD with new codes?

[#7]

In my QVD i am having Customer codes, For testing purpose I have take few customers...

=(Sum({<OST_DUE_DT={"<$(=today())"},OST_DRCR_FLAG={'C'}>}OST_FC_ADJ_AMT)-sum({<OST_DUE_DT={"<$(=today())"},OST_DRCR_FLAG={'C'}>}OST_FC_ORG_AMT))+

(Sum({<OST_DUE_DT={"<$(=today())"},OST_DRCR_FLAG={'D'}>}OST_FC_ORG_AMT)-sum({<OST_DUE_DT={"<$(=today())"},OST_DRCR_FLAG={'D'}>}OST_FC_ADJ_AMT))

Because of OST_DUE_DT date format this problem is coming...

[robert99]

Hi Betty

Have you read this blog post

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/19/why-don-t-my-dates-work

point 1 especially

Although Im unsure why it would be the right date format loaded from Excel but not a qvd.

[#9]

My OST_DUE_DT is in format: 1/4/2010 12:00:00 AM

Today Date: 10/20/2014

I need compare this OST_DUE_DT with Today in Set Anaysis, SO that how can i convert my OST_DUE_DT in script....

[jonathandienst]

Hi

I think this:

{<OST_DUE_DT={"<$(=Date(today(), 'D/M/YYYY hh:mm:ss t'))"}

HTH

Jonathan