Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
This is how Qlik works.
None of your variables will be shown in current selection box.
Regards
ASHFAQ
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
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
Hi Sasi,
I tried with what you suggested, but it did not work.
It will not work
You have to use input box to see variable selection as suggested by Marius Koekemoer
Regards
ASHFAQ
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.
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
Field <> Variable !