Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jsingh71
Not applicable

STAR Keyword Usage


Hi All,

Can anyone explain the STAR kewword usage with example. I searched in Help as well as in reference manual but didn't find the appropriate description.

Thanks in Advance.

5 Replies
Not applicable

Re: STAR Keyword Usage

Hi,

The string used for representing the set of all the values of a field in the database can be set through the star statement. It affects the subsequent Load and Select (SQL) statements. The syntax is:

star is [string ]

where, string is an arbitrary text. Note that the string must be enclosed by Quotation Marks if it contains blanks.

Examples:

Star is *;

Star is %;

Star is;

If nothing is specified, star is; is assumed, i.e. there is no star symbol available unless explicitly specified. This definition is valid until a new star statement is made.

Thanks,

Prabhu

tresesco
Not applicable

Re: STAR Keyword Usage

And,

Note!
Star is an old functionality. It can only be used for section access.

jsingh71
Not applicable

Re: STAR Keyword Usage

Thanks for your reply PRABHU.You copied the reference manual content. If you have any idea about this can you explain its usage with example.

Not applicable

Re: STAR Keyword Usage

it can only be used for section access

Miguel_Angel_Baeyens
Not applicable

Re: Re: STAR Keyword Usage

And even so, its meaning may be confusing.

Take a look at the following example:


STAR IS *;

SECTION ACCESS;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, COUNTRY

ADMIN, ADMIN1, ADMIN1, *

USER, USMANAGER, US1, US

USER, ESMANAGER, ES1, ES

USER, FRMANAGER, FR1, FR

USER, FINANCE, FN1, *

];

SECTION APPLICATION;


When the QVW is open locally, the "*" means all possible values:

  • Both Admin1 and Finance user will see all countries

But when the very same QVW is open in a server, either by IE Plugin or Ajax client, it means "all listed values":

  • Both Admin1 and Finance users will see only COUNTRY = US, ES, FR, even if in the model there are more values for the field Country.

Miguel