Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

johnpaul
Contributor

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

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?

2 Replies
alexpanjhc
Valued Contributor

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

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
Contributor

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

Hi Alex,

Thanks for the reply.

Here is the script:

Snagit screen capture

http://screencast.com/t/rICuPFeyyf

and if you go to the Tags tab:

Snagit screen capture

http://screencast.com/t/LV9NcZ9n6

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

Snagit screen capture

http://screencast.com/t/hdEXQF9snE

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

Snagit screen capture

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?

Community Browser