Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Produto | Date | Previous | Qtde_COM | Qtde_EVF | Balance |
161642 | 03/05/2019 | 0 | 12 | 0 | 12 |
161642 | 14/08/2019 | 12 | 12 | 0 | 24 |
161642 | 24/08/2019 | 24 | 0 | 4 | 20 |
161642 | 27/08/2019 | 20 | 0 | 2 | 18 |
161642 | 06/06/2024 | 18 | 0 | 1 | 17 |
161642 | 06/06/2024 | 17 | 22 | 0 | 39 |
Preciso agora e gerar o Previous no meses faltantes. adaptando o scritp acima.
Caso o mês tenha registro desconsidere, caso não tenha gere pelo ultimo registro anterior clonado o resto.
igual no exemplo abaixo.
Exemplo:
Produto | Date | Previous | Qtde_COM | Qtde_EVF | Balance |
161642 | 03/05/2019 | 0 | 12 | 0 | 12 |
161642 | 14/08/2019 | 12 | 12 | 0 | 24 |
161642 | 24/08/2019 | 24 | 0 | 4 | 20 |
161642 | 27/08/2019 | 20 | 0 | 2 | 18 |
161642 | 27/09/2019 | 20 | 0 | 2 | 18 |
161642 | 27/10/2019 | 20 | 0 | 2 | 18 |
até mês atual,..... | |||||
161642 | 06/06/2024 | 18 | 0 | 1 | 17 |
161642 | 06/06/2024 | 17 | 22 | 0 | 39 |
Hello,
i need help for a substitution of values from one field if another field is empty (in the data load editor section):
Here is an example in hope my request is more understandable:
Field1 Field2 Proxy
- 534 534
123 123 123
234 234 234
- 567 567
345 - 345
So basically the proxy field should contain the values of either of the field1 or field2 values.
Any ideas on how to solve this?
Hi,
We have a load script picking up excel files from a sharepoint location, doing some minor adjustments and writing the newly created table to a qvd on the same sharepoint location, but in another map.
The idea is executing the load script monthly and it worked fine for several loads. Now we wanted to add the latest month file, but we get this message:
Skipping STORE ExistingDataVR INTO [sharepoint-location/Qvd/QVDName.qvd] (qvd).
At first we thought there's something wrong with the new excel file we want to load. But using an older file which has been loaded in an earlier load, results in the same message as well.
We tried another attempt, with only an earlier file (which has been loaded succesfully in a previous load) into a completely new non existing qvd file and we still get the message mentioned above.
Any ideas why keep getting the SKIPPING STORE message?
Hello experts,
What are some examples of real life use cases of the FieldValueList() function in For Each..Next loops. And how does the usage scenarios differ from utilizing the LOAD DISTINCT function?
Thank you
Hello everyone,
I have a question: Is there a way to move qvd from on prem to qlik cloud ?
I assume there are several options but not sure :
Thank you
Regards
In the qlik business documentation its written there is a Maximum number of scheduled reloads per app per day of 50.
my question is: I'm on the trial now and currently reload my app every 10 seconds via a scheduled POST request in Newman. its working perfectly, can i assume if i buy the license it will continue working? im confused by the 50 reloads limit per day written on the website.
Hi all,
I want to calculate turnover rate per month and here is the formula:
Current month's turnover
/
[(Current month's end headcount + Last month's end headcount) / 2]
However, I need do display the result in a table and line chart.
Due to the Monthly restriction, the expression seems not as easy as I expected.
I don't have a master calendar and I'd like to ask for help. How can I achieve this?
For example, in May, the denominator should be (119+120)/2;
in April, the denominator should be (120+118)/2
I cannot use the following expression because it causes a wrong result. It actually add the number per month.
For instance, in May it results in (119+0)/2;
in April, it shows (120+120)/2, which is not what I want.
(
(
(count(distinct {1<%headcount_key={"*"}, [is_seconded]={"0"}, [section_code] -= {"VAC", "CPP"}, [date_month]={">=$(=MonthStart(vStartDate))<=$(=MonthEnd(vEndDate))"}>} [dim_ppl_employee_sk]))
+
(count(distinct {1<%headcount_key={"*"}, [is_seconded]={"0"}, [section_code] -= {"VAC", "CPP"}, [date_month]={">=$(=MonthStart(vLastStartDate))<=$(=MonthEnd(vLastEndDate))"}>} [dim_ppl_employee_sk]))
)
/2
)
Thanks for any advice.
Tengo un problema con "Text Object" de QlikView, se ingresa la ruta de una imagen, la imagen esta en un servidor externo, simplemente la imagen no aparece, la ruta se ingresa de la siguiente manera: ='http://dominio/Carpeta/'&%imagen&'.jpg.
Para verificar en acciones (open url) se ha dejalo la misma ruta y si se logra visualizar la imagen ya sea en una ventana nueva o en la misma pero no dentro del "Text Object".
Si alguien ha tenido este problema que me pudiera orientar.
gracias
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.
Help us improve your Qlik experience by participating in our customer survey! The survey will be live from May 27 - June 14.
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!