topic Re: Need Calculation Help - Not Getting Expected Results in QlikView

Need Calculation Help - Not Getting Expected Results

pnn44794 — Sat, 12 Oct 2019 22:13:18 GMT

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.

Re: Need Calculation Help - Not Getting Expected Results

Digvijay_Singh — Fri, 16 Feb 2018 20:02:08 GMT

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

Re: Need Calculation Help - Not Getting Expected Results

pnn44794 — Fri, 16 Feb 2018 20:17:09 GMT

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.

Re: Need Calculation Help - Not Getting Expected Results

Digvijay_Singh — Fri, 16 Feb 2018 20:28:03 GMT

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.

Re: Need Calculation Help - Not Getting Expected Results

pnn44794 — Fri, 16 Feb 2018 20:39:18 GMT

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.

Re: Need Calculation Help - Not Getting Expected Results

pnn44794 — Fri, 16 Feb 2018 21:50:03 GMT

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.

Re: Need Calculation Help - Not Getting Expected Results

pnn44794 — Sat, 12 Oct 2019 22:04:17 GMT

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.

Re: Need Calculation Help - Not Getting Expected Results

Digvijay_Singh — Sat, 17 Feb 2018 23:52:13 GMT

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.

Re: Need Calculation Help - Not Getting Expected Results

pnn44794 — Sun, 18 Feb 2018 00:14:26 GMT

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