Discussion Board for collaboration on QlikView Security and Governance.
Have two fields
unencrypted_number - this is omitted for most users
encrypted_number - everyone can see this
For a dimension in a graph , I want to say "If unencrypted_number is omitted use encrypted_number, else use unencrypted_number"
Can this be achieved?
Go to Solution.
This is not an elegant solution but could be the start for you.
Add secretField as an expression
then add another expression that says
I am sure you could say if (lefn(secretField))>=1 as well.
Hope this gets you started.
please post sample data/app
Attached is .qv.
data is inline. admin is admin...user 1 can't see secret field, user 2 can, so if user 1 is logged in, I want the diemsion of the graph to change from secretField to publicField
LOAD * INLINE [
ACCESS, USERID, PASSWORD,OMIT
secretField, publicField, sales
1111, xxxx, 21
2222, yyyy, 42
3333, zzzz, 53
not the most elegant as you say but it works