Before the day ends, I wanted to draw your attention to this inspiring LinkedIn post from Ruthann Wry, Chief People Officer at Qlik. As a leader in the WomenWhoQlik community, Ruthann's post celebrates:

• The Qlik Women in Tech Employee Resource Group and its amazing leaders @Katie_Davis and @BeaBright-Davies 
• External organizations that champion women leaders like Women in Data and Women Leaders in Data & AI 
• Qlik's donation of 10 Women in Data scholarships to support future leaders
• Snapshots of some of #WomenWhoQlik and their stories

What are you most proud of as part of this community? What else do you hope to see from Women Who Qlik in the future? 

Hi All,

I have data with some PII fields. I have three user role which are defined in the section access data with USERID, ROLE field. Three roles are PII,SEMI_PII,NON_PII. In data I have around 3 PII fields. When user with role PII logs in, he should see all PII field values as is. When user with role SEMI_PII logs in, he should see all PII field values partially masked. When user with role NON_PII logs in, he should see all PII field values fully masked. Masking could be anything but masked values should be unique for each field value. for eg. I have Client Name A,B & C, so masked values could be like xAnvBgH, HnbvFTb & hhGVcDr which is unique to each Name as values will be repeating.

Definition of SEMI_PII is that we have indicator in our data, if indicator value is 1 PII fields should be masked, otherwise original values should be displayed. for eg. Let's say we have Client Name A, B & C. for values A & B indicator is1 and for C it is 0. So when user logs in he should see values cHbbVch,BngVbhjK & C. Which means A & B values will be masked.

Note: I have around 1000 users and PII field values for some field might have 5 million distinct values. 

I don't know how to approach this

Dear Experts,

I am facing an issue with one of our users (USER1) who is unable to download an on-demand report by clicking the on-demand button. Another user (USER2), with identical access rights, is able to download the report without any issues.

USER1 already has all the necessary access in the QMC, similar to USER2. However, USER1 was not present in NPrinting, so I added them. Upon doing so, I encountered the error: "Not NT Domain user, it can be used for JWT and SAML authentication" (screenshot attached).

To troubleshoot, I logged into the server and added USER1 under "Local Users and Groups" in computer management. Unfortunately, the error persists. I suspect that there might be a sync issue between Qlik Sense and NPrinting, but I’m not certain.

Could you please provide guidance on what I might be overlooking?

I am using Qlik NPrinting February 2021

Version: 21.0.0.0

and 

Qlik Sense Feb 2021 Patch 4
qliksenseserver: 14.5.10

Thank you for your help!

Hello Everyone, 

I have created a 'Mark as Final' Button in a report using variables and Vizlib buttion actions in qlik.

i.e vStatus = 0 (Button not clicked)
     vStatus =1 (Button clicked)

When user clicks on the reports it , it will show as below

But when after page refreshing also button is getting active .  

Once the button is finalized it should not become active untill the app next refresh.

Need some suggestions and ideas to implement this.

Thank you.

Hi,

I'm trying to export a pivot to excel in QS and I get the error "Corrupted data".
It is possible to export from another pivot in the same sheet.
I tried to solve it with some posts here but it didn't work.
What could be the problem and how to solve it?

Hi ,

It is a open discussion. I met the below case , need your help. Thanks in advance. 

I need to show the work load analysis by different people. 

Their daily job include Job1 , Job2 , Job3 , Job4 , Job5 , ( these job is independent, no association)

the daily job workload is linked with the sql server, so it will added day by day;

Currently , my boss told me the sheet is difficult to read . So , I want to use Entropy Analysis . 

I know how to do in excel. But , I don't how to do in QLIK Sense . 

Beside it , the data will added day by day . So, the number is dynamic.

Pls....

I want to append latest/current week's data to a file wherein we have 6 month's data(excluding the current week) ,

to do that I am using a peek function to look for the max date in the 6months data,

and then wants to compare it with the latest week's max date , if the date matchs that means we have concatenated the data if it doesn't match then we have to concatenate the latest week's file to 6 Month's file.

For getting latest week's data we are using a REST Connector, 6 months data is stored as qvd

$(maxdate_latest) is the variable to peek into latest max date and $(vmaxdate) is the variable for the 6months max date

I'm using this script

if '$(maxdate_latest)' <> '$(vmaxdate)' then
Reference_data:
load * from reference_qvd2;

concatenate

Streaming_data:

load * from reference_qvd2;

Else

0;

Endif;