Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
soloeeeoff
Contributor III
Contributor III

Star is *

Hi,

I tried "Star is * ". But I could not attain what i have expected.

Please can any one help me..

QUALIFY *;
STAR is % ;
tab1:
LOAD ID,
College,
Dept,
Section,
Name,
Mark1,
Mark2,
Mark3
FROM
[62_Star.xlsx]
(
ooxml, embedded labels, table is Sheet1);
tab2:
load % Resident tab1;

1 Reply
swuehl
MVP
MVP

Star is %;

is changing the wildcard for field values, not field names in a LOAD statement (here, * is used to reference all fields from the input table).

Star is %;

LOAD * INLINE [

Field1, Field2,

A, 1

A, 2

B, %

C, 3

];

Now create list boxes for Field 1 and Field2, you will notice that Field2 only shows values 1 to 3, not a '%' symbol.


Regardless what you select in Field 2, value 'B' in Field 1 will be possible, because of it's 'Wildcard' use.

Hope this explains a little bit the 'star is ...' statement (though I almost never use it, AFAIR, I've had seen some side effects, then dropped it from my daily usage).

Stefan