topic filter data beore loading in QlikView

filter data beore loading

Sat, 05 Dec 2009 12:46:23 GMT

Hi everyone

I am going to filter data before loading in qvw file. because of data security I need to filter before loading .

how can I do it?

Can I use the textbox for getting Id and then load the data?

thanks

filter data beore loading

Sat, 05 Dec 2009 17:39:03 GMT

I too have the same query. You can refer this link where i have posted. Still i am waiting to get my doubts cleared. Good luck to you!

http://community.qlik.com/forums/t/23015.aspx

filter data beore loading

Mon, 07 Dec 2009 11:00:04 GMT

Thanks for your reply.

I can't use inline because my IDs aren't limited and IDs automatically will add. I want to use ID to limite users to see data.

filter data beore loading

Mon, 07 Dec 2009 14:26:01 GMT

You can load your value like the way shown in the example given below. Hope this helps. You can also look in to the last but the previous post did by Vittaly.

eg:

'USER' as [ACCESS], userid as USERID, password as PASSWORD, mid(userid,1,6) as [account code], mid(userid,7,4) as [mfaccode]

filter data beore loading

Wed, 03 Feb 2010 08:32:19 GMT

Hi BSI,

Use something like below code. It works! Not too sure how it works. I am also confused about the user security and data filteration.

SecurityTable: LOAD

'USER' as [ACCESS], userid as USERID, upper(password) as PASSWORD, account as [account code], mfaccode as [mfaccode]
RESIDENT items;

Section Application;

Regards,

Rikab