Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,935 online

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

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

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion board and documents related to Qlik Associative Big Data Index.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.


WEBINAR SERIES: THE DX FILES

When disruption is nonstop, how do you compete – and thrive? Digital Transformation is a must, and data is at the heart of it. To pull ahead of the pack, stay in front of the trends, and keep pushing innovation further, you have to consistently reinvent your business – fast – with a modern approach to data. When it comes to Digital Transformation, the truth isn’t out there – it’s in here. Join us July 30 – August 28, 2019, for 5 tracks of insight-packed webinars.

Recent Discussions

  • Qlik Sense Data Connectivity

    Tempdb

    Hola, Soy nuevo en el USO de Qlik y Ultimamente tengo un problema con la Base de Datos y no se si tiene que ver con Qlik o no. Necesito saberlo p... Show More

    Hola, 

    Soy nuevo en el USO de Qlik y Ultimamente tengo un problema con la Base de Datos y no se si tiene que ver con Qlik o no. Necesito saberlo para intentar tirar por una vía o por otra a la hora de solucionar el problema. A ver si alguien me PUEDE Ayudar a solucionarlo.

    Una vez a la semana en La Tabla tempdb de la BASE DE DATOS Donde está alojado Qlik y el ERP de la Empresa se llena de Manera considerable ralentizando el Funcionamiento de la Misma y del ERP. Queria sable si el Llenado Masivo de tempdb se Dębe al USO de Qlik O Este no utilizació esa tabla para nada.

     

    Gracias, un saludo.

    Show Less
  • New to Qlik Sense

    How to merge expressions

    How can I merge the following two expressions into one?  Thanks  you!sum({<T3.DateC= {">=$(=AddMonths(Max(T3.DateC), -11))"}>})Coun... Show More

    How can I merge the following two expressions into one?  Thanks  you!

    sum({<T3.DateC= {">=$(=AddMonths(Max(T3.DateC), -11))"}>})

    Count({<[T3.Amount]={">=$(V1)<=$(V2)"}>}distinct[T3.VendorID])

    Show Less
  • New to Qlik Sense

    FirstSortedValue()

    I have a situation where I have Vehicle related data in a table. In the table, among other fields, I have the Registration, Transaction Date and Amoun... Show More

    I have a situation where I have Vehicle related data in a table. In the table, among other fields, I have the Registration, Transaction Date and Amount. Once per month there is a Vehicle Lease Transaction around the 25th of the month. Although we are 2019-07-16, the last transaction was on 2019-06-25. Over time the lease amount can increase or decrease. I need to show only the latest Lease Amount. 

    Among many tried expressions, this one is the closest, but still not correct. I have tried removing the [-] before the [Transaction Date] but this does not appear to make a difference. 

    Aggr(firstsortedvalue({<DateType={'Daily_Data'},tx_Summary={'LEASE'}>} Amount, -[Transaction Date]), [Registration Number])

    Please can you show me where am I going wrong with this? Thanks. 

     

    1st Sorted Value.JPG

    Show Less
  • Qlik Sense Data Connectivity

    Substraction of 2 expressions

    Hi!I would like to calculate the balance of enterprises which is the substraction of the new and the closed enterprises. Here is the2 expressions for ... Show More

    Hi!

    I would like to calculate the balance of enterprises which is the substraction of the new and the closed enterprises. Here is the2 expressions for the new and the closed enterprises:

    =Count(distinct {< [Municipality_Unit-municipality_name]= {'ΧΕΡΣΟΝΗΣΟΥ'}, [mitroo-03072017.Registration_Number] *=E({<[mitroo-03072017.Date] ={"$(=Maxstring({<[mitroo-03072017.Registration_Number]>}[mitroo-03072017.Date]))"}>}) >} [mitroo-03072017.Registration_Number])


    =Count(distinct {< [Municipality_Unit-municipality_name]= {'ΧΕΡΣΟΝΗΣΟΥ'},
    [mitroo-03072017.Registration_Number] *= E({<[mitroo-03072017.Date] ={"$(=MINstring({<[mitroo-03072017.Registration_Number]>}[mitroo-03072017.Date]))"}>})
    >} [mitroo-03072017.Registration_Number])

     

    I tried to put a minus between this 2 expressions to do the difference but it doesn't work. Any idea?

    Thank you!

    Show Less
  • New to Qlik Sense

    Regarding Vizlib Extension KPI for Designer

    Hi Team, Does using the Vizlib KPI extension for executive designs , will it decrease the performance or using of the Vizlib extension normally w... Show More

    Hi Team, 

    Does using the Vizlib KPI extension for executive designs , will it decrease the performance or using of the Vizlib extension normally will it decrease the performance?

    Kindly help me regarding this.  

    Show Less
  • QlikView Scripting

    Field Not Found Error

    Hi, I keep getting the 'Field Not Found Error - Field ShipperCountryCode Not Found' when I run the below script. I have used the If(len) formula ... Show More

    Hi, I keep getting the 'Field Not Found Error - Field ShipperCountryCode Not Found' when I run the below script. I have used the If(len) formula as I wish to replace the data in a field if another field contains a value. Any ideas?

    //===SHIPPING ORDER===

    [Shipping Order Number] as MatrixSO,
    [Port of Loading] as PoL,
    [Port of Discharge] as PoD,
    date(floor([Expected Ship Date])) as ExpShipDate,
    Upper([Service Level]) as ServiceLevel,
    [Path Type] as MatrixPathType,
    INCOTerms,

    //===SHIPPER===
    [Shipper Name] as ShipperName,
    [Shipper Alias] as ShipperAlias,
    //[Shipper Country Name] as ShipperCountry,
    //[Shipper Country Code] as ShipperCountryCode,
    //[Shipper City] as ShipperCity,
    [Shipper State] as ShipperState,
    //[Shipper Postal Code] as ShipperPostalCode,
    [Shipper Region Name] as ShipperRegion,
    [Pick Up Location Name],
    [Pick Up Location Alias],
    [Pick Up Location Country Name],
    [Pick Up Location Country Code],
    [Pick Up Location City],
    [Pick Up Location State],
    [Pick Up Location Postal Code],
    [Pickup Location Region Name],

    // For each country, the tradelane identifier has to be entered in the input file
    applymap('Tradelane_map', ShipperCountryCode, 'n/a')
    & ' to ' &
    applymap('Tradelane_map', [Delivery Location Country Code], 'n/a') as Tradelane,



    // For non-UK origins and destinations, the rates are stored without any characters (eg. not '5469 VV' but '5469').
    // In order to define the correct %RateID (see below), we need to purge the shipper and delivery postal codes
    // outside UK from any non-numeric characters
    IF(ShipperCountryCode = 'GBR',
    ShipperPostalCode,
    KeepChar(ShipperPostalCode, '0123456789')) as ShipperPostalCode_purged,

    IF([Delivery Location Country Code] = 'GBR',
    [Delivery Location Postal Code],
    KeepChar([Delivery Location Postal Code], '0123456789')) as DeliveryPostalCode_purged,


    if(len([Pick Up Location Country Name])>0,[Pick Up Location Country Name], [Shipper Country Name]) as ShipperCountry,
    if(len([Pick Up Location Country Code])>0,[Pick Up Location Country Code], [Shipper Country Code]) as ShipperCountryCode,
    if(len([Pick Up Location City])>0, [Pick Up Location City], [Shipper City]) as ShipperCity,
    if(len([Pick Up Location Postal Code])>0, [Pick Up Location Postal Code], [Shipper Postal Code]) as ShipperPostalCode




    FROM
    [Input\Shipping_Order_Extract-week 27.xlsx.xls]
    (
    biff, embedded labels, table is Results$);

    Show Less
  • Qlik Sense Deployment & Management

    Automatic License Deallocation based on inactivity?

    Looking for a way to automatically deallocate users' licenses after a certain number of days (based on "last used" column in QMC).Does anyone know if ... Show More

    Looking for a way to automatically deallocate users' licenses after a certain number of days (based on "last used" column in QMC).

    Does anyone know if this is possible?

    Show Less
  • New to QlikView

    Creating a table to exclude data out a single field based on multiple fields

    Hi, I have some experience with Qlikview, I just need some help with the followingI have table of product data ( Tabel 1) , I  have created ... Show More

    Hi, 

    I have some experience with Qlikview, I just need some help with the following

    I have table of product data ( Tabel 1) , I  have created a table (Table 2 ) that links to that (Table 1) based on  field ATC and I need to perform certain exclusions based on requirements in the second table. I have attached a small set of the data with examples of the tables below. (There are multiple disease in the attached document, if it was only one disease then i could use set analysis, but since there are over 200 diseases in the complete dataset I don't think set analysis would work? Maybe I am thinking about it all wrong)

    Thanks in advance Atila

    Table 1

     Unique Identifier         ATCPresentation    
    HYPERTENSION:883817007MEDSOL CARDIOPLEGIC INDUCTIONBBLOOD AND BLOOD FORMING ORGANSB05BLOOD SUBSTITUTES AND PERFUSION SOLUTIONSB05XI.V. SOLUTION ADDITIVESB05XAElectrolyte solutionsB05XA01INF1Y Y
    HYPERTENSION:894290002MEDSOL CARDIOPLEGIC MAINTBBLOOD AND BLOOD FORMING ORGANSB05BLOOD SUBSTITUTES AND PERFUSION SOLUTIONSB05XI.V. SOLUTION ADDITIVESB05XAElectrolyte solutionsB05XA01INF1Y Y
    HYPERTENSION:718369001NEPRESOL POWDER (SECT 21)CCARDIOVASCULAR SYSTEMC02ANTIHYPERTENSIVESC02DARTERIOLAR SMOOTH MUSCLE AGENTS ACTING ONC02DBHydrazinophthalazine derivativesC02DB02INJ5Y Y
    HYPERTENSION:732052017HYPOTONECCARDIOVASCULAR SYSTEMC02ANTIHYPERTENSIVESC02AANTIADRENERGIC AGENTS CENTRALLY ACTINGC02ABMethyldopaC02AB01TAB500Y Y
    HYPERTENSION:761400028SANDOZ HYDRALAZINECCARDIOVASCULAR SYSTEMC02ANTIHYPERTENSIVESC02DARTERIOLAR SMOOTH MUSCLE AGENTS ACTING ONC02DBHydrazinophthalazine derivativesC02DB02TAB500Y Y
    HYPERTENSION:785962026MYLAN METHYLDOPACCARDIOVASCULAR SYSTEMC02ANTIHYPERTENSIVESC02AANTIADRENERGIC AGENTS CENTRALLY ACTINGC02ABMethyldopaC02AB01TAB500Y Y

     

    Table 2

    DiseaseATCPresentation Exclusion
    HYPERTENSION:B05XA01INF,INJ,SUS,SYR
    HYPERTENSION:C02AB01INF,INJ,SUS,SYR
    HYPERTENSION:C02CA04INF,INJ,SUS,SYR
    HYPERTENSION:C02DB02INF,INJ,SUS,SYR
    HYPERTENSION:C03AA03INF,INJ,SUS,SYR
    HYPERTENSION:C03BA11INF,INJ,SUS,SYR
    HYPERTENSION:C03CA01INF,INJ,SUS,SYR
    HYPERTENSION:C03DA01INF,INJ,SUS,SYR
    HYPERTENSION:C08CA01INF,INJ,SUS,SYR
    HYPERTENSION:C08CA05INF,INJ,SUS,SYR
    HYPERTENSION:C08DA01INF,INJ,SUS,SYR
    HYPERTENSION:C09AA01INF,INJ,SUS,SYR
    HYPERTENSION:C09AA02INF,INJ,SUS,SYR
    HYPERTENSION:C09AA03INF,INJ,SUS,SYR
    HYPERTENSION:C09AA04INF,INJ,SUS,SYR
    HYPERTENSION:C09BA03INF,INJ,SUS,SYR
    Show Less
  • New to Qlik Sense

    Button which sets more than one dimension

    Hi,I searched google and the forums as well, but didn't find good directions how I can set more than one dimensions (sometimes I need to set up to 4 d... Show More

    Hi,

    I searched google and the forums as well, but didn't find good directions how I can set more than one dimensions (sometimes I need to set up to 4 dimensions) with a button. I am currently can switch only one dimension. Even if I use the second action and try to set another dimension (which would bring me up to 2 dimensions) this doesn't work but QlikSense only sets the second action then.

     

    Can you give me some directions how to do this?

    Show Less
  • New to Qlik Sense

    Qlik Sense Horizontal Axis Sorting on Bar Chart

    I am trying to create a vertical stacked bar chart, where the only dimension selected in the chart is a datetime field. The Horizontal axis is not bei... Show More

    I am trying to create a vertical stacked bar chart, where the only dimension selected in the chart is a datetime field. The Horizontal axis is not being sorted by this variable FIRST. It is being sorted by an unspecified field, the server name, before it does the AVERAGE aggregation by the datetime field.

    I have not figured out how to force the sorting by the datetime field, either by expression, numerically or alphabetically and combinations thereof.

    This should be simple, right?

    Annotation 2019-07-18 171041.jpg

    Yellow is DEV server, Red is PRD server and Green is UAT server. Datetimes in green are not represented in yellow are in the green area. The red datetime is in neither the yellow or green. I believe the average aggregation is working correctly in the yellow area when there is data for both DEV and UAT servers for that datetime.

    Ideas?

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.