Discussion Board for collaboration on QlikView Layout & Visualizations.
If you put the hideprefix in the load script, for example _dimension, then the dimension won't be displayed in the listbox.
An example of this is shown in the What's new in QlikView 11 on the reports sheet, where you can select which dimensions to show.
If you use an expression, you can add the dimension OK, but the listbox which is there shows all the hidden ones.
Anyone know how to do this?
The dimesnion will show in list box.
I do not think the following statement is true
I also looked at the whats new qvw, but i guess i do not know what you refer to?
the qvw shows the all metrics(expressions) when you select one dimension. You want to show only selected expressions I assume?
if so , in the straight table there is a conditional check box for expression
you need to add getcurrentselctioncount(metrics)>0
Thanks for the reply.
Here is the script:
and if you go to the Tags tab:
Then on the Reports sheet within the application and check the properties on the Pick Dimension(s) listbox:
If I add a new listbox manually, then all I get is the following:
Which is the default. I know that I can add an expression =_dimension, but how do you get all the other hidden dimensions to show?