Qlik Community

Ask a Question

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,822 online
Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources. Prep for the big move: READ DETAILS

Data Analytics

Forums for Qlik Data Analytics solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

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.

About

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • No Boards Found
  • forum

    Qlik Replicate

    Microsoft Azure Databricks Delta ConnectionTimeout

    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 culp... Show More

    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')'

    Show Less
  • forum

    New to Qlik Sense

    Cumulative tenure taking account of department changes

    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 app... Show More

    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.  

    Newbie7_0-1632631279027.png

    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.

     

    Newbie7_1-1632631552646.png

    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.

    Show Less
  • forum

    New to Qlik Sense

    Yearfrac function in Qlik Sense

    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 ... Show More

    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? 

    Newbie7_0-1632628542300.png

    Thank a lot for your help.

     

    Show Less
  • forum

    New to Qlik Sense

    Taking opposite side of double entry in bank journal entries

    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... Show More

    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).  

     

    Newbie7_1-1632620268660.png

    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,

     

     

    Show Less
  • forum

    QlikView App Dev

    cross table

    hi everyone,I don´t know how solve this: mi table:DATECARQuant202107AUDI4202107HONDA9202107FORD129202108AUDI3202108HONDA7202108FORD116 mi desired tabl... Show More

    hi everyone,

    I don´t know how solve this:

     

    mi table:

    DATECARQuant
    202107AUDI4
    202107HONDA9
    202107FORD129
    202108AUDI3
    202108HONDA7
    202108FORD116

     

    mi desired table:

    DATEAUDIHONDAFORD
    20210748129
    20210837119

     

    ideas? thank a lot

    Show Less
  • forum

    App Development

    How to use one expression inside another expression in Set Expression

    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 s... Show More

    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.

    Show Less
  • forum

    App Development

    Running sum in a Stacked Bar Chart

    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 ... Show More

    Dear Community,

     

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

     

    Stevan_Klaas_4-1632058474848.png

     

    This is the base data :

    Stevan_Klaas_1-1632057819680.png

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

    Stevan_Klaas_5-1632058518618.png

     

    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.

    Stevan_Klaas_3-1632058078412.png

    Thanks for any help,

    Stevan

     

     

    Show Less
  • forum

    New to Qlik Sense

    Selecting a single cell in a pivot chart rather than a row

    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 t... Show More

    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.

    Show Less
  • forum

    New to Qlik Sense

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

    Hi  Team, hope you are doing good.I have a query belowHow change color of values in a list/filter on selection of other list/filter in qliksense.Examp... Show More

    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

    List 1List 2
    IndiaDelhi
    IndiaPune
    UsWashington
    Srilanka Colombo

     

    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

    Show Less
  • forum

    New to Qlik Sense

    Change the language of Qlik sense

    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 languag... Show More

    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!

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

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.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region