Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
repctl checkpoint "task name" for downstream task (source: log stream task & target : oracle database) is not giving correct timestamp.
D:\bin>repctl getcheckpoint "TASK_INGCDC_02"
command getcheckpoint response:
{
"checkpoint": "checkpoint:V1#33512#1271;638506460899807820;20240120221751514712#0#0#*#0#137"
}
[getcheckpoint command] Succeeded
Regards
Dipankar
Hello,
i have a pivot table and when I select a cell, Qlik only show the value of the two dimensions who are impacted by the cell.
What must I do to be able to select a cell and in the same time show all the pivot table and the value.
thanks for helping
Hello Everyone, I have a question for Qlik sense. I have a table that has a Date column and a quantity column. I need to create a master Item that calculates the month to date quantity.
I am attaching an Excel file that has those 2 columns and also the column of the MTD that I need to calculate as a master item
Can you please Help ?. Thanks
I have an application that is essentially a flat table. The columns are name, user_id, company, city, state. I want users to be able to input a list of names in the variable input and then fuzzy match those names with the names in my data set. I believe there isnt an actual tool but would love a creative way someone solved this problem
Hi Mashup experts,
I am working on responsive mashup with expandable sidebar feature to show/hide charts on button selection (each button selection shows respective charts). When the page is loaded first time it shows all the charts (lets say all the charts from button A and all the charts from button B). If page is loaded/reloaded and then I select any button then show hide functionality works fine.
To solve this issue I have used different Javascript ways to show only charts for Home button (lets say button A) whenever page is loaded/reloaded. BUT EACH WAY RESULTS SAME, When I select button B, I see the QLIK SENSE CHART TITLE WITH PLACEHOLDER BUT NOT THE QLIK SENSE CHART (for button B only, button A charts are shown properly).
Note: 1. I am calling javascript function on button selection using onclick events.
2. Issue is only with qlik sense charts not with html elements like <img> tags works fine.
I have tried to check this issue online but no positive. I hope it will be answered here.
please check once and let me know for any related inputs/solution.
Edit:
Update: one more point to share, even when I change the % zoom size to any other value OR minimize screen, charts start showing data also for button B charts otherwise they show a charts title and placeholder only.
Hi,
I want to upgrade my existing version of Qlik Sense Enterprise from release February 2023 to February 2024. The existing version still uses the PostgreSQL 9.6 database. So I want to use the Qlik PostgreSQL Installer to upgrade and unbundle the PostgreSQL database.
I stopped all Qlik services except the Qlik Sense Repository Database. Then I start the QPI tool and at the first screen it displays 'No supported existing Qlik Sense PostgreSQL database found. This program will install a new PostgreSQL v14.8 database".
Why doesn't this QPI tool detect my existing database?
When I press next and fill out all fields, field 'database port' becomes red with message 'Database port already used by an external service in the system'. Port 4432 is used by the postgres.exe so then it detects?!
I have attached the pg_hba.conf and the postgresql.conf from folder "C:\ProgramData\Qlik\Sense\Repository\PostgreSQL\9.6". Files are renamed with .txt to be able to upload.
Also I have tried to change the 'listen_addresses' line to 'listen_addresses = '*' without any luck.
I am using NPrinting May2023 SR2 version, org chart extension, dynamic tables with calculated dimensions in adhoc reporting are not not supported in excel, objects or tables are not rendering properly ,Do you have any solution?
Greetings.
I have the below data:
Name | Gender | Class | Subject | Grade |
John | M | A1 | Math | 5 |
John | M | A1 | Science | 4 |
John | M | A1 | French | 3 |
John | M | A1 | Misc | 2 |
Jane | F | A1 | Math | 4 |
Jane | F | A1 | Science | 5 |
Jane | F | A1 | French | 3 |
Jane | F | A1 | Misc | 3 |
Joe | M | A2 | Math | 4 |
Joe | M | A2 | Science | 1 |
Joe | M | A2 | French | 4 |
Joe | M | A2 | Misc | 2 |
Janice | F | A2 | Math | 4 |
Janice | F | A2 | Science | 3 |
Janice | F | A2 | French | 1 |
Janice | F | A2 | Misc | 1 |
I would like to create a Table chart that will display the Average Grade by Person Name. In addition, for that person it will also display the average Grade by gender as well as Class.
Output chart with Average values is as per below:
Average Grade | Overall average grade by gender | Overall average grade by Class | |
John | 3.5 | 3.125 | 3.625 |
Jane | 3.75 | 3.000 | 3.625 |
Joe | 2.75 | 3.125 | 2.500 |
Janice | 2.25 | 3.000 | 2.500 |
Eg: Overall average grade by gender will consider John's grade as well as all grades that match his gender. So Overall average grade by gender for John = Average(5, 4, 3, 2, 4, 1, 4, 2) = 3.125
Further if user selects a name say John, the output should be as per below:
Average Grade | Overall average grade by gender | Overall average grade by Class | |
John | 3.5 | 3.125 | 3.625 |
Thus far, i have not been able to get the correct expression for the last 2 expressions.
Thank you for your time.
I have a spreadsheet to load into Qlik in the following format:
Order ID | Org1 | OrgType1 | Amount1 | Org2 | OrgType2 | Amount2 | Org3 | OrgType3 | Amount3 |
10001 | AAA | Internal | 1000 | BBB | Internal | 300 | CCC | External | 600 |
10002 | DDD | Internal | 1500 | AAA | Internal | 200 | EEE | External | 900 |
10003 | EEE | External | 800 | FFF | Internal | 700 | AAA | Internal | 1200 |
...and so on.
But what I really want to work with in Qlik is a table like this:
Order ID | Org | OrgType | Amount |
10001 | AAA | Internal | 1000 |
10001 | BBB | Internal | 300 |
10001 | CCC | External | 600 |
10002 | DDD | Internal | 1500 |
10002 | AAA | Internal | 200 |
10002 | EEE | External | 900 |
10003 | EEE | External | 800 |
10003 | FFF | Internal | 700 |
10003 | AAA | Internal | 1200 |
Can anyone tell me how to get my data into that format?
Thanks in advance,
Dan
Hello,
Someone can help me: I'm trying to paste the iframe on an html page of my domain, but trying to log in, this page always returns the error message "connection denied nametenant.eu.qlikcloud.it"
Is there any setting to set up?
In practice: I made the sheet public, I took the embedded, I pasted it on my web page www.dominio.it/qlik.html and I pop up the notice described.
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.
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!