Ask a Question

Welcome to
Qlik Community!

Recent Discussions

Sort By:

New to Qlik Analytics

Matching column with multiple columns and show matched/not matched

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 wi... Show More

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.
Show Less

By kaushi2020 2024-10-26 / 11:14 PM

2 0 51
App Development

Need Help with showing correct figures in Sales amount KPI and Budget amount KPI

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 ... Show More

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.
Show Less

By dushyant 2024-10-26 / 12:38 AM

2 1 72
App Development

Object Variable input

Hello Qlik Community, Is there any information about adding Alignment (to left or to right) option to object Variable input from Qlik Dashboard Bundle... Show More

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

Show Less

By MiriamS7 2024-09-05 / 02:50 AM

4 1 227

Cumulative sum per month for balance sheet account

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, ... Show More

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

Show Less

QlikView App Dev

mapping load neglecting space

hi everyone, I have this mapping load: SEARCH_FIELD: mapping LOAD* INLINE [ SEARCH , REPLACE ' I3','| I3' ' I2','| I2' ' I1','| I1' ' I4','| I4' ' I... Show More
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!
Show Less
By Delphines 2023-09-05 / 08:59 AM

7 1 702
App Development

Count instances of values of a table in another table

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 r... Show More

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
Show Less

By RyugaHideki 2024-10-26 / 02:05 AM

2 1 73
New to Qlik Analytics

Potential Error in Business Analyst Qualification Exam (2024) Questions

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 compl... Show More

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

Show Less

By Diana1993 2024-10-26 / 11:29 AM

0 1 47

New to Qlik Analytics

vulnerabilities found for QlikSense 2024

Dear All, Following vulnerabilities have been found for Qliksense Feb 2024 version. Has anyone gone through these and fixed them ? Could you plea... Show More

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

Show Less

397

App Development

Include filter pane selection in Title/Subtitle

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 a... Show More

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:

Show Less

By DEMONIO_AZUL 2024-10-25 / 12:09 PM

2 1 109
Water Cooler

Talend installation issue

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.... Show More

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.

Show Less

By ShahNawaz 2024-10-26 / 08:18 AM

0 1 35

High Five

Meet Matheus

Our featured member for October 2024

Leaderboard

igoralcantara

MoeyE

iti-attunity-sup

Kushal_Chawda

Raju_6952

marksouzacosta

Popular Resources

View All

Customer Story

Accelerating Decision-Making with Qlik Insights

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.