QlikSense Script equivalent to BO script.

[latheesh]

Hi Experts,

Not much expertise in qliksense. Hence, please help me on this.

I have requirement to migrate from Business Object to Qliksense. In BO, there are multiple query providers, its like 2 different queries in report level also both of them are having sub query as well. 

Example : 

Query1 : Payment information (more than 10 tables with inner join) including sub query)

Query 2 : Estimation information (more than 10 tables with inner join) including sub query)

Would need to know, how these two queries can be accommodated in qliksense.  

Thanks

[vinieme12]

you can use SQL queries in Qliksense too!

https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegu...

[latheesh]

Hi, thanks for the input.

I may need to load the data into qvd. If I am not wrong, the sql script will not help to write into qvd. So, looking for a solution to 'load' the data.

[vinieme12 · Accepted solution]

This is basically how you store qvds 

TableA:

SQL yourQuery1;

Store TableaA into 'somepath/somefolder/TableA.qvd'(qvd);

[latheesh]

It works. Thanks for the simplified input.