Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
Once we developed our report how do we test the report in qlikview ?
Have a look on below discussion,
Hi,
As of my knowledge there are no automated tools which you can use for testing a qvw file.so, manual testing is the only way.
Coming to testing the charts(expressions):
The tester must be able to do randomly check the values of the charts by posing queries on the database on which we have used to create the data model.
for eg:
Dimension : Region
Measure: sales
check by writing a query like this.
select sum(sales)
from <table>
group by Region.
check the following link
QV Scalability Tools (QV10,QV11)
Thank you.
I can give you some pointers,
For Data Testing.
1. Go to your source Database
2. Write query as per your logic in Qlikview and extract data into Excel
3. Perform calculations in Excel as per your calculations and requirements to suit to the end model in Qlikview.
4. Extract your Qlikview data into Excel as well.
5. Do sheet to sheet comparison in Excel.
For Expression Caculation Testing.
1. Take all your data into plain table charts
2. Export them into excel
3. Write same expressions as in your Qlikview over there in Excel and cross verify.
4. In Excel, You can create pivots as well with the formula columns you have written.