How to show hidden dimensions like on what's new in QV 11?

[johnpaul]

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?

[alexpanjhc]

The dimesnion will show in list box.

I do not think the following statement is true

If you put the hideprefix in the load script, for example _dimension, then the dimension won't be displayed in the listbox.

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

HTH

[johnpaul]

Hi Alex,

Thanks for the reply.

Here is the script:

http://screencast.com/t/rICuPFeyyf

and if you go to the Tags tab:

http://screencast.com/t/LV9NcZ9n6

Then on the Reports sheet within the application and check the properties on the Pick Dimension(s) listbox:

http://screencast.com/t/hdEXQF9snE

If I add a new listbox manually, then all I get is the following:

http://screencast.com/t/WIMB4QWSp1Ja

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?