Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to create the variables in current selection box?

Hii all,

    iam creating the date variables in edit script, but that date variables are not selected on the current selection box? how to create that variables in current selection box?

8 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

This is how Qlik works.

None of your variables will be shown in current selection box.

Regards

ASHFAQ

Not applicable
Author

Hi Naveen,

That is unfortunataly how QlikView works. I suggests creating an Input Box with the variables. This will always show the variable information.


Regards,
Marius

vardhancse
Specialist III
Specialist III

By default,

Variables will be displayed in current selections.

Check that any

set HidePrefix='_' ;

set HidePrefix='%' ;

was there in the script.

If so, comment that and reload you can able to see the variables selections in current selection

Not applicable
Author

Hi Sasi,

I tried with what you suggested, but it did not work.

ashfaq_haseeb
Champion III
Champion III

It will not work

You have to use input box to see variable selection as suggested by Marius Koekemoer

Regards

ASHFAQ

Not applicable
Author

Hi,

As per definition in QV help: "In the current selections box, selections are listed by field name and field
value. This tool displays the same information as the free-floating Current Selections window but it is
positioned directly on the sheet like any other sheet object. The Indicators is used for
distinguishing between selected and locked values. "

So, it shows with values what we select in our objects and not the variable inside script. As suggested above you can use Input Box or you may go for Text Box.

Not applicable
Author

Yeah thanks Ashfaq.

Hi qv_learner,

All you do when you set this variable "HidePrefix='_'" is you hide all fields with _'s inside the model.

For instance

LOAD

     ColumnA,

     ColumnB,

     _ColumnC,

     ColumnD

FROM xxx.qvd;

When you right click to select fields inside your model _ColumnC won't be visible for you to select.

Regards,
Marius

MarcoWedel

Field <> Variable !