topic Re: Maximun Limits in QlikView

Maximun Limits

Mon, 26 Oct 2015 09:03:32 GMT

Hi all,

could you please share maximum number columns can we insert in Qlik View?

Note:i have enough ram and may CPu performance is also good

how may levels we can create in dril down optation in Qlick VIEW?

(creation of charts and povits )

Re: Maximun Limits

Gysbert_Wassenaar — Mon, 26 Oct 2015 18:03:40 GMT

For practical purposes the number of columns is limited by the amount of ram. You won't hit another hard-coded limit before running out of ram. As far as I know that goes for drill down levels as well.

Another limit you may run into first is performance. You can create a chart with 10 thousand dimensions, but it won't move an inch.

Re: Maximun Limits

Mon, 26 Oct 2015 18:13:34 GMT

Perfect answer ...great ...I have a one question for example I have 4 gb ram how many columns I Wil insert in qlik view and how many levels I Will create in dril down...?can we assume that

Re: Maximun Limits

Gysbert_Wassenaar — Mon, 26 Oct 2015 18:28:01 GMT

No idea. If you have 1 row of data in 100.000 columns you may have a completely non-functional application. Or not. And the same applies if you have 1 column and 3 billion rows of unique values. There's no way to answer this. You will simply have to test.

Re: Maximun Limits

Tue, 27 Oct 2015 03:29:49 GMT

Thnak you Gysbert Wassenaar