Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I need your help quite urgently.
I have 2 sources, so 2 fields with the name 'code'. I need to compare them so I added a 'flag' into the sources: 'Source 1' as Flag and 'source 2' as Flag.
I need to find the codes who only have 'source 1'. So they are missing in source 2.
All those codes have 2 sources in this example: source 1 and 2.
I only need the codes with source 1 (and not source 2).
load script example (basic):
load
code as 'check code'
Source 1 as Flag
From source 1
load
code as 'Check code'
Source 2 as Flag
From source 2
I've been trying all day to create YTD perios in order to create a chart showing figures compared over the current year period. I'm used to having YTD's in my data and simply adding them to my chart in Excel but in Qlik, I can't seem to work this out.
Below is how I would have it created in Excel:
This makes an easy year on year comparison possible.
But how can I get ytd's and add them to a grouped bar chart like above AND have these refreshed automatically upon a new data load?
I' ve been puzzling with expressions for dimensions in the chart but that didn't work out, I tried to add a variable containing the YTD (add wanting to add YTD-1 and YTD-2 later on).
I created 2 tables(qlik_users and qlik_attribute) in database (screenshot attached)
and successfully synced then using user directory connector ,
But these synced users are failing to authenticate / login to Qlik hub and QMC
Tried different ways to resolve this , -
But nothing worked, please help if anyone can provide suggestions
Hi everyone,
I am currently working on one of my first automations. I have used this very good knowledge base article to create a Loop and reduce automation
I have a working solution. The field I use to loop over has more values than I want to use to create apps from.
To filter them I use a condition. I wanted to list all the values in one condition. For this I tried to separate them by comma or semicolon, but this doesn't work. I also tried to compare with list contains or contains.
Does anyone have a working solution on how to compare to a list of values?
Thanks a lot for your help!
Tenho um fluxo de automação, onde chamo alguns relatórios para um trigger atualizar e disparar alguns e-mails. Como coloco um timer entre um dash com o outro? Deu Start no aplicativo 1, aguarde 10 minutos e inicie o 2 assim por diante e caso de erro rode de novo.
Hi everyone
When using the bullet chart and adding a second measure as alternativ the segment option is greyed out and the expression for the colours to use also is not applied.
Is this a bug?
Hi! Has anyone had any issues creating a NPrint report and all the dashboard inserted on the template come out looking too wide or on 2 pages? I’ve played with resolution settings, but no luck. Any guidance would be helpful! ty
Hi everyone
Why is it not possible to use a drill down dimension in a Variable Input Control with which one could choose the desired dimension and the change in dimension then automatically is overtaken to all diagramms in focus?
Variable input control | Qlik Sense on Windows Help
Thanks
Hi,
I have a date and time field. I want to convert the field to MonthYear and use it in a line chart. I used the expression below but the line chart is not showing the monthyear as expected. Can anyone help please. Thank you.
LOAD
"Submission Date",
date(MonthStart(date#([Submission Date], 'DD/MM/YYYY hh:mm')), 'MMM-YYYY') as MonthYearEX,
Submission Date | customer | Amount | Expected |
30/01/2022 14:10 | John Doe | 23 | Jan-22 |
01/08/2023 16:15 | John Doe | 56 | Aug-23 |
02/07/2021 08:31 | John Doe | 42 | Jul-21 |
02/03/2024 10:34 | John Doe | 87 | Mar-24 |
02/06/2024 16:19 | John Doe | 26 | Jun-24 |
Hi Qlik-Experts,
I want to generate a grid chart using two dimensions and calculate the relative fraction but aggregated by one of the dimension.
Unforturnately I am struggling right now.
Attached screenshot shows, that the sum per each row seems to work.
The overall "aggregated sum" is also correct (2.540.234), but for my understanding it would need to be shown in each row of the last column.
Could you please help to push me in the right direction?
Thanks in advande
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.
Join us on May 15th at 11 AM ET to discuss the Qlik Ideation Process. Bring your questions.
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!