Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have Table1 with InvoiceId, which I have to match with Id, TransId and PaymentId respectively in Table2. If InvoiceId from Table1 match with any one of these 3 columns, then show status as Matched. Else show not matched in a table. Please suggest.
Hi,
I have a sales table with products sold on different dates and a budget table with budget amounts (month wise) for all the products for 12 months (Apr'24-Mar'25).
I have made an association between both the tables by creating a composite key using product_code, monthyear and Region fields.
In front-end, when I click on ytd button, the sales amount is showing correctly while the Budget is only reflecting of those products of which sale has happened in sales table. But I want to also include budget of those products for which sale has not happened.
Hello Qlik Community,
Is there any information about adding Alignment (to left or to right) option to object Variable input from Qlik Dashboard Bundle? This object has only one option and always aligned to left.
In many of my apps I need aligning to right.
I'm trying to place the object and to adjust it to other objects so it looks good but still it's not always placed well enought.
Thanks
Miriam
Dear all, I have a table with general ledger movements, and I want a bar chart showing the sum of these amounts per month/year.
It's cumulative data, so the bar chart should show e.g. jan/2021 - feb/2021 - mar/2021 whereby the amount in each month is cumulative for the month in question and all previous months.
Below sample table of my data, with the column Desired Outcome what needs be shown in the bar chart.
YearMonth | Amount | Desired Outcome | |
2024-Jul | -98.164,39 | 88.433,27 | all data |
2024-Jun | 41.816,93 | 186.597,66 | all data up to jun 2024 |
2024-May | 13.591,33 | 144.780,73 | all data up to may 2024 |
2024-Apr | -228.636,43 | 131.189,40 | all data up to apr 2024 |
2024-Mar | 191.707,76 | and so forth…. | |
2024-Feb | -50.594,50 | ||
2024-Jan | 95.192,49 | ||
2023-Dec | -2.823,69 | ||
2023-Nov | -44.201,88 | ||
2023-Oct | 70.545,65 | ||
2023-Sep | 100.000,00 |
This is the formula I tried, with no succes.
Sum({< [YearMonth] = {"<=$(=Max(YearMonth))"} >} ActAmount) |
Can somebody help please.
Many thanks,
Paul
hi everyone,
I have this mapping load:
SEARCH_FIELD:
mapping LOAD* INLINE [
SEARCH , REPLACE
' I3','| I3'
' I2','| I2'
' I1','| I1'
' I4','| I4'
' I5','| I5']
as I want to replace these strings in the 1st column by the ones in the 2nd column using a MapSubString function as below:
TABLE:
LOAD MapSubString('SEARCH_FIELD',SEARCH) AS RESULT FROM MyData;
As you can see, there is a space at the beginning of the SEARCH elements ([space]I3 for instance) because I want the text to be replaced only if there is indeed a space before the "I". If there is no space, there shouldn't be a mapping.
However, the MapSubString (or the mapping load) is not considering that space, which leads me to substitute the data where no substitution should be done.
Do you have an idea on how I could fix this?
thanks a lot for your help!
Hello
Say we have a table of vegetables that i created something that has values like TABLE A "potato","tomato","onion"
and another tables that has repeated instances of these very values TABLE B like a survey for example where it shows what every customer bought i want to count the instances of each value of table A in TABLE B how can i do that
I need this cause i want to create a dimension of it so i could display them individually or filter them
Hi,
I've just taken the new Business Analyst Qualification Exam (2024) at Qlik Learning, which has been online since 20 October 2024. If I'm not completely mistaken, there may be an error in the exam questions.
It concerns one of the last few questions in the exam, where the examinee is asked to first select the year 2022 in the sheet "Product Sales Overview" and then use the existing charts/tables to identify two correct statements from five given statements.
I struggled for quite a while, as none of the five statements matched the results shown in the charts after selecting "2022." However, I noticed that if no specific year is selected, two of the five statements appeared to be correct.
So I finally selected the two statements that are correct when no specific year is selected and submitted my answer.
Although I passed the exam, there is no option to review the correct/incorrect answers. Could you please review the exam question mentioned above and correct it if necessary? If there is indeed an error, examinees could be really confused (as I was) and lose significant time on this question.
Thanks and best regards,
Diana
Dear All,
Following vulnerabilities have been found for Qliksense Feb 2024 version. Has anyone gone through these and fixed them ? Could you please share the steps of resolution for each.
I hope Qlik Software Support team might have the list as well, Just wanted to know the steps for fixing these.
SSL Certificate - Self-Signed Certificate | QID-38169 |
SSL Certificate - Signature Verification Failed Vulnerability | QID-38173 |
TLS Padding Oracle Vulnerability (Zombie POODLE and GOLDENDOODLE) | QID-38764 |
Please share solution if anyone went through these recently.
Thanks
Vamsi
Hello there!
Is there a way to include what is selected in a filter pane in the Title or Subtitle section of a visualization?
Something like this:
By adding an expression in the Title / Subtitle boxes:
I have configured all the settings, still i am getting the same error while opening the talend executable file.
Any help would be greatly appreciated.
Seamless Public Data Sharing with Qlik's New Anonymous Access Capability
Fuel your data and AI journey with the right services, delivered by our experts.
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!