Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Inspiring keynotes. Informative breakouts. Innovative technology. Virtual Event May 17-19.
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Bonjour à tous,
J'ai réalisé un TCD de ce genre dan Qlik Sense Business
2022 | 2021 | ||||
Quantité | VS N-1 | Quantité | VS N-1 | ||
A | JANVIER | ||||
FEVRIER | |||||
MARS |
J'aimerais afficher la colonne "VS N-1" uniquement pour l'année en cours soit uniquement pour l'année 2022 en ce moment et donc obtenir cela :
2022 | 2021 | |||
Quantité | VS N-1 | Quantité | ||
A | JANVIER | |||
FEVRIER | ||||
MARS |
J'ai testé de mettre une condition d'affichage de la colonne grâce à une expression (year(Today())=Année mais cela s'applique aux 2 colonnes "VS N-1".
Je vous remercie de votre aide,
No
Hello Qlik Experts,
i have created some security rules, where users are allowed to develop in a specific developer stream.
The idea behind this is that there are not an unnecessarily infinite number of apps. And there is only one app, on which several users with certain rights work on the frontend/backend in parallel. I managed to make it so that certain users can open/read/edit the script editor. But in the frontend i am still missing two panels (fields, variable).
Is there any security rule that says, that users with the development property are allowed to see these panels?
Best regards Son
Hi all!
I don't know how to ask for new improvements, so I decided to write it down here.
Is it possible to add a new "table" on Outlook 365 Connector to mark as read a mail on O365 mailbox?
It would makes it easier for us to manage the receipt of data by mail.
Regards,
Alonso Torres
Hi All,
I have three different headers based on language and wanted to know how I can load this data in QV along with respective data for these three headers.
If you look at the sample below:
Row 1, 3, 5 are headers. Row 2,4,6 are respective data for these three headers. Now on the UI I want to create three report based on different header/language. Only identifier we have for three headers - LangaugeFlag.
Date | Language | Language Flag | Issue |
16-05-2021 | English | English | A |
Date | Language | CHHeader | Issue |
16-05-2021 | Chinese | Chinese | B |
Date | Language | JPHeader | Issue |
16-05-2021 | Japanese | Japanese | C |
Sample Output:
Output 1: English
Date | Language | LanguageFlag | Issue |
16-05-2021 | English | English | A |
Output 2: Chinese
Date | Language | CHHeader | Issue |
16-05-2021 | Chinese | Chinese | B |
Output 3: Japanese
Date | Language | JPHeader | Issue |
16-05-2021 | Japanese | Japanese | C |
Please let me know how this can be achieved in the backend script.
Note: have huge volume of data and loading the table from database. Only way to differentiate three headers based on Language Flag column
Hey everyone,
So I've been working in QlikView for 1.5 years in my 9 to 5 job, and I would love too make models as a freelancer during evenings and weekends.
Does anybody know anyplatforms aside from workana and upwork?
Any help would be appreciated.
I have this graph in which the red bar represents the new products that have arrived, the blue bar represents the pending units (this are the units that have arrived and must be repaired) and the green bar represents the number of units that have been repaired.
I have used he following expressions:
New products: count({$<DateType={'Arrived'}>} ProductID )
Repaired: count({$<DateType={'Repaired'}>} ProductID )
Pending Units: rangesum(above(total count({$<DateType={'Arrived'}>} ProductID ),0,RowNo(total)))-rangesum(above(total count({$<DateType={'Repaired'}>} ProductID ),0,RowNo(total)))
This is showing my data correctly but when I select a particular date, the formulas apparently apply from that date and not for the total of the data.
For example when the date 31/03/2022 is selected the representation changes from the one seen above to the following:
How can I avoid this?
Hi all
I need to load multiple files into Qlik Sense from a Sharepoint library on our intranet.
I've previously been able to load data from individual files by creating a direct connection to a file with no issues. However this time I need to load data from 100 different files in the same library so this method isn't viable.
I do have access to the Office 365 Sharepoint Web Connector but haven't been able to get it to authenticate. Any tutorials on Web Connectors use a .com address as the base URL, but as I'm trying to connect to an intranet site it's a .aspx address which comes back as an invalid resource.
Does anyone have any advice? Thanks in advance
Adam
Hi,
Please help me with the below requirement.
Attaching the sample data and in the data we need to consider week '2244' .
Thanks,
Kishore
Hi
I have a couple of Qlik Sense Applications running on the windows server version that are failing to save when reloading (not all).
When I click the "Load Data" button in the Data load editor it seems to work fine until it gets to the end of the Data Load progress. the "Saving app..." appears for a brief second before it get overridden by the text "Unknown error".
Below is the contents on the Data load progress dialog on "Load data"
----------------------------------------------------------------------------------------------------------------
Hi, I want to see the count of dates that lie in current week.
I am using the expression
=count({< [Date] = {">=$(=WeekStart(Today()))<=$(=WeekEnd(Today()))"}>}[Date])
but there is no output.
Any suggestions on what am I doing wrong ?
MVP
23032Employee
8877MVP
8722MVP
8295Partner
8001Employee
6556MVP & Luminary
5788MVP
5398MVP
4750Employee
4002Learn about what's new across all of the products in our growing Qlik product portfolio.
Important and useful support information about end-of-product support, new service releases, and general support topics.
All about product and Qlik solutions: scripting, data modeling, visual design, extensions, best practices, etc.
Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。
Welcome to the group for Brazil users. .All discussions will be in Portuguese.
Der deutsch(-sprachig)e Qlik-Markt bietet so manche Spezialität, die sich hier leichter diskutieren läßt.
Transform financial outcomes with next-gen business intelligence strategies
How Qlik helped Greene Tweed reduced time to insights by 65%
Attend a live webinar session with our expert instructors and special guests to review learning topics in the Qlik Continuous Classroom and beyond.