Guten Tag zusammen,

wie ist es möglich den Prozentualen Anteil der verschiedenen Jahre einzeln zu berechnen. Derzeit berechnet sich die Prozentzahl ja über alle Balken in dem Balkendiagramm. Das Ziel ist es, jeden Balken zu einem Jahr allein zu berechnen (jedes Jahr hat 100%).

Es wäre wunderbar, wenn jemand weiter weiß!

Hi everyone,

I am currently working my way through
qlik-sdk with python and want to export an app.
When I call the function : webbrowser.open(f“{tenant}{app.export(NoData=False)}”) I get a 401 error because the script has no access to “api/v1/temp-contents/app-id”. Does anyone have an idea how I can provide a login or something similar ?

Best regards,

Pierre

Hi,

I have 2 tables:

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.

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

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?

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?