Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
latheesh
Contributor II
Contributor II

QlikSense Script equivalent to BO script.

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

 

 

Labels (2)
1 Solution

Accepted Solutions
vinieme12
Champion III
Champion III

This is basically how you store qvds 

 

TableA:

SQL yourQuery1;

 

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

 

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
vinieme12
Champion III
Champion III

you can use SQL queries in Qliksense too!

 

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
latheesh
Contributor II
Contributor II
Author

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
Champion III
Champion III

This is basically how you store qvds 

 

TableA:

SQL yourQuery1;

 

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

 

 

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
latheesh
Contributor II
Contributor II
Author

It works. Thanks for the simplified input.