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?

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 :

1. QLik CLI : Is it possible and how ?
2. QLik Data Transfert : It can only move raw data from data sources and transform them to qvd ? But it is possible to move transformed qvd ?
3. API Request ?

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.