Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
nihhalmca
Valued Contributor II

unit testing

Hi Experts,

Database having field empno,quantity,price.

my application having fields empno,qvantity, revenue.

while unit testing how can i do both.

Thanks in advance

Nihhal.

1 Solution

Accepted Solutions
nihhalmca
Valued Contributor II

Re: unit testing

Hi All,

Finally i understood myself by real scenario. Thanks for your support.

Regards,

Nihhal.

6 Replies
Not applicable

Re: unit testing

and the question is...?

nihhalmca
Valued Contributor II

Re: unit testing

Database having fields empno, Qty, basic price.

application having fields empno, qty, Revenue.

my question is how can i do unit testing (having diff field revenue)

chauhans85
Esteemed Contributor

Re: unit testing

on the basis of price and quantity you can calculate revenue

use below

Revenue =Total sales - Cost of goods sold

or

revenue=total quntity* unit price - soldquntity*unit price

hope this helps

nihhalmca
Valued Contributor II

Re: unit testing

I finally got that if we have multi data sources for application

for example some tables from sql server and some tables for oracle,

we can do testing separately only (sql server table in sql server and oracle tables in oracle)

nihhalmca
Valued Contributor II

Re: unit testing

Hi Sunil, sorry for the reply

My intension is not formula for revenue for example some fields(tables) coming form sql server and some fields(tables) coming from oracle how can we do testing.

thanks & Regards,

Nihhal

nihhalmca
Valued Contributor II

Re: unit testing

Hi All,

Finally i understood myself by real scenario. Thanks for your support.

Regards,

Nihhal.

Community Browser