Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
maleksafa
Specialist
Specialist

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?

Roop
Specialist
Specialist

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.

Anonymous
Not applicable
Author

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

buzzy996
Master II
Master II

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.

Not applicable
Author

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

Thank you all.