Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

100 fields in Qlikview


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?

5 Replies
Highlighted
Specialist
Specialist

Re: 100 fields in Qlikview

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?

Highlighted
Specialist
Specialist

Re: 100 fields in Qlikview

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.

Highlighted
Champion III
Champion III

Re: 100 fields in Qlikview

"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.

Highlighted
Master II
Master II

Re: 100 fields in Qlikview

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.

Highlighted
Not applicable

Re: 100 fields in Qlikview

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

Thank you all.