Re: Qlikview prefer more Rows or columns - Qlik Community

Anonymous · ‎2016-08-22

Hi Expert

In my data model i have more columns than rows. which is best optimization for qlikivew.

When qlikiview can work fast is it for rows or columns?

regards

Ramu

vikasmahajan · ‎2016-08-22

i guess rows

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

marcus_sommer · ‎2016-08-22

It will depend on the kind and amounts of data you have and which views are required - and then in which direction should be optimized: load run-times, gui-calculations, RAM consumption, development and maintainability, others ...? This meant you need to be more specific because there are no simple rules which could be applied.

- Marcus

ramasaisaksoft · ‎2016-08-22

Hi Ramu,

At present may be your data(Rows) is less,but in future definitely your data will increase am i r8?

so no need to worry about that.

according to optimization you can fallow reduce the calculations at UI level,try to create star schema ,Join conditions...ect

Anonymous · ‎2016-08-24

Please, check the correct answer.

thank you