Test cases

[vinod2086]

Hi Team,

How to prepare Unit Test cases in Qlik Sense report.

pls help

[Lech_Miszkiewicz]

can you elaborate bit more what you are trying to do or want to know? I find your question very wage

thanks Lech

[vinod2086]

Hi Lech,

I have a dashboard and my lead asking me to prepare unit test cases so am bit confused how to prepare it

[devarasu07]

Hi Vinod,

It's applied to all software (SDLC cycle) release management and roll-outs, not just only in qlik sense.

After you done with SIT/DEV app and its respective data are moved to UAT environment, where user Acceptance Testing will be done. so you can share the app/UAT URL with your users/client for the testing. if they found any data discrepancy/export/GUI issue ask them to raise it via JIRA kind system and let technical team will fix & test that again. after that you can inform to users end to do the re-test again with the Fix. Finally after every testing is passed the app is moved to Production.

Note:  also you can prepare a User Manual Document: It Will explain the step by step walk through for user

(i.e: how to open the report, how to create Storytelling, bookmark, how to export, how to filter the data etc) for your app.

also check this,

http://www.bardess.com/what-is-involved-in-the-qlikview-development-process/

https://en.wikipedia.org/wiki/Software_testing

https://community.qlik.com/message/232227#232227

Hope this helps to you

Regards,

Deva

[Lech_Miszkiewicz]

With Qlik Sense setup (if you have 1 server and do not have test server) you may want to just create UAT stream and give an access to UAT user to it.

The other steps are just like Devarasu said.

[devarasu07]

Hi,

Unit test case, simply create one excel with list of dashboard with object  and try to do below steps,

1) You should familiarize with business rule definition which applied in the report/model & should have knowledge in your system data / reference data set

2) keep one excel sheet with object mapped with report column field  and indicate the status as "Pass/fail" (set limit 100 %)

3) Calculate expected results and compare with your Qlik results, also you can keep screen shot/ recon of the output files

4) if you have access matrix (object / data level security) and 1st test it out with various roles and object level access

5) test it out exported pdf, excel results with qlik results (make sure number format, layout etc)

also check attached sample doc.