Documents about Qlik Sense.
This thread will helps in implementing the column level access. This can be done with Section Access and using Enable Conditional for Dimension in each chart.
Please find attached file for solution.
Login with below user IDs and no Password required :
A - Can see all the columns
B - Can see Sno column
C - Can see name column
D - Can see sno, name and dob columns
Try like this
LOAD * INLINE [
star is *;
B, 1, 0,0,0,0
Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option
This is a fine example, but I have small doubts(may be silly)
1. what is the use of star is *
2. How column names mapped for users because there is no association between usercolumnmapping table and data table.
Ok understood the association,
didn't observe the "enable" condition for the dimensions, but still what is the use of
can we avoid section access screen I mean which asks for userid and password in access point because
any how we are going to give a authentication for access point and can we use the same userid for the section access.
Actually I tried it with NTNAME and it is working fine in QV Desktop for different users(os users) but I dont know about access point.
I think for NTNAME only this works, otherwise you need to key in user ID and password.
From Qlikview Help file:
The string specified is used to represent any values that may appear in a field, including NULL. It is used as a wildcard specifically for the QlikView application. It affects the subsequent Load and Select (SQL) statements. The syntax is:
star is[ string ]
string is an arbitrary text. It can be a single symbolic character, such as an asterisk (*). The string must be enclosed by Quotation Marks in Scripting if it contains blanks
Note! Star is old functionality. It can only be used for section access.
Examples of the Star statement:
Star is *;Star is %;Star is;
Star is *;
Star is %;
If nothing is specified, star is; is assumed; that is, there is no Star "wildcard" available. A string specified as the Star value is valid until a new star statement is made.
Example of Star string used in a Load script:
Star is ASTERISKLOAD *Inline [Category, PlaceCountry, United StatesCity, LondonCountry, FranceCity, ParisCountry, ItalyCity, RomeCountry, SpainCity, MadridASTERISK, MonacoASTERISK, Vatican City];
Star is ASTERISK
Inline [Category, PlaceCountry, United StatesCity, LondonCountry, FranceCity, ParisCountry, ItalyCity, RomeCountry, SpainCity, MadridASTERISK, MonacoASTERISK, Vatican City];
Nice post. Thank you for sharing this.
Useful information thanks for sharing Jagan.
Nice post !! I have one question here . Can this also be done using OMIT in section access or i am missing something .
You can also do the same using OMIT. This have better flexibility.