topic Re: Best use for Qlikview in QlikView

Best use for Qlikview

Tue, 14 Jul 2015 10:53:42 GMT

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

Re: Best use for Qlikview

jagan — Tue, 14 Jul 2015 10:57:18 GMT

HI,

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

Regards,

Jagan.

Re: Best use for Qlikview

Tue, 14 Jul 2015 14:03:43 GMT

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

Re: Best use for Qlikview

Gabriel — Tue, 14 Jul 2015 14:05:46 GMT

Hi,

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

Kindly list them or explain

Re: Best use for Qlikview

Tue, 14 Jul 2015 14:10:11 GMT

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.

Re: Best use for Qlikview

Gabriel — Tue, 14 Jul 2015 14:13:35 GMT

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

Re: Best use for Qlikview

tresB — Thu, 16 Jul 2015 07:04:25 GMT

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.