topic Re: Qlikview prefer more Rows or columns in QlikView

Qlikview prefer more Rows or columns

Anonymous — Mon, 22 Aug 2016 06:47:07 GMT

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

Re: Qlikview prefer more Rows or columns

vikasmahajan — Mon, 22 Aug 2016 06:51:51 GMT

i guess rows

Vikas

Re: Qlikview prefer more Rows or columns

marcus_sommer — Mon, 22 Aug 2016 07:22:19 GMT

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

Re: Qlikview prefer more Rows or columns

ramasaisaksoft — Mon, 22 Aug 2016 07:27:28 GMT

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

Re: Qlikview prefer more Rows or columns

Anonymous — Wed, 24 Aug 2016 17:28:59 GMT

Please, check the correct answer.

thank you