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

How to display 120 columns textual report in Qlik UI?

Problem Statement:

I have a master table with 120 columns.

Table

Col1 Col2 Col3...........................Col 100 Col 101 Col 102........................Col 118 Col 119 Col 120

Columns are logically grouped as you can see above Col1 Col2 Col3 is one group and Col 100 Col 101 Col 102 is another group.

What is the best way to display information in Qlik UI using above constraints?

I will welcome any suggestion on this.

Thanks,

Vivek Kumar

1 Solution

Accepted Solutions
JonnyPoole
Employee
Employee

Do you have a license ? 

If so you can download the sample from the web site here. Just scroll down and hit 'download qvw'

http://us-d.demo.qlik.com/detail.aspx?appName=Whats%20New%20in%20QlikView11.qvw

If not, the show/hide condition is done on each dimension and each condition.

Below is a sample for the dimension, its checking if the user has selected 'region' in the field that is called '_dimension'.  If Region has been selected, then it evaluates to TRUE and the field is show.  It would be the same for each expression.

=SubStringCount(Concat(_dimension, '|'), 'Region')Capture.PNG.png

View solution in original post

5 Replies
JonnyPoole
Employee
Employee

Go to the 'reports' tab in this demo app and see how they created list boxes to pick and choose which field to show in a chart.  The field names are stored in data islands in the data model and the fields are all included in a straight table chart and hide/show depending on user's selcetion.

Whats nice is that qlik only calculates the shown fields and if the user really wants a really wide report... they have to select for that.  

It would not be hard to extend this to introduce some 'groups' of fields instead of individual field names or in addition to field names

Capture.PNG.png

QlikView

Not applicable
Author

Jonathan,

Many thanks for the reply, I am using Qlik Desktop edition and where do we need to write code to hide/show Dimension or Metric?

Thanks

JonnyPoole
Employee
Employee

Do you have a license ? 

If so you can download the sample from the web site here. Just scroll down and hit 'download qvw'

http://us-d.demo.qlik.com/detail.aspx?appName=Whats%20New%20in%20QlikView11.qvw

If not, the show/hide condition is done on each dimension and each condition.

Below is a sample for the dimension, its checking if the user has selected 'region' in the field that is called '_dimension'.  If Region has been selected, then it evaluates to TRUE and the field is show.  It would be the same for each expression.

=SubStringCount(Concat(_dimension, '|'), 'Region')Capture.PNG.png

Not applicable
Author

Thanks Jonathan. You are too good.

JonnyPoole
Employee
Employee

you are too nice !