topic Re: Star is * in QlikView

Star is *

Thu, 06 Nov 2014 07:07:45 GMT

Hi All,

Can anyone brief me about use of 'Star is *' in qlikview. As what is it, When can we use with example??

I read it in Help but not able to understand ..

Re: Star is *

ychaitanya — Thu, 06 Nov 2014 07:11:36 GMT

* is a wilcard

eg: Match(Month,'J*') means if you pass month as January .. Qlikview accepts the month .

* means any occurances. J* means after J any occurances of letters.

Hope this helps

Regards

Chaitanya

Re: Star is *

senpradip007 — Thu, 06 Nov 2014 07:13:55 GMT

Go through http://community.qlik.com/message/201064#201064 and http://community.qlik.com/message/11139#11139

Re: Star is *

Thu, 06 Nov 2014 07:18:33 GMT

Hi,

Can u brief me on how we can use it in section access ?

Re: Re: Star is *

ashfaq_haseeb — Thu, 06 Nov 2014 07:29:51 GMT

Hi,

Check this

Regards

ASHFAQ

Re: Re: Star is *

Thu, 06 Nov 2014 12:29:56 GMT

hi,

not able to find attachment??

Re: Re: Star is *

ashfaq_haseeb — Thu, 06 Nov 2014 12:30:46 GMT

Hi,

Open this discussion in New window you will see attachment

Regards

ASHFAQ

Re: Star is *

Thu, 06 Nov 2014 12:45:12 GMT

Hi,

When you are using section access sometimes we are using * for all values but it will not give proper result.

that's why we use before the section access STAR IS *;

Like this,

Star is *;

section access;

Load * INLINE [USER, USERID,PASSWORD,FILEDNAME

ADMIN,ADMIN,ADMIN,*

USER,USER1,USER1,UK

USER,USER2,USER2,USA

];

section application;

Here * means UK,USA bt sometimes it wont give proper result so we use Star is *;

Re: Star is *

Thu, 06 Nov 2014 13:10:54 GMT

Hi,

Thanks .

Also Is it necessary to use Star is * before section access or can we use it after section access also,like

section access;

Load * INLINE [USER, USERID,PASSWORD,FILEDNAME

ADMIN,ADMIN,ADMIN,*

USER,USER1,USER1,UK

USER,USER2,USER2,USA

];

section application;

Star is *;

And if possible can you provide any example where wihout 'star is *' Section access fails (for better understanding )

Re: Star is *

Thu, 06 Nov 2014 13:30:17 GMT

Hi,

Not necessary,once you developed the code then you vl test the data then if it doesn't come properly then keep it before the section access.

Sorry i dnt have proper exmpample to provide

Re: Star is *

Anonymous — Thu, 06 Nov 2014 18:47:28 GMT

Morning Rakesh

in section access it is better to use a blank space rather than *

Load * INLINE [USER, USERID,PASSWORD,FILEDNAME

ADMIN,ADMIN,ADMIN,

USER,USER1,USER1,UK

USER,USER2,USER2,USA