Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

Section Access with multiple fields Or condition

Hi,

Have a requirement is that

Have below data

     

GroupCountryGRMCustomerLocationLRM
Group1IndiaName1Customer1IndiaName1
Group1IndiaName1Customer2SingaporeName2
Group1IndiaName1Customer3AustraliaName3
Group1IndiaName1Customer4ChinaName4
Group2AustraliaName3Customer1SingaporeName2
Group2AustraliaName3Customer2AustraliaName3
Group2AustraliaName3Customer3ChinaName4
Group2AustraliaName3Customer4IndiaName1

Now my section access should work like if a user login in to dashboard, he should be either GRM/LRM then then only he should see his relevant data.

Can please any one let me know the solution for the same, thanks in advance for your support.

PFA sample QVW

18 Replies
Not applicable

hi,

yes you can use

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, AUTHID

    ADMIN,ram,ram,NAME1|NAME1

    ADMIN,vimlesh,NAME2|NAME1

    ADMIN,san,san,NAME1|NAME2

];

Section Application;

table:

LOAD GROUP,

    COUNTRY,

    GRM,

    upper(Customer) as CUSTOMER,

    upper(Location) as LOCATION,

    upper(LRM) as LRM,

    UPPER(IF(len(trim(GRM))>0,GRM,'<ANY>') &'|'& IF(len(trim(LRM))>0,LRM,'<ANY>'))  as AUTHID

  

FROM

(ooxml, embedded labels, table is Sheet1);

Regards

Vimlesh

vardhancse
Specialist III
Specialist III
Author

Hi,

Yes but in for limited set of combinations we can use but of large volume of data how can we go in manual approach

vardhancse
Specialist III
Specialist III
Author

USER NAME AND PASSWORD PLEASE.?

vardhancse
Specialist III
Specialist III
Author

Hi,

My requirement is not based on region and more over looking for solution with or condition between 2 fields

vardhancse
Specialist III
Specialist III
Author

I am looking for or condition between GRM and LRM but not on country

jagan
Luminary Alumni
Luminary Alumni

Hi Sasi,

Is there any sample user details with sample LRM & GRM values?  Please attach.

Regards,

jagan.

vardhancse
Specialist III
Specialist III
Author

Hi Jagan,

PFA QVW for reference.

Not applicable

Hi jagan,

My client need to authenticate through gmail account and then pass access.

please help me.

i searched and got web ticking ,when i am using that code ,getting some error.

please tell me something how can i do.

Regards

Vimlesh

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this using OMIT

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, OMIT

    ADMIN,ADMIN1,ADMIN1, LRM

    USER,USER1,USER1, GRM

  USER,USER2,USER2, GRM

  ];

Section Application;

Now user ADMIN1, LRM column is hidden

Now user USER1, GRM column is hidden

Now user USER2, GRM column is hidden

Please find attached file.

Regards,

Jagan.