Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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!
Talend Data Services Platform
Version: 8
Build id: 20240524_0800-patch
Hi,
I have this expression in tMap.
/if the work email is null
row7.EMAIL==null
//or the work email is blank
||StringHandling.BTRIM(row7.EMAIL).isEmpty()==true
//then return empty string
?""
//else return the email string
:StringHandling.DOWNCASE(StringHandling.BTRIM(row7.EMAIL))
I am trying to replace the null vlaue to "" in the EMAIL field.
I am getting the error:
Type mismatch: cannot convert from String to boolean
The EMAIL columns is defines as varchar2(30) in Oracle (source).
Appreciate any suggestions.
Thank you
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 have following data in my QV document
POLICY_NO | YEAR | PERIOD_FROM | PERIOD_TO | NEW_REN | LAST_REN_YEAR |
7M00111C0000087 | 2012 | 21-Oct-2012 | 20-Oct-2013 | REN | - |
7M00111C0000087 | 2013 | 21-Oct-2013 | 20-Oct-2014 | REN | 2013 |
7M00141A0000245 | 2014 | 04-Nov-2014 | 03-Nov-2015 | NEW | - |
7M00141A0000245 | 2015 | 04-Nov-2015 | 03-Nov-2016 | REN | 2015 |
7M00141W0000022 | 2014 | 06-Mar-2014 | 05-Mar-2015 | NEW | - |
7M00141W0000022 | 2015 | 06-Mar-2015 | 05-Mar-2016 | REN | 2015 |
7M00131D0000089 | 2013 | 10-Jun-2013 | 09-Jun-2014 | NEW | - |
7M00131D0000089 | 2014 | 10-Jun-2014 | 09-Jun-2015 | REN | - |
7M00131D0000089 | 2015 | 10-Jun-2015 | 09-Jun-2016 | REN | 2015 |
7M00141A0000253 | 2014 | 31-Dec-2014 | 30-Dec-2015 | NEW | - |
7M00141A0000253 | 2015 | 31-Dec-2015 | 30-Dec-2016 | REN | 2015 |
7M00151D0000140 | 2015 | 08-Jan-2015 | 07-Jan-2016 | NEW | - |
7M00151D0000140 | 2016 | 08-Jan-2016 | 07-Jan-2017 | REN | 2016 |
7M00144F0000002 | 2014 | 29-Nov-2014 | 28-Nov-2015 | NEW | - |
7M00144F0000002 | 2015 | 29-Nov-2015 | 28-Nov-2016 | REN | 2015 |
7M00141C0000155 | 2014 | 28-Aug-2014 | 27-Aug-2015 | NEW | - |
7M00141C0000155 | 2015 | 28-Aug-2015 | 27-Aug-2016 | REN | 2015 |
LAST_REN_YEAR IS MISSING IN SOME RECORDS I WANT TO POPULATE THE MISSING LAST_REN_YEAR WITH LAST_REN_YEAR OF THE CORRESPONDING POLIICY_NO
EG:
POLICY_NO | YEAR | PERIOD_FROM | PERIOD_TO | NEW_REN | LAST_REN_YEAR |
7M00111C0000087 | 2012 | 21-Oct-2012 | 20-Oct-2013 | REN | 2013 |
7M00111C0000087 | 2013 | 21-Oct-2013 | 20-Oct-2014 | REN | 2013 |
PLS HELP
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;
People | Job1 | Job2 | Job3 | Job4 | Job5 |
A | 6 | 7 | 60 | 43 | 16 |
B | 91 | 85 | 13 | 34 | 6 |
C | 96 | 73 | 46 | 46 | 90 |
D | 36 | 19 | 60 | 65 | 91 |
E | 12 | 76 | 22 | 53 | 54 |
F | 18 | 44 | 17 | 70 | 68 |
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;
Pencil in our most magical conference yet: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL
Fuel your data and AI journey with the right services, delivered by our experts.
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Your journey awaits! Join us by Logging in and let the adventure begin.
Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
Join one of our Location and Language groups. Find one that suits you today!
A private group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights..
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!