Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Frozen2
Contributor
Contributor
‎2021-11-25 10:29 AM

QlikView Report

Hi,

I have been given a project to transfer all the reports(graphs) from QlikView to Power BI. I couldn't find any way so decided to make all the graphs by myself in Power BI and now the problem is I am not able to figure out which table or the column has been used to generate that graph. There is a query performed to generate that graph but it seems very difficult to understand.

Hope anyone can help me with that.

Thank you in advance

Regards,

Frozen2

Labels (1)
Labels
975 Views
0 Likes
5 Replies
Or
MVP
MVP
‎2021-11-25 11:00 AM

There is no easy / automatic way to do this. You'll have to go over each object, look at each of its dimensions and measures, and then isolate those in the script to find out where each of them is from and what script logic might have been applied to them after they were loaded from the original data source. Qlik's engine and Power BI's engine simply don't speak the same language...

966 Views
0 Likes
Frozen2
Contributor
Contributor
‎2021-11-25 11:08 AM
Author

Okay, Thank you for your advice. Also, I am not really familiar with QlikView. Is there any way to learn and understand QlikView more in-depth or any group to join for help?

957 Views
0 Likes
Or
MVP
MVP
‎2021-11-25 11:13 AM

There should be plenty of tutorials and such online (a cursory Google search turned up a bunch), and QlikCommunity right here can answer specific questions (within reason). Depending on how complex the QlikView application is, you might be able to easily pick it up or it could be very difficult, as QlikView is an entire ETL engine in additional to being a front-end BI tool. If the QlikView application is highly complex, I would advise against trying to learn QlikView in-depth just to convert it to another platform, but that's up to you. Sometimes it's easier to just start from scratch and re-design the application than it is to reverse engineer the existing one.

946 Views
0 Likes
Frozen2
Contributor
Contributor
‎2021-11-25 11:18 AM
Author

OK, Thank you for your advice & help. It really means a lot. 

926 Views
0 Likes
Scott9733
Contributor
Contributor
‎2022-03-03 03:59 AM

@Frozen2 wrote:

Hi,

I have been given a project to transfer all the reports(graphs) from QlikView to Power BI. I couldn't find any way so decided to make all the graphs by myself in Power BI and now the problem is I am not able to figure out which table or the column has been used to generate that graph. There is a query performed to generate that graph but it seems very difficult to understand. Target Gift Card Balance

Hope anyone can help me with that.

Thank you in advance

Regards,

Frozen2

There is no easy / automatic way to do this. You'll have to go over each object, look at each of its dimensions and measures, and then isolate those in the script to find out where each of them.

745 Views
0 Likes