User login to app which shows encrypted data

[ashmitp869]

Hi All,

I have a table where user section access details is stored like below for a single user (Say A) :

So when a user (say A) has AUTHID as N and login to see the report.

The report will show the only record from the below table : ( i.e the encrypted version)

I am not sure if its called field level exncrption. For one user two unique created - one with actual data and other with encrypted.  

Thanks

[Dalton_Ruer]

If I'm understanding correctly your data source actually has both fields. The Encrypted Value, and the Unencrypted Value. I would be hesitant to try and do anything in a chart or master dimension like "If user rights are n show this field else show that field" because they could simply create their own table, or go to the Selections screen to see the unencrypted values. 

I wrote a post many years ago called Making Sense of Section Access in Qlik Sense. https://community.qlik.com/t5/Documents/Making-Sense-of-Section-Access-in-Qlik-Sense/ta-p/1493716

It walks through the case where you simply need to hide certain columns (like unencrypted data) from certain users. But also walks through a case where the end user should see the unencrypted data for certain rows (like their own employees) but not for other rows (other teams employees.)