Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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!
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.
Please give me any Example
Please give me any example
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!!!
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!