Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to show the output highlidhted below in red().
If the difference review date-today() >0 I need to show the difference in the format as highlighted in red().
And one addon like if review date-today() < 365 I need to show like 2 months 11 days instead of 0 years 2 months 11 days.
ref | review date | =today() | review date-today() | difference | Required output |
000AL2 | 01/07/2024 | 21/04/2024 | 71 | <365 | 2 months 11 days |
000AL2 | 01/07/2026 | 21/04/2024 | 801 | >365 | 2 Years 2 months 11 days |
000AL2 | 01/07/2029 | 21/04/2024 | 1897 | >365 | 5 Years 2 months 12 days |
000AL2 | 01/07/2032 | 21/04/2024 | 2993 | >365 | 8 Years 2 months 13 days |
000AL2 | 01/07/2035 | 21/04/2024 | 4088 | >365 | 11 Years 2 months 13 days |
Hello Everyone, I am new to Qlick and use trial version since yesterday. Following tutorial, it is requested to select "auto ML experiment" from the "Add New" drop down menu. But, This field is missing. I am wondering whether this is because I am using a trial version of Qlick...?
Does someone know about it ?
Thank you for your help
Hi,
I am trying to get zero value to be shown in the line chart. I have created a pivot table for the same data that I want to show in line chart. For the year 2024, 2023, 2022 i have created columns and the 2024 column contains zero value for the region for specific month. The same is done in line chart but the zero value for not shown in the line chart.
I have tried toggling all the options under missing data, but nothing worked.
Qlik Enterprise Feb 2024
Is this possible. I see in the documentation that 365 is possible. Currently we get some of our data via email with no source. It is manually entered on a company shared document via SharePoint, of which several data points are input this way. I would really love to be able to connect it. Long term wise we are set to move to 365, but may be done later down the line as there are bigger projects in the works already.
I thought about having a computer with OneDrive Business sync the file, and then share that script to an internal ftp or network drive. But seems a bit excessive for a work around (though it would be very easy to do.)
Hi All,
We were trying to upgrade our QlikSense enterprise version from August 2022 to February 2024.
Steps:
- All services related to QlikSense were stopped (PostgreSQL was running).
- Installed Feb 2024 version, Installation window was success. Pls see below screen.
- Clicked on Finish.
All the Services which was stopped before the installation was running post this installation. But we were not able to launch/use/ QlikSense.
The Server was not reachable post installation. we captured details from the logs folder and restored the Windows server version with the snapshot.
Please suggest what might be the issues due to which the the server was not reachable post installation.
Thanks in advance.
Hi!
I have a dashboard with 2 excel tables in the contents (Table 1 and Table 2). I need to do some KPIs, summarizing, values from table 2, but just the ones that belongs to a list of people in Table 1. The field that I need to use to compare between 2 tables is the "key" between the tables. Is there any way or formula I can use to do that conditional exercise.
Is it clear? Can maybe I build a new table from the 2 existing ones?
Thank you!
Hi all,
My Qlik Cloud OneDrive data source connection was working properly, and then all of a sudden, my reload tasks started failing & when I try to extract data from any of my existing files in it, I am getting this error message
I can still access the OneDrive folder from the load script & see my files. But when I try to pull any one of them in, I am receiving that error message.
Any knowledge on how & why this is happening?
Thank you
Hi Support Team,
There are 「Advanced Run Options」 available for Qlik tasks.
You can select the following in 「Tables are already loaded. Start processing changes from:」.
・Date and Time
・Source change position
In the REST API RunTask there is an option "RESUME_PROCESSING_FROM_TIMESTAMP",
I think this is the same function as 「Date and Time」.
Please tell me how to specify 「Source change position」 as a RunTask option.
Dear gurus
There are so many similar posts in here but try to understand it may takes some time. Hence i decide to post it here using my table.
I have 2 tables - Staff and Form_Submission. Both table contains column 'Name' and 'UserIds'
In the load editor how am i suppose to write the script so that i want to know which staff in table Staff has never submit a form. I saw lots of example using Not Exist. Just hope that someone can help me by using my scenario here . TQ !
Hi Team,
I am part of the Nike team, we use attunity replicate regularly to access to ingest data from Oracle and db2.
I already registered with my Nike account. But Still I am not able to access(or raise one) to any existing tickets.
Name: Dheeraj Gona
Email: Dheeraj.gona@nike.com
Wondering about Qlik Talend Data Integration Sessions? There are 11, in addition to all of the Data & Analytics. So meet us in Orlando, June 3 -5.
Browse our helpful how-to's to learn more about navigating Qlik Community and updating your profile.
Join us on April 24th at 10 AM ET for the next Do More with Qlik webinar focusing on Qlik’s Data Integration & Quality solutions.
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!