Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Best use for Qlikview

HI All,

I have few questions

Currently we are following the below method to load data into Qvw. Please help us if there is any other better way or this is fine.

1. Data is Loaded into Qvw say Data_extractor.qvw.

2 Data model is created in Data_model.qvw

3. Loading data model from Data_model.qvw into the main dashboard using Binary Qvw load.

Let me know if you need any clarifications

Thanks,

Keerthi KS

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

HI,

AS far as I know this is the best approach, there will more reusability if we use this approach.

Regards,

Jagan.

Highlighted
Not applicable

Thanks Jagan.

There are some performance issues. Can u help me with improving the performance like what need to be checked and any other methods to improve performance

Reagrds,

Keerthi KS

Highlighted
Partner
Partner

Hi,

What are the performance issues you're facing or have?

Kindly list them or explain

Highlighted
Not applicable

Dashboard data load is slow currently. No other issues as of now. We will be adding another few dashboards so that again performance should not be affected.

Highlighted
Partner
Partner

Hi,

This kind of performance issue is mostly related to Data Model and UI expressions. You kind of need to review your expressions in UI and refactor your script. Some of the calculation in UI can be move to script and flag. Then use the flags in calculation in UI.

That's the best I can suggest

Highlighted
MVP
MVP

Performance doesn't depend alone on the architecture. Usually the three-tier approach mostly used. But that might not always be required. And that depends on degree of transformation you have to do in the while fetching the data from source. Apart from this, there are many aspects you might have to look while scripting. Read : Best Practices for Data Modelling

Rest lies on experience and the actual scenario you are handling.