filter data beore loading

[#1]

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

[#2]

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

[#3]

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.

[#4]

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]

[#5]

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