Welcome to Qlik Community

We keep getting disconnected errors due to timeout when trying to run the COPY INTO command to a delta table. Our cluster does not look to be the culprit as it has a server load distribution of about 40%. It appears that we should increase the ConnectionTimeout in our JDBC url, but this does not seem to be an option in the endpoint connection setup. 

https://kb.databricks.com/bi/query-timeout-jdbc-connector.html

Error: 
SQL_ERROR SqlState: HYT00 NativeError: 72 Message: [Simba][Hardy] (72) Query execution timeout expired.

Failed (retcode -1) to execute statement: 'COPY INTO `jde_dw`.`f1202` FROM(SELECT _c0 as `FLAID`, cast(_c1 as DECIMAL(38,10)) as `FLCTRY`, cast(_c2 as DECIMAL(38,10)) as `FLFY`, _c3 as `FLFQ`, _c4 as `FLLT`, _c5 as `FLSBL`, _c6 as `FLCO`, cast(_c7 as DECIMAL(38,10)) as `FLAPYC`, cast(_c8 as DECIMAL(38,10)) as `FLAN01`, cast(_c9 as DECIMAL(38,10)) as `FLAN02`, cast(_c10 as DECIMAL(38,10)) as `FLAN03`, cast(_c11 as DECIMAL(38,10)) as `FLAN04`, cast(_c12 as DECIMAL(38,10)) as `FLAN05`, cast(_c13 as DECIMAL(38,10)) as `FLAN06`, cast(_c14 as DECIMAL(38,10)) as `FLAN07`, cast(_c15 as DECIMAL(38,10)) as `FLAN08`, cast(_c16 as DECIMAL(38,10)) as `FLAN09`, cast(_c17 as DECIMAL(38,10)) as `FLAN10`, cast(_c18 as DECIMAL(38,10)) as `FLAN11`, cast(_c19 as DECIMAL(38,10)) as `FLAN12`, cast(_c20 as DECIMAL(38,10)) as `FLAN13`, cast(_c21 as DECIMAL(38,10)) as `FLAN14`, cast(_c22 as DECIMAL(38,10)) as `FLAPYN`, cast(_c23 as DECIMAL(38,10)) as `FLAWTD`, cast(_c24 as DECIMAL(38,10)) as `FLBORG`, cast(_c25 as DECIMAL(38,10)) as `FLPOU`, cast(_c26 as DECIMAL(38,10)) as `FLPC`, cast(_c27 as DECIMAL(38,10)) as `FLTKER`, cast(_c28 as DECIMAL(38,10)) as `FLBREQ`, cast(_c29 as DECIMAL(38,10)) as `FLBAPR`, _c30 as `FLMCU`, _c31 as `FLOBJ`, _c32 as `FLSUB`, cast(_c33 as DECIMAL(38,10)) as `FLNUMB`, cast(_c34 as DECIMAL(38,10)) as `FLADLM`, _c35 as `FLADM`, _c36 as `FLITAC`, cast(_c37 as DECIMAL(38,10)) as `FLADMP`, _c38 as `FLADSN`, _c39 as `FLDIR1`, cast(_c40 as INT) as `FLDSD`, _c41 as `FLUSER`, cast(_c42 as INT) as `FLLCT`, _c43 as `FLPID`, _c44 as `FLSBLT`, _c45 as `FLCRCD`, cast(_c46 as INT) as `FLUPMJ`, _c47 as `FLJOBN`, cast(_c48 as DECIMAL(38,10)) as `FLUPMT`, _c49 as `FLCHCD`, _c50 as `FLDPCF`, cast(_c51 as DECIMAL(38,10)) as `FLCBXR`, cast(_c52 as TIMESTAMP) as `syncDateTime`, _c53 as `syncOperation`, _c54 as `syncFlag` from 'abfss://prep@pdcolaserdwhnsg2heusdl.dfs.core.windows.net') FILEFORMAT = CSV FILES = ('/jdetemp/JDE_DW_DL_PD_Large/5/LOAD00000032.csv.gz') FORMAT_OPTIONS('nullValue' = 'attrep_null', 'multiLine'='true') COPY_OPTIONS('force' = 'true')'

Hello,

I'd like to modify the employee service length measure below, so that employee's service length who changed department or changed status and appear multiple times in the employee hiring and leaving data gets calculated correctly.  

At the moment, as shown in the table below, the above formula restarts the tenure calculation when employee change the status or change departments even though that person was all the time with the company.  I'd like it to calculate the cumulative tenure length even after the change in departments.

How can I change the formula above to show the cumulative tenure even after the department change? 

I thought cumulative function like rangesum may be a solution, but I am not sure how I can incorporate it in the measure formula above.  

Thanks for your help.

Hi 

I am calculating employee service length which respects time dimension, so that if past date is selected in a chart, the service length is reduced accordingly for the length at that point in time.  I am currently dividing the number of days at a point in time minus hiring date by 365 in order to convert the number of days into number of years in decimal, but as the number of days in a year varies between year to year with leap year having 366 days and normal years having 365, the calculation below is not correct.  Please could you let me know an equivalent function with Yearfrac in Excel so that I can accurately calculate the employee service years? 

Thank a lot for your help.

Hello,

I'd like to construct a direct method cash flow statement in Qlik Sense from the information of the opposite side of the bank journal entries in the double entry bookkeeping download from SAP.  Specifically, I have over million rows of data of all the journal entries, and I'd like to extract only from the journal entries (document numbers) which represents opposite side of the bank GL, so as to identify where the money was paid to (i.e., vendor codes) or where the money was received from (i.e., customer codes).  

I am relatively new to Qlik Sense and I am not familiar with many formula functions yet, so I'd appreciate it if you could let me know what kind of formula syntax will enable me to achieve this effect (i.e., listing out yellow highlighted entries). 

Thank you & best regards,

Hi,

How can i use one expression inside another expression in Set expression. I want to count of model numbers where average rating of a model number should be greater than 3? We have multiple rating for one model number, we take average of all those rating. Please let me know if need any other detail.

Dear Community,

I am trying to produce a stacked bar chart with a cumulative sum across dates with the customers being the groups :

This is the base data :

In Excel obtaining the underlying table is easily done with pivot running sum on "Booking Year Month" :

However I can't find a use case in the community that does the trick.

Below is the nearest solution I found, it cumulates when there is a data at the intersection of dimensions but it doesn't persist the cumulated amount across the data columns.

Thanks for any help,

Stevan

Hello,

I've created a pivot chart visualization of headcount where the row header is month dimension and the column header is year dimension.  I want to be able to select any combination of month-year to be able to get the names of employees at any point, by using the pivot as a filter slicer.  However, at the moment, I can only select a row at a time, and not a cell (of intersection of row and column).  How can I change the setting so that I can select a cell and not just a row in a pivot table?  

Thank you very much for your help.

Hi  Team,

hope you are doing good.

I have a query below

How change color of values in a list/filter on selection of other list/filter in qliksense.

Example

When i select India  Then Delhi and Pune in Green Color,

when I select US then Washington in Blue color

when i slect India and US . then Delhi and Pune in green  and Washington in Blue.

Note : we need to achieve this in Qliksense.

Thanks

Sunil

Hello. How do I change the language of qlik Sense? 

I uninstalled it and installed it again but it did not give me the option to choose another language

thanks!