Need Calculation Help - Not Getting Expected Results

[pnn44794]

Hello:

I have a straight table where part of it comes from an inline load (see below) and the rest of it are expressions. One of the three expressions is not getting the correct results.

[Digvijay_Singh]

Not sure but if I use sample data, it returns 1823 which you are expecting, see the attached one.

[pnn44794]

Hello Digvijay:

Thanks for the reply.  I'm not able to open the .qvf file.  Please note, I've never used a .qvf file.  I tried to open it with the Qlikview v12 desktop client.

[Digvijay_Singh]

Oh, Sorry, here is the qvw file. I did few changes just to move forward in other measures as few fields were not there in sample.

[pnn44794]

No problem and my apologies for forgetting to include the PRIME columns.

Yeah, I can see it's working for you.  I have a feeling there's a problem with the way I'm loading the data.  There's several other tables that also get loaded.  ORDER_ID is a key field.  I'm going to try loading the data via a spreadsheet.

[pnn44794]

I'm still not sure what the problem is, but it's looking like it might be my data model.  I need to dig some more.  Hopefully, you're hear back from me this weekend.

[pnn44794]

Hello Digvijay:

I have not been able to determine the issue.  I appreciate you taking the time to respond.  The other chat has additional info like a qvw file that may help and which may have helped you to begin with.  My apologies for not having posted it originally.  My initial thought was that I simply had some type of error in the expression that I simply was not seeing.

In the meantime, I will mark your answer as the correct answer so you get credit.  I hope that's okay???  Again, thank you for your time.

[Digvijay_Singh · Accepted solution]

Its fine , I won't be able to see qvw file as I don't have license. But I saw swuehl has provided you the needed guidance so hope you will be able to move forward.

[pnn44794]

Thanks for understanding.  I should have supplied the needed qvw file.  As always, I appreciate the help.