topic 100 fields in Qlikview in QlikView

100 fields in Qlikview

Fri, 27 Mar 2015 14:43:01 GMT

Is it good tool in displaying all the columns from DB. We have a big table with almost 100 columns/Fields.
User wanted to see all the 100 columns. Is it good idea to develope the report in Qlikview?

Re: 100 fields in Qlikview

maleksafa — Fri, 27 Mar 2015 14:46:12 GMT

not a very wise idea to display all the columns.

you can create ad hoc reports, as in show/hide the columns based on user selection.

can't you transform the 100 columns into rows and add flag to each record?

Re: 100 fields in Qlikview

Roop — Fri, 27 Mar 2015 16:03:20 GMT

I would certainly not display 100 columns from a single table. You can do it and QlikView has that capability BUT there are almost certainly logical groups of fields that can be viewed together as simpler views of your data.

It is very easy to create the separate views so I would tend to take that approach. I would say that you almost certainly need to perform some kind of analysis of requirements before doing this.

Re: 100 fields in Qlikview

Anonymous — Fri, 27 Mar 2015 16:18:54 GMT

"Is it good tool...?" - yes. It is as easy to display 100 fields as to display 5 fields.

"Is it good idea...?" - no, it is not quite "visual". I have to add that I had a client which wanted to have 200+ columns in one table. They insisted and we delivered.

Re: 100 fields in Qlikview

buzzy996 — Fri, 27 Mar 2015 18:02:17 GMT

Like "msolomov" said, but instituted of displaying all ur fields one time in report u can create dynamic fields/measure and ask ur use wht ever required to add into ur report,that can change any time /any way.

Re: 100 fields in Qlikview

Fri, 27 Mar 2015 20:09:29 GMT

Thanks for all your suggestions. I would go for Adhoc reporting now and going forward i will do some requirement analysis.

Thank you all.