Problem in data filteration after adding multiple databases
Hi All,
Can anyone help me to load two tables of same structure from two different databases which is also of same structure.
Same has to be done for Security table(Section Access) also.
I have attached the sample application. Hope this will help you to understand. From the application check the following points.
1. Check whether it is the right way load two tables of same structure from two different databases which is also of same structure.
2. Also check whether i have done correctly in the Security table(Section Access) also.
3. Problem what I am facing here is all the userid and password from VPDPLdatabase works but from the RSM database only those userid which have password as c2info99 only works. Let me know why it is happening like that.
Will be thankful if some one helps me to give sheet wise access according to the logged in user.
Can anyone help me to load two tables of same structure from two different databases which is also of same structure.
Same has to be done for Security table(Section Access) also.
I have attached the sample application. Hope this will help you to understand. From the application check the following points.
1. Check whether it is the right way load two tables of same structure from two different databases which is also of same structure. Though it is working i request some one to check it once. Please!)
2. Also check whether i have done correctly in the Security table(Section Access) also. Though it is working i request some one to check it once. Please!)
3. Problem what I am facing here is all the userid and password from VPDPLdatabase works but from the RSM database only those userid which have password as c2info99 only works. Let me know why it is happening like that. (It is working now. The reason why it was not working was other than C2INFO99 rest of the password were in small letters. After converting it to upper in the section access it started working.
Will be thankful if some one helps me to give sheet wise access according to the logged in user. ( SOME ONE CAN HELP ME FOR THIS PLEASE???)
Admin user has not yet been created in that. As i don't know how to do it.
Actually all the user id including admin comes from table which has not been included in the script due to synthetic key. All the userid except admin is as what it has been loaded through script.
Let me know how admin userid and pasword can be taken now.
1. Check whether it is the right way load two tables of same structure from two different databases which is also of same structure. Though it is working i request some one to check it once. Please!) <- That's correct and works fine.
2. Also check whether i have done correctly in the Security table(Section Access) also. Though it is working i request some one to check it once. Please!) <- That's correct but you just need one sentece, the other one "duplicates" the records
3. Problem what I am facing here is all the userid and password from VPDPLdatabase works but from the RSM database only those userid which have password as c2info99 only works. Let me know why it is happening like that. (It is working now. The reason why it was not working was other than C2INFO99 rest of the password were in small letters. After converting it to upper in the section access it started working. <- That's right, all the values in section access must be in upper format
Will be thankful if some one helps me to give sheet wise access according to the logged in user. ( SOME ONE CAN HELP ME FOR THIS PLEASE???)
For giving sheet access according to the logged user you must be define a condition in every sheets properties options, general, show sheet / Conditional and insert the follow sentence:
=mixmatch(QvUser(), '001001202', '051011702', 'User ID what you want')
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
1. Check whether it is the right way load two tables of same structure from two different databases which is also of same structure. Though it is working i request some one to check it once. Please!) <- That's correct and works fine. à Thank you for checking the same
2. Also check whether i have done correctly in the Security table(Section Access) also. Though it is working i request some one to check it once. Please!) <- That's correct but you just need one sentece, the other one "duplicates" the records. à I couldn't get you. May I know what exactly is wrong? Where the duplicates are happening.
3. Problem what I am facing here is all the userid and password from VPDPLdatabase works but from the RSM database only those userid which have password as c2info99 only works. Let me know why it is happening like that. (It is working now. The reason why it was not working was other than C2INFO99 rest of the password were in small letters. After converting it to upper in the section access it started working. <- That's right, all the values in section access must be in upper format. à Thank you for checking the same
Will be thankful if some one helps me to give sheet wise access according to the logged in user. ( SOME ONE CAN HELP ME FOR THIS PLEASE???)
For giving sheet access according to the logged user you must be define a condition in every sheets properties options, general, show sheet / Conditional and insert the follow sentence:
=mixmatch(QvUser(), '001001202', '051011702', 'User ID what you want')à Not able to understand your idea. Can you please explain in such a way so that beginners like me can understand. I need the explaination about the expression which you wrote.
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4
1. Check whether it is the right way load two tables of same structure from two different databases which is also of same structure. Though it is working i request some one to check it once. Please!) <- That's correct and works fine. à Thank you for checking the same
2. Also check whether i have done correctly in the Security table(Section Access) also. Though it is working i request some one to check it once. Please!) <- That's correct but you just need one sentece, the other one "duplicates" the records. à I couldn't get you. May I know what exactly is wrong? Where the duplicates are happening. <- It works fine, it's only an advice, QlikView takes care of removing / compacting duplicate records, so do not worry.
3. Problem what I am facing here is all the userid and password from VPDPLdatabase works but from the RSM database only those userid which have password as c2info99 only works. Let me know why it is happening like that. (It is working now. The reason why it was not working was other than C2INFO99 rest of the password were in small letters. After converting it to upper in the section access it started working. <- That's right, all the values in section access must be in upper format. à Thank you for checking the same
Will be thankful if some one helps me to give sheet wise access according to the logged in user. ( SOME ONE CAN HELP ME FOR THIS PLEASE???)
For giving sheet access according to the logged user you must be define a condition in every sheets properties options, general, show sheet / Conditional and insert the follow sentence:
=mixmatch(QvUser(), '001001202', '051011702', 'User ID what you want')à Not able to understand your idea. Can you please explain in such a way so that beginners like me can understand. I need the explaination about the expression which you wrote.
As far as I understood, you want users to limit the visibility of certain pages and / or objects, so they have the property that I have indicated before, the QvUser function returns the nickname what the user used to login, so you can decide when or not allowed to see the page or object.
Yes you are correct! I want users to limit the visibility of certain pages and / or objects. Still i couldn't understand your idea. Can you please implement the same in my application. I will tell you what i need in my application.
I have created two sheets in my application. 1. Distributor 2. Company.
If admin logs in he should be able to see the distributor sheets only and whereas if others logs in (eg: userid:0010012021, password:c2info99) He should be able to see only the Company sheet not the distributor.
