Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gargi_bardhan
Creator
Creator

Testing Tool

Hi All,

Can anyone suggest on the below points:

1) Do there is anyway we can automate testing process(Front end object values) ? As now there is a separate testing team doing it manually.

2) Is there any tool for reviewing code(back end) ?

Suggestions please .

Thanks,

Gargi

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

Answer to #1:

Actually the latest version of QV Scalability Tools DO HAVE the support for regression tests that I think you are looking for.

Have a look at this link (pointing to a much newer article than the one that Avinash gave you):

QV Scalability Tools (QV10,QV11)

It even has it's own PDF-manual regarding the regression test feature. It is a 34-page document called "Regression testing.pdf". Just download the file called QVScalabilityTools_0_9 64Bit.zip‌‌which is available also in the article/document mentioned above....

Answer to #2:

There is a tool called Platform Manager that cover both #2 but also a lot within your #1 request.

Just Google "in4bi application lifecycle management"

View solution in original post

8 Replies
avinashelite

Check this :

Tool for easy creation of load/performance tests of QlikView (v.10 and 11)

1. Selenium ( Web page testing Framework)

      : To test the output of documents published to an intranet via a server using the AJAX deployement

     Selenium automates browsers. That's it. What you do with that power is entirely up to you. Primarily it is for automating web applications for testing purposes, but is certainly not limited to just that. Boring web-based administration tasks can (and should!) also be automated as well.


2. Watin (Web page testing Framework)

      : To test the output of documents published to an intranet via a server using the AJAX deployement

     Testing possible for the .Net languages. WatiN is developed in C# and aims to bring you an easy way to automate your tests with Internet Explorer and FireFox using .Net.


3. Adobe PDF Comparison Tool (Acrobat X Pro, Acrobat X Suite)

      : Compare and highlight the differences between two versions of a PDF document

      : Bookmarks each scenerio of QV and compare each version of development


4. Autoit

      : Automation Tool to control Application

     AutoIt v3 is a freeware BASIC-like scripting language designed for automating the Windows GUI and general scripting. It uses a combination of simulated keystrokes, mouse movement and window/control manipulation in order to automate tasks in a way not possible or reliable with other languages (e.g. VBScript and SendKeys). AutoIt is also very small, self-contained and will run on all versions of Windows out-of-the-box with no annoying “runtimes” required!


5. QlikView Macros

      : Use Macros for test automation

      : Can test only the values generated in the UI.

(Ref:http://community.qlik.com/thread/8625; http://community.qlik.com/message/41125#41125; )

tresesco
MVP
MVP

Unfortunately there is no such tool. For Value /data validation, you have to take a standard SQL testing or such based on your data source and data type. However, there are applications that can be used to test the stress/performance testing which you can take as a script-optimization test perhaps. Such as : QV Scalability Tools (QV10,QV11). Refer another discussion here: Re: Testing in qlikview as well.

gargi_bardhan
Creator
Creator
Author

Thanks Avinash for the the instant suggestions,looks good as of now will look into each in detail and get back to you if any challenges  .

Regards,

Gargi

gargi_bardhan
Creator
Creator
Author

Thanks Tresesco for your time and suggestion , will try out hope it works.

Do you have any idea on tool named 'Quality-Gates' ? will it be appropriate to my requirement ?

http://market.qlik.com/quality-gates-for-qlikview.html

Regards,

Gargi

tresesco
MVP
MVP

Hi Gargi,

               No idea..  But it seems to have some good features (as they describe it). It's an extension, and not sure if this could really be able to validate data as per your expectation where your model would have multiple layers of transformation. Apart from this data validation part, I guess available qv apps are good to be tried, and for that I would not probably look to spend extra. 

petter
Partner - Champion III
Partner - Champion III

Answer to #1:

Actually the latest version of QV Scalability Tools DO HAVE the support for regression tests that I think you are looking for.

Have a look at this link (pointing to a much newer article than the one that Avinash gave you):

QV Scalability Tools (QV10,QV11)

It even has it's own PDF-manual regarding the regression test feature. It is a 34-page document called "Regression testing.pdf". Just download the file called QVScalabilityTools_0_9 64Bit.zip‌‌which is available also in the article/document mentioned above....

Answer to #2:

There is a tool called Platform Manager that cover both #2 but also a lot within your #1 request.

Just Google "in4bi application lifecycle management"

gargi_bardhan
Creator
Creator
Author

Thanks Peter for the reply and your time.

I have tested using  QVScalabilityTools - regression testing but in some cases its failing to detect difference in values of charts, and some case it is working .

Test scenario -

The dashboard has two objects: Bar chart and a Straight table.


In first case executed the regression script generator with total value as 10,042 in Bar chart and Straight table


In second case executed the regression script generator with the change in sum value for Bar chart only as 10,082 (changed from 10,042 to 10,082 ) and no change in values in Straight table .


So after comparing the output XML files for both got the below result -


Here we can see it is able to tell the difference in sum value in bar chart ,but the issue is sometimes it is doesn't work (though not able to figure out the reason )

TESTCASE02.jpg

Image two is the result in Qlikview Regression Analyser .

QVRegressionAnalyser02.jpg

As suggested will check the Platform Manager tool and get back to you .

Again thanks for your suggestion .

Regards,

Gargi

Anonymous
Not applicable

after spending 1 day with it you realise that is not really working