Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We ran into aggregation issues with "Keep" statement. When I change Keep to Join, the aggregation works as expected. Here is the script and what's expected.
X:
LOAD * Inline[
TICKET_NBR, TRAN_DATE_KEY, TRAN_NBR, TRAN_KEY
A1, 10, 1, 1000
A1, 10, 2, 1000
A1, 11, 3, 1001
A2, 10, 1, 1000
A2, 10, 2, 1001
A3, 10, 1, 1000
A3, 10, 2, 1001
A3, 11, 3, 1000
];
Left Keep (X)
Y:
LOAD * Inline[
TRAN_KEY, AMT
1000, 200
1001, 500
1002, 100
];
Straight table
For TICKET_NBR A1, TRAN_KEY 1000
Count(AMT) should be 2
Sum(AMT) should be 400
Count(TRAN_KEY) is 2 and it is correct
Sum(TRAN_KEY) is 2000 and it is correct
Same case with TKT_NBR A3 as well.
Kindly look into this and advise a solution. I have attached the qvw for reference.
Thanks,
Mahesh
Hi,
My main table has 75,000 rows, one for each patient. I work in healthcare. Another table has about 72,000 rows, one for each patient that matches the criteria built for that specific table, its filtered down a little. When I load these two tables into my app, I only get the 72,000 patients to show, but I want to show all of the 75,000 patients. I feel like i am missing something small somewhere for this to occur, does anyone have any idea?
When I click "Load Data" i can see that the app is fetching 75,000 rows for the first table, then it goes and fetches 72,000 rows for the next table. These two tables have to be built seperately like I have them. I dont want rows to drop off from the first table just because a patient/record doesnt exist in the second smaller table. Please help! Thank you
Hi,
I have 2 tables:
Project Number | Hours |
A745 | 100 |
B675 | 200 |
Project Number | Sub Project Number |
A745 | A745001 |
A745 | A745002 |
B675 | B675001 |
I am using Left Join to join table 2 with Table 1. After reload when I do the Sum(Hours), it shows values 400 bcz it is adding 100, 2 times. is there any way where I will get 300 which is correct. Please help.
I have made my qlick sense report.Now i want to share my report with other persons but i am not able to do so.I am working in qlick sense in whicj license is provided by company.when i am sharing the link of report with someone it is showing acess not provide to that person.I am not getting any option to publish my report.Can you please tell how can i share my report with other people?
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?
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 |
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
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!