Star is *

[#1]

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 ..

[ychaitanya]

* 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

[senpradip007]

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

[#4]

Hi,

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

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[#6]

hi,

not able to find attachment??

[ashfaq_haseeb]

Hi,

Open this discussion in New window you will see attachment

Regards

ASHFAQ

[#8]

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 *;

[#9]

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 )

[#10]

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