How to check the Calculation part?

[qv_testing]

Hi Community,

Suppose i have Category field in my Database.

each category have some records. when i am click the category it displays some records.

suppose i am filtering by Year, Quarter and Month wise if i am click any dimension it shows some result

sum(OrdersalesAmount)

how to calculate correct or not...

Thanks....

[#2]

You want to check the calculation against what?

If you want to check whether the result displayed in qlikview is correct or not, you can do a validation by pulling the same result (i.e. for same year, quarter & month) from database (by querying) or from whatever source you are using.

Hope this helps!

[dmohanty]

Hi,

Whatever fields you are selecting in the App and calculating the Fact, take those fields from your data base, prepare a SQL query and execute in your tool.

Otherwise use Table Box in ur app too, just to test manually.

[qv_testing]

Please give me any Example

[qv_testing]

Please give me any example

[dmohanty]

Suppose all the fields are in a single table, then the Query would be simple:

SELECT Year/MOnth/Quarter,

sum(orderAMount)

from Schema.Tablename

where Year/MOnth/Quarter = 'your selected value'

group by <all the fields, except aggregated field>

If both fields are in different tables:

SELECT A.Year/A.Month/A.Quarter,

sum(B.OrderAmount)

INner join Table1 as A,

Table2 as B

on A.commonfield = B.commonfield

where A.Year/A.Month/A.Quarter = 'your selected value'

group by <all the fields, except aggregated field>

Regards!!!

[#7]

Hi,

Assuming that you are using sql server as a source, your query will look something like:

For Eg:

Year = 2013, Quarter: 2, Month =1

Select Sum(OrdersalesAmount)

From Tablename (Database table name)

Where Year = '2013'

And Quarter = '2'

And Month = '1'

Or if the source is an excel then you can validate by directly filtering the values for mentioned selection and checking the sum.
Another way to check the calculation is create a Text object in qlikview and give the calculation (in this case, Sum(OrdersalesAmount)) in it's text part.

Hope this helps!