Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
qv_testing
Specialist II
Specialist II

How to check the Calculation part?

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

6 Replies
Not applicable

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
Partner - Specialist
Partner - Specialist

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
Specialist II
Specialist II
Author

Please give me any Example

qv_testing
Specialist II
Specialist II
Author

Please give me any example

dmohanty
Partner - Specialist
Partner - Specialist


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

Not applicable

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!