topic Re: Indexing in straight table in QlikView

Indexing in straight table

Mon, 11 May 2015 09:14:48 GMT

Hello All,

I am having straight table in that i am having millions of columns but I want to show only first 100 column and after that 101 to 200 like that. So how to do that. In short I want to do indexing on columns.

For Ex:

In given attachment : I am having 22 columns as a dimesion , in that first time I want to show only 10 columns first and then after selection 11 to 20 columns and so on.

Re: Indexing in straight table

Peter_Cammaert — Mon, 11 May 2015 09:58:29 GMT

Millions of columns will be quite a lot of (manual) work.

Maybe you should ask yourself who wants to have access to millions of columns of data in QlikView (usually columns are "expensive"). And for what purpose?

Best,

Peter

Re: Indexing in straight table

Mon, 11 May 2015 10:11:04 GMT

Hello Peter,

It's K . Just consider above example. How we will implement it.

Re: Indexing in straight table

Mon, 11 May 2015 10:11:49 GMT

I read dimension, so if these are dimension columns, then probably you can think of Pivot table. or If on selection you need to see next column, then Liner Drill Down and also Cyclic drill down you can think of.

Thanks,
Singh

Re: Indexing in straight table

Mon, 11 May 2015 10:44:24 GMT

Hello Angad,

No actually I want it in Straight table. Can we give dimension indexing by using cyclic group or drill down

Re: Indexing in straight table

mrossoit — Mon, 11 May 2015 10:48:25 GMT

I would do something like this.

Regards.