Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
3,413 online
Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY

Welcome to Qlik Community

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

QlikWorld 2022

This year’s go-to data event is full of inspiring speakers, informative sessions, ideas for up-leveling your data integration and analytics.

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.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

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.

Qlik Academic Program

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

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    App Development

    Table Entries Disappearing During Export

    Hello, I'm having an issue with some data tables in Qlik Sense SaaS.  When users go to export tables to Excel, entries are going missing.  Every entry... Show More

    Hello, I'm having an issue with some data tables in Qlik Sense SaaS.  When users go to export tables to Excel, entries are going missing.  Every entry has a unique identifier, so I'm not sure why data would disappear during export.  Also, this is the first time we're having this issue even though we've been using these tables for months.  This problem goes away when I try to recreate the situation with test data, otherwise I would include an example.  

    Any advice on how to identify the field or table that's causing this would be appreciated.

    Show Less
  • forum

    New to Qlik Sense

    QLIK SENSE AutoNumber reset to 1 if condition met

    Hi All I have a data load that uses AutoNumber to count the numbers of days of sickness. What I need it to do is only count the consecutive days and t... Show More

    Hi All

    I have a data load that uses AutoNumber to count the numbers of days of sickness. What I need it to do is only count the consecutive days and then reset. So if a person returns to work for a regular shift then goes back on sick leave I need the AutoNumber process to restart at 1. 

    Maybe the AutoNumber is not the best approach but I cannot seem to work it out. 

    if(Wildmatch([Pay_Type], 'Sickness'), AutoNumber(recno(),[EMP_Code] & [Pay_Type])) as Occurrence,

    This is the data and the last field is the result of the expression above. Data Row 19 below 25/01/2022 shows Occurrence 7 but I need to to show as 1 due to the person working  5 regular/transfer shifts (17th to 24th) after previous 5 days of sickness occurrence. 

    LOAD * INLINE
    [

    Date,EMP Code,Pay Type,Type,JOB TYPE,Hours Worked,Hours Not Worked,Sickness Occurrence
    29/01/2022,S29536,Basic,Transfer,MNGRS,3,-,-
    29/01/2022,S29536,Basic,Transfer,MNGRS,5,-,-
    02/01/2022,S30299,Sickness,-,SALES,-,6,1
    03/01/2022,S30299,Covid,-,SALES,-,8,-
    06/01/2022,S30299,Covid,-,SALES,-,8,-
    07/01/2022,S30299,Covid,-,SALES,-,8,-
    08/01/2022,S30299,Covid,-,SALES,-,8,-
    09/01/2022,S30299,Covid,-,SALES,-,8,-
    10/01/2022,S30299,Sickness,-,SALES,8,8,2
    13/01/2022,S30299,Sickness,-,SALES,8,8,3
    14/01/2022,S30299,Sickness,-,SALES,-,8,4
    15/01/2022,S30299,Sickness,-,SALES,-,8,5
    16/01/2022,S30299,Sickness,-,SALES,-,8,6
    17/01/2022,S30299,Basic,Regular,SALES,6,-,-
    21/01/2022,S30299,Basic,Transfer,SALES,8,-,-
    22/01/2022,S30299,Basic,Transfer,SALES,5.5,-,-
    23/01/2022,S30299,Basic,Regular,SALES,6,-,-
    24/01/2022,S30299,Basic,Regular,SALES,5.5,-,-
    25/01/2022,S30299,Sickness,-,SALES,-,8,7
    26/01/2022,S30299,Sickness,-,SALES,-,8,8
    27/01/2022,S30299,Sickness,-,SALES,-,8,9
    28/01/2022,S30299,Sickness,-,SALES,-,8,10
    31/01/2022,S30299,Basic,Break,SALES,0.5,-,-
    31/01/2022,S30299,Basic,Regular,SALES,2.5,-,-
    31/01/2022,S30299,Basic,Regular,SALES,5.5,-,-
    02/01/2022,S49649,Basic,Regular,SALES,6,-,-
    05/01/2022,S49649,Basic,Regular,SALES,5,-,-
    08/01/2022,S49649,Basic,Regular,SALES,5,-,-
    09/01/2022,S49649,Sickness,-,SALES,-,6,1
    13/01/2022,S49649,Sickness,-,SALES,-,6,2
    14/01/2022,S49649,Annual Leave,-,SALES,-,6,-
    16/01/2022,S49649,Annual Leave,-,SALES,-,6,-
    20/01/2022,S49649,Annual Leave,-,SALES,-,4,-
    21/01/2022,S49649,Sickness,-,SALES,-,6,3
    23/01/2022,S49649,Sickness,-,SALES,-,6,4
    24/01/2022,S49649,Sickness,-,SALES,-,6,5
    29/01/2022,S49649,Basic,Regular,SALES,4,-,-

    ](delimiter is ',');

     

    Many thanks in advance

    Show Less
  • forum

    QlikView App Dev

    Button actions not working from AccessPoint

    Hi, Can some one suggest recommended settings/things to check to run QV11 report from access point. One of the report users complained about button fu... Show More

    Hi, Can some one suggest recommended settings/things to check to run QV11 report from access point. One of the report users complained about button functionality not working (all buttons in report). Even simple button action for setting a variable value is not working when report is opened via Access Point. We tried multiple things and no luck so far. The same functionality works fine to other users.


    Here are some of the changes we did, appreciate any help in this regard, Thanks in advance!

    Installed IE plug-in, checked IE compatibility mode,enabled certain internet options (activex objects), chose "Give System Access to Module Script"(Ctl+Shft+M) option (as some buttons have macros).


    Note: this user has installed QV Desktop locally for other purpose

    Show Less
  • forum

    New to Qlik Sense

    función aggr / function aggr

    Hola, tengo un problema al aplicar la funcion aggr, desde una tabla tengo pedidos y posiciones de pedido para un material tabla1, en otra tabla tengo ... Show More

    Hola, tengo un problema al aplicar la funcion aggr,

    desde una tabla tengo pedidos y posiciones de pedido para un material tabla1, en otra tabla tengo el material y cantidad de piezas por paquete tabla2 ,

    tabla1

    Pedido pos pedido cant pedido material
    1 1 12 v01
    1 2 4 v01
    1 3 3 v05
    2 1 5 v04
    2 2 23 v01

     

    tabla2

    material piezas
    v01 45
    v01 45
    v01 30
    v04 60
    v04 60
    v05 60

     

    ocupo la funcion aggr para contar los paquetes de material es decir la cantidad de veces que tengo el material en mi tabla2, pero produce diferencias y agregar una columna de cantidad de paquetes disponibles debería resultar como la tabla3,

    alguien sabe como lo puedo solucionar o otra alternativa para realizar lo mismo?

    los resultados no son los correctos, las tablas estan unidas por el campo material

    tabla3

    Pedido pos pedido cant pedido material paquetes disponibles
    1 1 12 v01 3
    1 2 4 v01 3
    1 3 3 v05 1
    2 1 5 v04 2
    2 2 23 v01 3

     

    Hello, I have a problem when applying the aggr function,
    
    from a table I have orders and order items for a material, and in another table I have the material,
    
    Table 1
    Pedido pos pedido cant pedido material
    1 1 12 v01
    1 2 4 v01
    1 3 3 v05
    2 1 5 v04
    2 2 23 v01
    table 2
    material piezas
    v01 45
    v01 45
    v01 30
    v04 60
    v04 60
    v05

    60

    I use the aggr function to count the material packages, that is, the number of times I have the material in my table2, but it produces differences and adding a column with the number of available packages should result in table3,
    
    Does anyone know how I can solve it or another alternative to do the same?
    
    the results are not correct, the tables are joined by the material field
    
    table3
    Pedido pos pedido cant pedido material paquetes disponibles
    1 1 12 v01 3
    1 2 4 v01 3
    1 3 3 v05 1
    2 1 5 v04 2
    2 2 23 v01 3
     
     

     

    Show Less
  • forum

    GeoAnalytics

    GEOOPS-402 Error after Migrating from GeoAnalytics

    I'm in the process of migrating some of our apps from Qlik Sense to Qlik Sense SaaS.  As a result I need to convert some Easting/Northing points, ever... Show More

    I'm in the process of migrating some of our apps from Qlik Sense to Qlik Sense SaaS.  As a result I need to convert some Easting/Northing points, everything works well using the GeoAnalytics Connector.  However when I try this in SaaS it gives me a GEOOPS-402 error

    CHansford_0-1619510228042.png

    I tried changing to INTABLE, but that resulted in a 'GEOOPS-401 : Unknown column requested: SITE_ID'

     

    Original Loadscript (GeoAnalytics Connector)

    GeoPreload:

    LOAD

        SITE_ID,

        EASTING,

        NORTHING

    FROM [lib://Site Table - April 26, 2021.xlsx]

    (ooxml, embedded labels, table is Sites)

     

     

     

    LIB CONNECT TO 'QGA';

     

    /* Generated by GeoAnalytics for operation Load ---------------------- */

    [_inlineMap_]:

    mapping LOAD * inline [

    _char_, _utf_

    "'", '\u0027'

    '"', '\u0022'

    "[", '\u005b'

    "/", '\u002f'

    "*", '\u002a'

    ";", '\u003b'

    "}", '\u007d'

    "{", '\u007b'

    "`", '\u0060'

    "´", '\u00b4'

    "              ", '\u0009'

    ];

     

    IF FieldNumber('SITE_ID', 'GeoPreload') = 0 THEN

                    call InvalidInlineData('The field SITE_ID in GeoPreload is not available');

    END IF

    IF FieldNumber('NORTHING', 'GeoPreload') = 0 THEN

                    call InvalidInlineData('The field NORTHING in GeoPreload is not available');

    END IF

    IF FieldNumber('EASTING', 'GeoPreload') = 0 THEN

                    call InvalidInlineData('The field EASTING in GeoPreload is not available');

    END IF

    Let [GeoDatasetInlineTable] = 'SITE_ID' & Chr(9) & 'NORTHING' & Chr(9) & 'EASTING';

    Let numRows = NoOfRows('GeoPreload');

    Let chunkSize = 1000;

    Let chunks = numRows/chunkSize;

    For n = 0 to chunks

                    Let chunkText = '';

                    Let chunk = n*chunkSize;

                    For i = 0 To chunkSize-1

                                    Let row = '';

                                    Let rowNr = chunk+i;

                                    Exit for when rowNr >= numRows;

                                    For Each f In 'SITE_ID', 'NORTHING', 'EASTING'

                                                    row = row & Chr(9) & MapSubString('_inlineMap_', Peek('$(f)', $(rowNr), 'GeoPreload'));

                                    Next

                                    chunkText = chunkText & Chr(10) & Mid('$(row)', 2);

                    Next

                    [GeoDatasetInlineTable] = [GeoDatasetInlineTable] & chunkText;

    Next

    chunkText=''

     

     

    [GeoDataset]:

    SQL SELECT [SITE_ID], [GeoDataset_Geometry] FROM Load(dataset='GeoDataset')

    DATASOURCE GeoDataset INLINE tableName='GeoPreload', tableFields='SITE_ID,NORTHING,EASTING', geometryType='POINTLATLON', loadDistinct='NO', suffix='', crs='EPSG:27700' {$(GeoDatasetInlineTable)}

    ;

    tag field [SITE_ID] with '$primarykey';

    tag field [GeoDataset_Geometry] with '$geopoint';

    tag field [SITE_ID] with '$geoname';

    tag field [GeoDataset_Geometry] with '$relates_SITE_ID';

    tag field [SITE_ID] with '$relates_GeoDataset_Geometry';

     

    [GeoDatasetInlineTable] = '';

     

    /* End GeoAnalytics operation Load ----------------------------------- */

     

     

    I believe I have followed the Migrating from GeoAnalytics Connector to Qlik Sense GeoOperations to get the following GeoOperations Script.

     

    [GeoDataset]:

    Load * Extension GeoOperations.ScriptEval('

    SELECT [SITE_ID], [GeoDataset_Geometry] FROM Load(dataset="GeoDataset")

    DATASOURCE GeoDataset INLINE tableName="GeoPreload", tableFields="GeoPreload.SITE_ID,GeoPreload.NORTHING,GeoPreload.EASTING", geometryType="POINTLATLON", loadDistinct="NO", suffix="", crs="EPSG:27700" {$(GeoDatasetInlineTable)}

    ');

     

    Any assistance would be gratefully received as I have a large number of this kind of conversion to do.

    If only we could use Eastings and Northings directly in Qlik without having to convert to Lat/Long

    Regards and Stay safe.

    CHris

    Show Less
  • forum

    New to Qlik Sense

    Excluding dates from pivot table

    I've created a pivot table and I do not want the columns with weekend dates to display. How would I remove them? ( I don't care if there is data on th... Show More

    I've created a pivot table and I do not want the columns with weekend dates to display. How would I remove them? ( I don't care if there is data on the weekend dates so I don't want them to show)

    -thank you

    Show Less
  • forum

    QlikView App Dev

    String extraction

    Hi, I am trying to extract the code which starts with 'PA9' from a string in column OTHERS as below and make a new column/field for the code.   OTHERS... Show More

    Hi,

    I am trying to extract the code which starts with 'PA9' from a string in column OTHERS as below and make a new column/field for the code.

     

    OTHERS

    ~PA9235 testing for qlik

    PA92222 testing

    test123~PA92325~test

     

    due to the unfixed code length and location, i am unable to use subfield() for this.

     

    Is there any other way for this?

     

    Show Less
  • forum

    QlikView App Dev

    Layout issue dates in selection

    As shown in the photo, the dates in the "current selections" are shown to me as a number and not in date format (picture 1), it is possible to put the... Show More

    As shown in the photo, the dates in the "current selections" are shown to me as a number and not in date format (picture 1), it is possible to put them in date format as I see them when I go to select them (picture 2)

    Show Less
  • forum

    QlikView App Dev

    Loading Multiple Excel Sheets Dynamically

    Hi Team, i have 3 excel files  data data1 data2 in each excel file 4 spread sheets   note : in manual  load into data   Qlikview  12 qvds in my  requi... Show More

    Hi Team,

    i have 3 excel files 

    data

    data1

    data2

    in each excel file 4 spread sheets 

     note : in manual  load into data   Qlikview  12 qvds

    in my  requirement in future multiple sheets getting that's reason i want  load data  into  dynamiclly   

    in   3 excel files different filed names 

    below attachment's

     

    Thanks ,

    Rajasekhar Reddy 

     

    Show Less
  • forum

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