Gather User Input and Apply in where condition

[Tamizh325]

Hi,

How can I gather user input using varibales and input boxes and then apply the input in a where condition so that the query executes dynamically across different sheets.( I am using Sql query in data load editor with Google Big query)
How can I acheive this? 

[henrikalmen]

You should look for third party extensions that support "writeback". What you want is not natively available in Qlik Sense.

[Or]

This can be partially achieved using ODAG / Dynamic Views, but otherwise it is not how Qlik natively works, as @henrikalmen posted.

[henrikalmen]

Reading your question again, perhaps Direct Query is what you need?

[Tamizh325]

Thanks for your response.
Yes, I am using the direct sql query in Data Load Editor.

[henrikalmen]

Ok, then I'm not sure what your question is. Have you read this? https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DirectQuery/create-data-...

[Tamizh325]

Thanks for your response.

We are initially migrating from SAP Business Objects (BO) to Qlik Sense. How can we copy all the respective queries from BO (Teradata) to Qlik Sense (BigQuery)? Also, in SAP BO, user prompts are required before executing reports. We want to implement the same process in Qlik Sense, where users must provide inputs before report execution.

Currently, in the qliksense in Data Load Editor, I paste the SQL query, and in the sheet, I design the visualization using a table. However, I need a solution where the report executes based on user prompts before loading the data.

How can we achieve this in Qlik Sense?"

[henrikalmen]

So what you are saying is that you want the user to be able to do more than one selection in the app, before the direct query is executed? But normally the query is exceuted immediately when one selection is made?

I haven't actually worked with direct queries, but I'm thinking you could populate island tables with user selectable values that correspond to the actual values. And you create a button object that when pushed performs all of those selections at once (in the actual fields), which should then trigger execution of the direct query. Something like that might work.

You could possibly use variables as well. Don't create the variables in load script, create them in the variable editor in frontend. It's not impossible (although it is kind of unlikely) that assigned values could interact with the direct query definition somehow.

Like @Or said, perhaps a combination with ODAG could solve your problem. But it depends on your actual needs.

[Or]

If you're trying to migrate from BO (WEBI, presumably?) to QS, you do not want to try and just re-use everything. These are two completely different platforms with completely different ways of dealing with data. Based on my first hand experience with these two platforms, you will want to redesign for Qlik so you can make the most of your platform. If you don't, you'll end up with a poor man's BO that doesn't work very well.