Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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
Employee
Employee

Re: How to display 120 columns textual report in Qlik UI?

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

5 Replies
Employee
Employee

Re: How to display 120 columns textual report in Qlik UI?

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

Re: How to display 120 columns textual report in Qlik UI?

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

Employee
Employee

Re: How to display 120 columns textual report in Qlik UI?

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

Re: How to display 120 columns textual report in Qlik UI?

Thanks Jonathan. You are too good.

Employee
Employee

Re: How to display 120 columns textual report in Qlik UI?

you are too nice !

Community Browser