Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
Je n'arrive pas a me connecté au cluster Dataproc depuis Qlik replicate.
Erreur veut dire que l'adresse host et le numéro du port pour se connecter à Hive qui bloque par contre la config pour le cloud Storage est OK .
Cordialement.
Cordialement.
Hi all, below is a snapshot of my data which starts in Jan 1st 2023. I wish find total using set analysis with the following criteria:
1. If(Actual > Planned, Actual, Planned) and
2. Between Monday and Friday. Therefore, the correct total planned would be 11.
I don't wish to create a new variable or using the load editor.
Jobid | Date | Day | Planned Widgets | Actual Widgets | if Actual > Planned,Actual,Planned |
1 | 18-Mar-24 | Mon | 0 | 1 | 1 |
2 | 19-Mar-24 | Tue | 2 | 2 | 2 |
3 | 20-Mar-24 | Wed | 2 | 1 | 2 |
4 | 21-Mar-24 | Thu | 1 | 1 | 1 |
5 | 21-Mar-24 | Thu | 0 | 1 | 1 |
6 | 22-Mar-24 | Fri | 2 | 2 | 2 |
7 | 22-Mar-24 | Fri | 2 | 2 | 2 |
8 | 23-Mar-24 | Sat | 2 | 2 | 2 |
9 | 24-Mar-24 | Sun | 2 | 2 | 2 |
13 | 14 | 15 | |||
Mon to Fri | 9 | 10 | 11 |
Loading a QVD file from a SFTP connector (not from webconnector) occurs an error: noFileSize
Any file format doesn't have an error when loading.
I tried to load with an other QVD, the same issue persist.
Antivirus doesn't scan the SFTP folder.
There is not file access restrictions, antivirus software locking the file, or resource bottlenecks
Any idea to fix it?
The replication task is working, we change a column from NOT NULL -> NULL and the task gets suspended.
The task's DDL Handling policy says: "When source table is altered: ALTER target table"
At the moment, the tool is version 2022.11.0.208, we will upgrade it next week
Hi there,
I'm looking for a way to show sales activity done in the first month.
Currently this is only possible for the Current month as there is next month activity.
How do I call on a specific activity date in a bucket?
The metrics I (think) need to use are:
[Revenue]
[start date](in days eg. 01/01/2024, 02/01/2024, etc)
So I want the following:
Jan 2023 showing Month 1 revenue
Feb 2023 showing Month 1 revenue
March 2023 showing Month 1 revenue
etc. etc.
Is there a way to do this?
Thanks
Robert
Hi, I am creating a chart with multiple lines to indicate a base price, a price that gets 50% of the calls and a line indicating a price that gets 100% of calls.
The 3 boxes to the right indicate where the lines should be. The red line and the green line are functioning correctly but the yellow line should be at 35 and is instead fixed at 0.
To calculate the yellow line I am using this calculation:
round(fractile(total_revenue, 0.5)*1.2 , 5)
The reason I think there might be an issue here is because the green line uses almost the same calculation, but shows the correct answer.
round(fractile(total_revenue, 1.0)*1.2 , 5)
Below are screenshots of how the lines are showing up on the bar chart. The green line and red line are correct the but the yellow line is not at the 35 mark even though for the box and the yellow line I have just put the same calculation. I have tried adjusting the fractile value for the calculation and there still mismatch for the yellow line. I also tried deleting and recreating the master item with the calculation, deleting and recreating the line, deleting and recreating the box and just adding the calculation to the box and the chart without the master item.
Does anyone have any idea what could be wrong here?
Hi, I am trying to do the Num and den and accumulative, like Num = 400 and Den = 455 for 2022 Jan , its percentage is 87.9 and it is accumulating feb 88.9 and it is accumulating to 176% intead of feb 88.9 and march 89
This is my expression.
=rangesum(above(Count({<[NUMERATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))/rangesum(above(Count({<[DENOMINATOR]={'1'},[QUESTION]={'Q9'}>} distinct [RESPONSEID]),0,RowNo(total)))
Elevate your career with Connect. 15 Hands-on workshops and certifications for Data and Analytics.
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!