Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have employee data - EmpName, Joining Date, Exit Data and added Flag value status as current, New and exit. Each month there are new and exit employees. The next month current is a calculated value using previous month data.
I am getting Invalid Expression for the below script. Can someone please help me understand what is missing in the below.
Load
count(if(status='Current',"EmpName")) as JanExisting,
count(if(status='Current',"EmpName"))
+count(if(status='New' and Month='Jan',"EmpName")) -
count(if(status='Exit' and Month='Jan',"EmpName"))
as JanFinal
Resident MyTable;
Load
JanFinal +
count(if(status='New' and Month='Feb', "EmpName", null())) -
count(if(status='Exit' and Month='Feb', "EmpName", null()))
as FebFinal
Resident MyTable;
Load
FebFinal +
count(if(status='New' and Month='Mar', "EmpName", null())) -
count(if(status='Exit' and Month='Mar', "EmpName", null()))
as MarFinal
Resident MyTable;
Hello everyone,
I need to create a trend line with dimension [Year Month] interval YTD (jan to current month) and for each month i have to calculate the nine month before. I have already created thi graph with this measure:
Rangesum(above(count(Transaction),9)) and the formula works correctly if I don't apply any filter. The problem is that my dimension have to be a YTD so from January to current month but with this formulas January not include the nine month before.
How can i do?
Thanks a lot!
In Qlik Sense Enterprise, when a user clicked on an app icon it would open the app in a new tab. This has become the preferred option by many. In Qlik SaaS, the default when a user clicks on an app is to open the window in the same tab, unless they use the sub-menu of the app and select "Open in new tab". Is there a way to change the default option for all users or at least at the space-level?
i have people names and then the city they belong to. However there is no country field.
Is QlikSense able to interpret the Country/Continent based off the City?
I can't run the job the following error appearsI can't run the job the following error appears
Error: Could not create the Java Virtual Machine.
Error: A fatal exception has occurred. Program will exit.
Error occurred during initialization of VM
Unable to allocate tables for parallel garbage collection for the requested heap size.
Job EXPORT_TO_SKK_VIEW ended at 13:08 28/03/2024. [exit code=1]
Following are the memory settings for the VM
then suddenly a garbage collection appears as follows
So what is garbage collection?
What do I have to do?
I have added xms and xmx but the same error
How do I delete the trash that causes memory to become full like this?
There are two primary ways for the easy Linksys Velop Setup. You can either use the web GUI method or proceed with the Linksys app. All you need is to have stable internet, computer/smartphone, and admin details. After that, log in to the admin panel and follow the instructions to complete the setup or reach out to us!
Recently I have upgrade talend version 7.3.1 to Talend 8.0.1
I faced below major issue after migration of code in talend 8.0.1.
Could you please help how can we add modules section in pom.xml using talend studio 8.0.1?
Any lead would be greatly appreciated.
Thanks In advance.
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?
Hello everyone,
I am failing to understand what advantages could bring for me to implement NPrinting.
What is the difference in capabilities between NPrinting and QlikSense Story telling?
thanks in advance
I would like to setup a new SQL Server endpoint that uses a customize port.
How shall I specify the value under Server text box in "Manage Endpoint Connetions"?
I have attached a screenshot showing that I input as
--> 10.20.30.40,1450
(IP: 10.20.30.40, Port: 1450)
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!