Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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?
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.
"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.
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.
Thanks for all your suggestions. I would go for Adhoc reporting now and going forward i will do some requirement analysis.
Thank you all.