Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.
Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources
Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.
Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.
Participate in Qlik Technical Previews, submit ideas, and review documentation.
Learn about upcoming Qlik related events, webinars and local meetups.
Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.
Get started on Qlik Community, find How-To documents, and join general non-product related discussions.
Hear directly from Qlik employees in our ten unique blogs.
Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.
Access Support programs, Knowledge Base, Updates blog, and Release Notes.
Here you will find a list of all the Qlik Community forums.
How did Gordon Food Service, Breuninger and other customers move enterprise-wide data to the cloud – and increase their time to value? By automating data integration.
In this on-demand webinar, you’ll hear from Google and Qlik, discussing how a data integration platform enables real-time data analytics pipelines to the cloud – unlocking massive amounts of fresh data and ensuring its continuous availability enterprise-wide.
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.
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://email@example.com') FILEFORMAT = CSV FILES = ('/jdetemp/JDE_DW_DL_PD_Large/5/LOAD00000032.csv.gz') FORMAT_OPTIONS('nullValue' = 'attrep_null', 'multiLine'='true') COPY_OPTIONS('force' = 'true')'
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.
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.
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,
I don´t know how solve this:
mi desired table:
ideas? thank a lot
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.
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,
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.
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.
|List 1||List 2|
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.
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
Our featured member for September 2021
Learn about what's new across all of the products in our growing Qlik product portfolio.
Hear from the Qlik Community team about the latest platform enhancements and other topics.
Important and useful support information about end-of-product support, new service releases, and general support topics.
German speaking - This group makes it easier to collaborate in your local language.
This group for Brazil users. All discussions are in Portuguese.
This is a open Group for the Public Sector
These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.
You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.
Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.