topic Re: Testing in qlikview in QlikView

Testing in qlikview

Anonymous — Tue, 06 Jan 2015 09:06:15 GMT

Hi all ,

Once we developed our report how do we test the report in qlikview ?

Re: Testing in qlikview

Anonymous — Tue, 06 Jan 2015 09:11:19 GMT

Have a look on below discussion,

how to do testing on qlikview using jmeter

Testing in qlikview

system and user acceptance testing of QlikView

Re: Testing in qlikview

kkkumar82 — Tue, 06 Jan 2015 09:14:46 GMT

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.

Re: Testing in qlikview

Tue, 06 Jan 2015 09:56:14 GMT

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.