Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')
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
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
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')
Thanks Jonathan. You are too good.
you are too nice !