topic Re: Values not matched with user report in QlikView

Values not matched with user report

prma7799 — Tue, 19 Dec 2017 05:59:52 GMT

Hi loveisfail‌ / All

I am not able to achieve exact value using formula ...

PFA with Expected output.

Re: Values not matched with user report

Anil_Babu_Samineni — Tue, 19 Dec 2017 06:12:17 GMT

I don't have access QVW, But as my assumption. Perhaps this?

Sum([Sales Qty]*[RATE LCY])-Sum([LINE DISCOUNT])

Re: Values not matched with user report

prma7799 — Tue, 19 Dec 2017 06:15:37 GMT

I have used this but not get proper output

Re: Values not matched with user report

Anil_Babu_Samineni — Tue, 19 Dec 2017 06:17:22 GMT

can you show image in straight table using

Sales Qty and Rate LCY and Line discount using dimension and expression the same

Re: Values not matched with user report

prma7799 — Tue, 19 Dec 2017 06:32:01 GMT

Like this??

Re: Values not matched with user report

Anil_Babu_Samineni — Tue, 19 Dec 2017 06:33:54 GMT

Sure, When i ask please show something related dim's and measure. I will expect something data points from dimensions two. So, then we came to know what Qlik doing here ??

Re: Values not matched with user report

prma7799 — Tue, 19 Dec 2017 06:56:31 GMT

PFA

Re: Values not matched with user report

its_anandrjs — Tue, 19 Dec 2017 06:58:59 GMT

Try to remove all dimension and check to individually what result you get by this expression, you can check this on any text object.

Re: Values not matched with user report

stabben23 — Tue, 19 Dec 2017 07:14:04 GMT

could this be Your problem, INR doesent have any SInvoice.Rate LCY?

Re: Values not matched with user report

Anil_Babu_Samineni — Tue, 19 Dec 2017 07:15:48 GMT

Could be reason, It is allocate automatic group. To get rid can you use One more dimension called RowNo() as Id and then call Id to the dimension. Because, Some values or currency may doesn't have all value points. If none of them not useful

I will look application once reach the home ..

Re: Values not matched with user report

prma7799 — Tue, 19 Dec 2017 10:23:06 GMT

For this I have tried below expression but not getting expected output.

=if([SInvoice.Currency Code2]='INR',sum([SInvoice.Net Amount (Line Amount (Less) Structure Deductions)])

,sum(SInvoice.Quantity *[SInvoice.RATE LCY]) - sum([SInvoice.Line Discount Amount]))

Re: Values not matched with user report

avinashelite — Tue, 19 Dec 2017 11:09:21 GMT

How your trying to compare the values ...when I select single DOC ids it matching perfectly ...if I am missing anything please let me know

Re: Values not matched with user report

prma7799 — Tue, 19 Dec 2017 12:03:18 GMT

Some docs are matching but if you take this chart in excel you will see some docs are not matching

EXP/617/17-18

EXP/645/17-18

etc...

Re: Values not matched with user report

avinashelite — Tue, 19 Dec 2017 13:16:23 GMT

I verified the data between your QV and Excel both have different data ...take a look on the below image and compare with the values in the excel you will get the issue ....formula is working fine as per the data ..check your data in the list box and excel the counts are not matching for one value

Re: Values not matched with user report

prma7799 — Wed, 20 Dec 2017 06:54:08 GMT

Hi Avinash,

For Doc No 'EXP/617/17-18' value in Excel 1863366.3 and 1923996.3 in Qlikview .

My requirement is for document it should display 1863366.3 .

Thanks for your reply .

Re: Values not matched with user report

avinashelite — Wed, 20 Dec 2017 12:58:55 GMT

have you loaded the same excel file to QV??? because if you see the raw values in the QV list box and excel the values are not matching ...I am asking you to check the same

Re: Values not matched with user report

prma7799 — Thu, 21 Dec 2017 06:45:53 GMT

I have check but still not getting expected output...