topic Re: STAR Keyword Usage in QlikView

STAR Keyword Usage

jsingh71 — Mon, 21 Apr 2014 11:19:02 GMT

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.

Re: STAR Keyword Usage

Mon, 21 Apr 2014 11:24:51 GMT

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

Re: STAR Keyword Usage

tresB — Mon, 21 Apr 2014 11:29:27 GMT

And,

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

Re: STAR Keyword Usage

jsingh71 — Mon, 21 Apr 2014 12:18:31 GMT

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.

Re: STAR Keyword Usage

Mon, 21 Apr 2014 12:23:47 GMT

it can only be used for section access

Re: Re: STAR Keyword Usage

Miguel_Angel_Baeyens — Mon, 21 Apr 2014 12:40:23 GMT

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