topic Re: How to create a report with end users inputs? in QlikView

How to create a report with end users inputs?

SuperOracle — Mon, 27 Feb 2023 16:28:18 GMT

We want to duplicate a crystal report into Qlik Dashboard. This report requires end users' inputs like the start date and end date. Then the output data will be calculated (using formula) based on the date range.

How could I create such report in Qlik?

Can anyone please share any idea?

Thank you!

Re: How to create a report with end users inputs?

Ray_Strother — Mon, 27 Feb 2023 17:52:27 GMT

Hello ,

Perhaps using Direct Queries, Formulas and filters.
1. Direct Query

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptRegularStatements/direct-query.htm#:~:text=The%20DIRECT%20QUERY%20statement%20allows,Direct%20access%20with%20Direct%20Query.

Re: How to create a report with end users inputs?

marcus_sommer — Tue, 28 Feb 2023 14:45:00 GMT

This could be done with variables or selections - indirectly per extra date-fields in loosen tables or also with direct selections. In many cases it's not too difficult just to select the wanted dates because the user could just type: >=startdate<=enddate on the date-field - means the user-input is just extended to two operators.

Beside this the most users choose only a few relevant periods like YTD, MTD and similar ones which could be provided as selection-values, too.

Re: How to create a report with end users inputs?

SuperOracle — Tue, 28 Feb 2023 15:27:21 GMT

Hi @marcus_sommer ,

Thank you for the response. I am new to QLIK. Is there any document or similar example that I could follow?

Thanks!

Re: How to create a report with end users inputs?

marcus_sommer — Tue, 28 Feb 2023 15:33:39 GMT

Quite helpful for all date-stuff is: How to use - Master-Calendar and Date-Values - Qlik Community - 1495741 and why it's good to select the wanted views: Let the User Select - Qlik Community - 1463978

Re: How to create a report with end users inputs?

SuperOracle — Tue, 28 Feb 2023 20:39:30 GMT

Thank you so much @marcus_sommer ! Will check out.