Best use for Qlikview

[#1]

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

[jagan]

HI,

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

Regards,

Jagan.

[#3]

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

[Gabriel]

Hi,

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

Kindly list them or explain

[#5]

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.

[Gabriel]

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

[tresesco]

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.