topic Unit price difference between orderdetails and Product table in QlikView

Unit price difference between orderdetails and Product table

raju_salmon — Mon, 10 Aug 2015 06:29:39 GMT

Dear Team,

I am new to database and understanding it, though it is very basic question can anyone please let me know the dirrerence between unit price in order_details table and Product table.

I have productID and UnitPrice in both tables so synthetic key is forming. If i rename it, which unit price i need to consider for sales calculation.

Thank you.

Regards,

Raju

Re: Unit price difference between orderdetails and Product table

sunny_talwar — Mon, 10 Aug 2015 06:40:13 GMT

Does each ProductID has a unique and equivalent UnitPrice in both the tables? If it is always unique and remains same, then it doesn't matter which one you use.

Re: Unit price difference between orderdetails and Product table

MayilVahanan — Mon, 10 Aug 2015 06:44:13 GMT

As per my understanding, Price from product table should be refer in "Order" table for calculation.

Re: Unit price difference between orderdetails and Product table

raju_salmon — Mon, 10 Aug 2015 06:44:49 GMT

No Sunny, It is not unique. Can you please refer the attachment.

Re: Unit price difference between orderdetails and Product table

MayilVahanan — Mon, 10 Aug 2015 06:51:40 GMT

For Sales calculation, You can refer the "Unit Price" in Order Details.

Re: Unit price difference between orderdetails and Product table

raju_salmon — Mon, 10 Aug 2015 06:54:25 GMT

Thanks for your reply. May i know what is the difference between both? The unit price in order table is lower/higher than unit price in product table.

Re: Unit price difference between orderdetails and Product table

MayilVahanan — Mon, 10 Aug 2015 07:05:23 GMT

Hi Raju,

I think,

Product Table: Original price of the product is available.

Order Table: Contains the price of the product is sold. It may be contains some discount, adjustment, co-pay or tax.

Based on the order table, we can able to find the sales of the product / company.

Re: Unit price difference between orderdetails and Product table

qlikviewwizard — Tue, 11 Aug 2015 02:15:57 GMT

Hi Raju Salmon, Please close the thread by selecting Correct Answer. Thank you.

Re: Unit price difference between orderdetails and Product table

raju_salmon — Tue, 11 Aug 2015 03:40:16 GMT

Hi,

Can you please provide me correct answer. I have received only helpful answer.

Regards,

Raju

Re: Unit price difference between orderdetails and Product table

qlikviewwizard — Tue, 11 Aug 2015 05:13:00 GMT

Hi Raju, Please attach the sample data to demonstrate your issue. It will help us in better understand.Thank you.

Re: Unit price difference between orderdetails and Product table

raju_salmon — Tue, 11 Aug 2015 05:25:47 GMT

Hi,

Can you please see the sampled data snap in above messages.

And may i know how to create boarder for text box/list box with different color?

Thanks.

Raju

Re: Unit price difference between orderdetails and Product table

qlikviewwizard — Tue, 11 Aug 2015 05:30:56 GMT

Hi Raju Salmon,

It is difficult to prepare sample data. Please attach the sample data with qvw.

Re: Unit price difference between orderdetails and Product table

raju_salmon — Tue, 11 Aug 2015 05:37:07 GMT

Hi,

I cannot able to send sample QVW, anyway i will close this thread.

May i know how to create boarder for text box/list box with different color (boarder color should be green example)?

Re: Unit price difference between orderdetails and Product table

qlikviewwizard — Tue, 11 Aug 2015 05:47:31 GMT

Please start the new thread as this is new query. Thank you.