topic Re: How to check the Calculation part? in QlikView

How to check the Calculation part?

Nagaraju_KCS — Mon, 16 Sep 2013 05:45:31 GMT

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....

Re: How to check the Calculation part?

Mon, 16 Sep 2013 06:31:18 GMT

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!

Re: How to check the Calculation part?

dmohanty — Mon, 16 Sep 2013 06:41:25 GMT

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.

Re: How to check the Calculation part?

Nagaraju_KCS — Mon, 16 Sep 2013 07:33:46 GMT

Please give me any Example

Re: How to check the Calculation part?

Nagaraju_KCS — Mon, 16 Sep 2013 07:34:13 GMT

Please give me any example

Re: How to check the Calculation part?

dmohanty — Mon, 16 Sep 2013 07:40:08 GMT

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!!!

Re: How to check the Calculation part?

Mon, 16 Sep 2013 07:44:46 GMT

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!