topic Re: How to show hidden dimensions like on what's new in QV 11? in QlikView

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

johnpaul — Thu, 27 Sep 2012 21:17:12 GMT

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 — Thu, 27 Sep 2012 21:39:53 GMT

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 — Thu, 27 Sep 2012 23:14:37 GMT

Hi Alex,

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?