Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to all.
I try to count in a date range the new registration. I want to calculate, for values >0 the number of customers that got record for the first time.
In excel, by manual handle I get the following data. Note I use Month as dimension
Row Labels |
sep |
oct |
nov |
350 |
203 |
44 |
15 |
351 |
162 |
46 |
31 |
352 |
197 |
39 |
13 |
353 |
76 |
49 |
26 |
355 |
61 |
102 |
17 |
356 |
43 |
102 |
17 |
357 |
0 |
55 |
107 |
Grand Total |
742 |
437 |
226 |
In Qlik using date as dimension I get the following result
I need help in order to have the correct results.
Also it would be amazing if I could have the capability to check it in weeks or months by setting a range that find new. For example, ii there wasn't any record 100 days before, is a new one
thanks in advance
I'm new to Qlik Analytics and excited to explore how it can help with data-driven decisions. I’m particularly interested in using it for industries like transportation, where data from various sources, including traffic and incident reports, can provide powerful insights.
For example, in cities like Phoenix, where car accidents are a frequent issue, having accurate and up-to-date data visualization could help authorities or legal teams—like Phoenix car accident attorneys—better understand patterns and improve response strategies.
I’d love to hear any beginner tips for using Qlik in this type of real-world scenario or how you’ve tackled similar challenges!
Trying to get the Rank for a specific values in a dimension, which is aggregated by multiple dimensions in the rows and columns in a pivot table.
Here is the example table and expected pivot table results
Region | Product | Source | Industry | FEE | Bank Name | Year |
India | P1 | A | L1 | 80 | BOA | 2023 |
India | P1 | A | L2 | 88 | City | 2023 |
India | P2 | B | L1 | 23 | SriBank | 2023 |
India | P2 | B | L2 | 36 | HDFC | 2023 |
USA | P1 | A | L1 | 28 | BOA | 2023 |
USA | P1 | A | L2 | 51 | City | 2023 |
USA | P2 | B | L1 | 87 | SriBank | 2023 |
USA | P2 | B | L2 | 26 | HDFC | 2023 |
India | P1 | A | L1 | 20 | BOA | 2024 |
India | P1 | A | L2 | 23 | City | 2024 |
India | P1 | A | L2 | 43 | SriBank | 2024 |
India | P2 | B | L2 | 18 | HDFC | 2024 |
India | P2 | B | L2 | 68 | SriBank | 2024 |
USA | P1 | A | L1 | 30 | BOA | 2024 |
USA | P1 | A | L2 | 35 | City | 2024 |
USA | P2 | B | L1 | 44 | SriBank | 2024 |
USA | P2 | B | L2 | 95 | HDFC | 2024 |
In the Qlike Sense a Pivot table, dimension rows have Region, Source and Industry. Column has Year and Product Dimensions.
Please help me to create a measure expression to get the Rank for the 'SriBank' in the BankName table when the 'SriBank' is compared with all other values in the BankName column, and comparing is based on the Sum of Fee. The Pivot table cell values would be the Rank of 'SriBank' by Rows and Column dimensions and Total aggregated by all the columns.
Below is the expected pivot output
Year | Product | |||||||
2023 | 2024 | |||||||
Region | Source | Industry | 2023 Total | P1 | P2 | 2024 Total | P1 | P2 |
Global | 2 | 0 | 1 | 1 | 3 | 2 | ||
India
|
India Total | 4 | 1 | |||||
A Total | 0 | 2 | 1 | 1 | ||||
L1 | ||||||||
L2 | 1 | |||||||
B Total | 2 | 2 | 1 | 1 | ||||
B | L1 | 1 | 1 | |||||
L2 | 2 | |||||||
USA
|
USA Total | 1 | 2 | |||||
A Total | ||||||||
A | L1 | |||||||
L2 | ||||||||
B Total | 1 | 1 | 2 | 2 | 2 | |||
B | L1 | 1 | 1 | 1 | ||||
L2 |
Hi,
Do you have any idea what seems to be the problem in my ODBC connection in Qlik Cloud.
I can successfully connect to the MySQL database using ODBC connection but when I select data, the databases are in chinese characters.
Attached here is my config and the list of databases
We work with an evaluation form which uses a Vizlib writeback table.
Recently we're receiving the following message on it:
The user is missing Create access on the App (with ID: dc76da48-a63a-4f32-8d29-1c9e2791beac) or create apps is disabled on server node. (needed to be able to create a session app)
I am admin and should have all rights, but I too cannot add new data.
Any idea where I can fix this?
Trying to get the Rank for a specific values in a dimension, which is aggregated by multiple dimensions in the rows and columns in a pivot table.
Here is the example table and expected pivot table results
Region | Product | Source | Industry | FEE | Bank Name | Year |
India | P1 | A | L1 | 80 | BOA | 2023 |
India | P1 | A | L2 | 88 | City | 2023 |
India | P2 | B | L1 | 23 | SriBank | 2023 |
India | P2 | B | L2 | 36 | HDFC | 2023 |
USA | P1 | A | L1 | 28 | BOA | 2023 |
USA | P1 | A | L2 | 51 | City | 2023 |
USA | P2 | B | L1 | 87 | SriBank | 2023 |
USA | P2 | B | L2 | 26 | HDFC | 2023 |
India | P1 | A | L1 | 20 | BOA | 2024 |
India | P1 | A | L2 | 23 | City | 2024 |
India | P1 | A | L2 | 43 | SriBank | 2024 |
India | P2 | B | L2 | 18 | HDFC | 2024 |
India | P2 | B | L2 | 68 | SriBank | 2024 |
USA | P1 | A | L1 | 30 | BOA | 2024 |
USA | P1 | A | L2 | 35 | City | 2024 |
USA | P2 | B | L1 | 44 | SriBank | 2024 |
USA | P2 | B | L2 | 95 | HDFC | 2024 |
In the Qlike Sense a Pivot table, dimension rows have Region, Source and Industry. Column has Year and Product Dimensions.
Please help me to create a measure expression to get the Rank for the 'SriBank' in the BankName table when the 'SriBank' is compared with all other values in the BankName column, and comparing is based on the Sum of Fee. The Pivot table cell values would be the Rank of 'SriBank' by Rows and Column dimensions and Total aggregated by all the columns.
Below is the expected pivot output
Year | Product | |||||||
2023 | 2024 | |||||||
Region | Source | Industry | 2023 Total | P1 | P2 | 2024 Total | P1 | P2 |
Global | 2 | 0 | 1 | 1 | 3 | 2 | ||
India
|
India Total | 4 | 1 | |||||
A Total | 0 | 2 | 1 | 1 | ||||
L1 | ||||||||
L2 | 1 | |||||||
B Total | 2 | 2 | 1 | 1 | ||||
B | L1 | 1 | 1 | |||||
L2 | 2 | |||||||
USA
|
USA Total | 1 | 2 | |||||
A Total | ||||||||
A | L1 | |||||||
L2 | ||||||||
B Total | 1 | 1 | 2 | 2 | 2 | |||
B | L1 | 1 | 1 | 1 | ||||
L2 |
Hello,
I have a Talend runtime that seems to be working correctly. However, the log file tesb.log has not been updated for a month now.
Could you please tell me what I need to check? Additionally, I have restarted it, but it doesn't change anything. Thank you.
Regards.
Hi All,
I have a date field Created_On at source. From source to QVD we are loading as it. Few records are NULL or Empty in Created_On. We need to implement such a logic so that Null fields will be populated as "Empty". Like below:
if (Created_On = Null)
then ("Empty")
else
(Created_On)
Please suggest.
Thanks in advance for your help.
Sarif
Hi there,
I have followed this instruction (https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/excel-add-in-install.htm) , however, I am getting the following error after implementing excel add-ins installation.
Hello,
I just noted the above extension is gone from QMC after installation of Patch 10 May 2024 version.
I also tried to manually install the extension from the zip file but it gives me an error.
Then I tried to do a repair of Qlik Sense Object Bundles but with no success.
Finally I removed the Patch 10 to get the extension available again in QMC.
I hope it will be fixed asap.
Best Regards
@Bastien_Laugiero @Sebastian_Linser @ToniKautto @Michael_Tarallo
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row.
Apply by December 16 to showcase your expertise and become a Qlik Lumbiary or Qlik Partner Ambassador!
Seamless Public Data Sharing with Qlik's New Anonymous Access Capability
With Qlik Answers™, get personalized, GenAI-driven answers from unstructured data, so you can make decisions with confidence. Learn how in our product roadmap keynote and demo.
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 enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.
Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.
Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.
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!