topic Re: how to create the variables in current selection box? in QlikView

how to create the variables in current selection box?

Mon, 18 Aug 2014 06:53:23 GMT

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?

Re: how to create the variables in current selection box?

ashfaq_haseeb — Mon, 18 Aug 2014 07:28:08 GMT

Hi,

This is how Qlik works.

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

Regards

ASHFAQ

Re: how to create the variables in current selection box?

Mon, 18 Aug 2014 07:33:22 GMT

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

Re: how to create the variables in current selection box?

vardhancse — Mon, 18 Aug 2014 07:39:57 GMT

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

Re: how to create the variables in current selection box?

Mon, 18 Aug 2014 09:19:12 GMT

Hi Sasi,

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

Re: how to create the variables in current selection box?

ashfaq_haseeb — Mon, 18 Aug 2014 09:21:39 GMT

It will not work

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

Regards

ASHFAQ

Re: how to create the variables in current selection box?

Mon, 18 Aug 2014 09:34:04 GMT

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.

Re: how to create the variables in current selection box?

Mon, 18 Aug 2014 09:34:10 GMT

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

Re: how to create the variables in current selection box?

MarcoWedel — Mon, 18 Aug 2014 09:39:33 GMT

Field <> Variable !