Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Why don't these two example charts show the same colors (see example image)?
Top chart: I first created this one. Appearance settings is custom colors by dimension Dim2, and I have chosen a color scheme from my custom theme.
Bottom chart: I duplicated the first chart, and the only thing I changed is the appearance color setting. Here I have chosen colors by expression, and the colors that the expression defines are the same color codes as in the custom theme palette used in the top chart.
Why are the colors in the topmost chart "faded"?
The hex codes for the colors are exactly the same in the expression as in the custom theme definition. I don't understand why the colors are faded in the top chart.
Qlik Sense Enterprise on Windows February 2024 patch 3.
I upgraded a 'API Key - Raw API Request' block today that was posting raw form data. After the upgrade, Qlik does not send the request to the remote server and returns a HTTP 500 error.
When upgrading, Qlik prompted me that the Form encoded body field was removed. I was already sending a raw body like 'field1=value1&field2=value2' with the 'Content-Type' header set as 'application/x-www-form-urlencoded'. In the previous version of the 'API Key - Raw API Request' it was working fine.
I have tested this with a remote server and with the old and the upgraded block, the request of the upgraded block not arrive at the remote server. The error also indicates something fails on Qlik's side. I would like to know how I can POST form data using the new 'API Key - Raw API Request' block.
I want to connect a postgresql database to a job talend but database password contain special character ù and talend send me this error
Caused by: java.lang.IllegalArgumentException: value contains character 'ù' which is non US-ASCII
I search on forum but i never find solution to this problem.
Thank you for your help.
Hi there,
I am trying to compute a 5-weeks moving average correctly to display it in a graph in a Nprinting report.
Basically my data looks like the attached example :
- week id
- Nb is my measure
- Moving average 5 weeks : the 5-week moving average of the measure "Nb"
I want to display "Nb" and its "Moving average 5 weeks" only over the last 10 weeks, so between week 202411 and 202420 in my example.
But for weeks 202411 to 202415, I need older data points to be able to compute properly the 5 weeks rolling average, example :
Moving average 5 weeks for week 202411 = (120 + 200 + 27 + 128 + 625 )/5 = 220
Problem : if I filter on the last 10 weeks only, I miss older data required to compute properly the 5-weeks rolling average. For 202411, I will only get 120/5 = 24 which is wrong.
How can I do to compute properly the moving average for each point and only then, filter to display only the 10-week period of my interest ?
What I have already tried without success :
- compute the moving average in QlikSense and then filter on 10 last weeks in Nprinting graph : FAILED
- filter on 20 last weeks in Nprinting graph to get correct moving average value and then apply an additional filter on 10 last weeks at task level (hoping the aggregation would be performed before the final filter on period) : FAILED
Thanks for your help
Hi All,
In my project using Qlik Data integration here as Source; Sql server, Target: snowflake
After full load of the DB. Iam getting the below errror. Kindly share your suggestions as soon as possible.
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
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).
Hello,
On mobile devices filter clicks result in a popup window.
My question;l how to disable this behaviour?
The current view is clear enough, i want the selected value to be set without any additional popup.
Couldn't find the question/answer on the forum.
Thanx!
Best regards,
Sander Kolkman
Hi there 🙂
I have a list of products with list prices and different valid-from dates to this prices. Now I simply want to show only the newest valid-from dates (one per product). Thats it 😄
Coud you please help me out with the script function. Attached you find the table load.
Thanks a lot!
Pesche
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!