Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
i have a small logic problem matching 2 fields based on their count amount. i have managed to get the required result, using the set analysis, but this is not working as expected when i want to filter, based on this result field.
So, consider having the following Table:
CreditorNr | Type | BankNr
010001 | 200 | 12345200
010001 | 200 | 12345200
010001 | 200 | 12345200
010001 | 200 | 12345100
010001 | 100 | 12345100
Using the following formula, i obtained the following MatchField:
=aggr(If(
Count(Distinct Type ) = 1 and
Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear'), CreditorNr , BankNr)
i get following results, that are also correct:
CreditorNr | Type | BankNr | MatchField
010001 | 200 | 12345200 | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear
010001 | 200 | 12345100 | Partner bank is not clear
010001 | 100 | 12345100 | Partner bank is not clear
Anyway, when trying to implement this in the Script, i dont get the correct result. In the Script i use the following code:
TEMP:
NoConcatenate
Load CreditorNr,
If(Count(Distinct Type) = 1 and
Count(Distinct BankNr) = 1, 'Partner bank is clear', 'Partner bank is not clear') as ScriptMatch
Resident BankTab
Group by CreditorNr, BankNr;
And i get the following result:
CreditorNr | Type | BankNr | MatchField | ScriptMatch
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is not clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is not clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is clear
010001 | 200 | 12345200 | Partner bank is clear | Partner bank is not clear
010001 | 200 | 12345100 | Partner bank is not clear | Partner bank is clear
010001 | 200 | 12345100 | Partner bank is not clear | Partner bank is not clear
010001 | 100 | 12345100 | Partner bank is not clear | Partner bank is clear
010001 | 100 | 12345100 | Partner bank is not clear | Partner bank is not clear
So it basically goes through every BankNr and duplicates the data, once bank is clear, and once bank is not clear...
Can anyone please give me a hint on what im i doing wrong in the script?
Thank you for the support. 🙂
Hi!
Simple question, we operate a production server and wanted to know if we can have a staging license. This will assist us to test some changes like moving to another domain and changing the admin user.
Thanks
hi all
trying to embed a sheet from Qlik Saas App into salesforce.
added Content Security Policy with the salesforce URL and I'm receiving an error message.
is anyone familiar with this error?
advance thanks
We are trying to update Qlik replicate ssl certificate..
In the installations steps we have app id ::{4dc3e181-e14b-4a21-b022-59fc669b0914} is this appid correct ??
How can i verify this app id is correct on my windows machine before updating the certificates without any issue running the below command
netsh http add sslcert ipport=0.0.0.0:443 certhash=<certificate thumbprint> appid={4dc3e181-e14b-4a21-b022-59fc669b0914}
hey !
Is it possible to load a PDF file containing text and a data table into a Qlik Sense app and work with the data in the app? If so, how can I do it?
Additional details:
I want to be able to load the PDF file each time I use the app.
The PDF file contains both text and a data table.
I want to be able to work with the data in the app, such as creating visualizations and performing calculations.
Please provide any relevant documentation or tutorials that I can use to learn more about this process.
Thank you in advance for your help!
Hello,
Currently i have a table as such:
Type | Type ID |
Medical | 123 |
Medical | 126 |
Vehicle | ABC |
Medical | 127 |
What i would like....
Type | Med ID | Vehicle ID |
Medical | 123 | |
Medical | 126 | |
Vehicle | ABC | |
Medical | 127 |
how does one do this?
Bonjour,
Comment faire un slider qui prend en compte des tranches (plages) de données comme sur QlikView ?
Y a-t-il une extension autre que celle du bundle ? Car celle du bundle permet de sélectionner qu'une seule valeur.
Merci d'avance,
Waïl
Hi all,
fighting with listing all automation for given owner and I could not find any proper documentation how to use --filter option for automations. Only Qlik CLI help within powershell which is not enough.
Filtering through these attributes should be possible: name, runMode, lastRunStatus, ownerId
qlik automation ls --filter 'ownerId eq 64ec602e1fa6aadd5ef3b73e'
This works for me without an error, but if I check ownerId in output of that command can see different ownerId compared to I used within command above. For some users works well for some does not.
Anyone here has some experience pls?
Thank you!
Hello Qlik Friends!
We’re thrilled to announce our first Qlik Meetup of 2024, a fantastic opportunity to reunite with our vibrant Qlik community!
Whether you’re a Qlik newbie or a seasoned pro, this event is the perfect place to engage, learn, and share in all things Qlik.
Let’s dive into a year of growth, inspiration, and amazing connections together.
At the moment, we are hosting two in-person events, more details can be found at the end of this message:
Apr-11th: Atlanta, GA
Apr-25th: Dallas, TX
Attention! Spaces are limited to 35 attendees , so make sure to secure your spot early and join us for insightful conversations and networking.
We can’t wait to see familiar faces and welcome new ones into our circle!
Here’s what we have lined up for you:
Agenda
6:00 - 6:30 PM: Warm Welcome & Networking
Kick off the evening with some light bites, refreshments, and announcements. A great chance to mingle!
6:30 - 7:00 PM: Embracing Qlik Cloud – Why Make the Move?
Dive into the advantages and considerations of transitioning to Qlik Cloud, including cost insights.
7:00 - 7:30 PM: Navigating the Cloud Migration
Learn the ins and outs of moving your Qlik applications to the cloud, focusing on data governance and security.
7:30 - 8:00 PM: Unveiling Qlik Cloud’s Power Features
A quick tour through Qlik Cloud’s standout features, including Notifications, Alerts, Tabular Reporting, and more.
8:00 - 8:30 PM: Charting Your Qlik Career Path
We will guide you through Qlik certification pathways, educational resources, and career tips within the Qlik ecosystem.
Speakers:
Alan McLaughlin , IPC Global Principal
Ana Silva , IPC Global Support Lead
Igor Alcantara , IPC Global Science and Education Director
Mark Costa , IPC Global Director of Data and DevOps
Atlanta, GA
=============
When & Where:
Date: April 11th, 2024
Time: Doors open at 6:00 PM for check-in & networking, sessions to begin at 6:30 PM
Location: Roam Perimeter Center, 1151 Hammond Drive NE, Atlanta, GA 30346
How to find us: When at the facility, look for the Theater Conference room.
Dallas, TX
=============
When & Where:
Date: April 25th, 2024
Time: Doors open at 6:00 PM for check-in & networking, sessions to begin at 6:30 PM
Location: Roam Grandscape, 5752 Grandscape Boulevard Suite 225, The Colony, TX 75056
Would like us to host an event in your city? Contact us for more information.
Let’s make this an unforgettable kickoff to 2024 with insightful discussions, learning, and networking. See you there!
Is there a (simple) way to grant full access to the hub (all actions, all resources) for my RootAdmin role, except to see (edit, etc.) other users' bookmarks?
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
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 enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.
Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.
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!