Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,678 online

Find the forums for your Qlik data analytics products to ask a question, start a discussion, or review documentation.

Find the forums for your Qlik Data Integration products to ask a question, start a discussion, or review documentation.

This forum will provide you with event highlights and related content to get you energized and ready for Qlik’s largest customer and partner event of the year.

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.

Discussion Boards and Documents for Qlik Services.

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 nine unique blogs. Check out the new Customer Success Blog!

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

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

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.

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

Recent Discussions

  • Qlik Sense App Development

    positive, negative and equal values in qliksense table

    Hi,I have two fields in qliksense table those are outstanding amount and original amount,  some values are common in these two fields, my client given... Show More

    Hi,

    I have two fields in qliksense table those are outstanding amount and original amount,  some values are common in these two fields, my client given some conditions for these two fields, first one :

     1. Original Amount  = Outstanding  Amount (Positive Amount)
    2. If Outstanding  Amount is Less than Original Amount (Positive amount)                                                                                            3. If Outstanding  Amount  is greater than or Equal To Original Amount (Negative amount)

    all these conditions should come in qliksense table order wise, how can i do this?

    Thanks

     

    Show Less
  • QlikView Scripting

    Table Not Found Error Issue

    Hi All, We recently moved our data to run on a different Disk Drive than the Qlikview application to help run the Servers more efficiently. Now when I... Show More

    Hi All,

     

    We recently moved our data to run on a different Disk Drive than the Qlikview application to help run the Servers more efficiently.

     

    Now when I try to reload the data I keep hitting a table not found error for the below scripts.

     

    Error:

    Table Not Found Error

    Table 'Assets' not found

    Store Assets into \\MyServerName\E$\Data-Lite\S1-Assets.qvd (qvd)

     

    Essentially just loops through the matching files from certain filepath.

    I can access files no problem and write no problem, but this script isn't happy with the change of location.

     

     

    LET vPartFileName = '\API_AssetDetails*.csv';		//evaluate identity of source excel document. Note wildcard in place of date.
    
    set vFilesFoundCounter = 0;										// add v0.5
    
    FOR EACH File IN filelist ('$(vFolder)' & '$(vPartFileName)')		//loop through each file from source data folder. Filelist syntax generates, in this instance, excel\Asset Details*.xlsx
    
    LET vFilename = subfield('$(File)', '\', -1);							// determines actual filename. Based on string of file (excel\Asset Details*.xlsx). Looks for part of string 1 from the right, delimited by '\'.
    	
    Assets:
    NoConcatenate
    LOAD 
    	FileMonthStartDate,
    	[Asset Number], 
           [Model Name]
    FROM $(\\MyServerName\E$\excel\)$(vFilename)
    (txt, utf8, embedded labels, delimiter is ',', no quotes, no eof);
    
    
    	let vFilesFoundCounter = '$(vFilesFoundCounter)' + 1;	
    
    Next File
    
    Store Assets into \\MyServerName\E$Data-Lite\S1-Assets.qvd (qvd);
    Drop Table Assets;

     

     

     

    Show Less
  • Qlik Sense Data Connectivity

    Error al seleccionar campos

    HolaTengo un qvd con 249 columnas y me gustaría quitar de la selección algunas columnas, pero al Seleccionar datos y desmarcar algunas columnas, pulso... Show More

    Hola

    Tengo un qvd con 249 columnas y me gustaría quitar de la selección algunas columnas, pero al Seleccionar datos y desmarcar algunas columnas, pulso en Actualizar y me da un error:

    No se ha podido añadir los datos al Gestor de datos. Por favor, verifique que todas las fuentes de datos conectadas con la app funcionan e intente añadir los datos de nuevo.

    Si le doy a Actualizar sin desmarcar ninguna columna, no da ningún error.

    ¿Alguien podría ayudarme?

    Gracias

    Show Less
  • New to Qlik Sense

    Help with a crosstable and dates

    Hello,I'm trying to load some data using crosstable and its half working but I can't seem to change the field from a numeric to a date?  Any ideas?The... Show More

    Hello,
    I'm trying to load some data using crosstable and its half working but I can't seem to change the field from a numeric to a date?  Any ideas?

    The datasource is an excel spreadsheet with the columns being dates?

    [Sheet1]:
    CrossTable(YearMonth,Sheet1)
    LOAD
    [CHANNEL]&[PERIL]&[Capped / XS]&[Measure] AS [Metric],
    [42370],
    [42401],
    [42430],
    [42461],
    [42491],
    [42522],

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Daten einschränken und reduzieren

    Hallo,Ich habe eine SQL Mitarbeiter Tabelle mit über 3000 Zeilen. Ich habe auch eine Security_Tabelle auch mit ID, ACCESS (als ADMIN/USER), USERID(als... Show More

    Hallo,

    Ich habe eine SQL Mitarbeiter Tabelle mit über 3000 Zeilen. Ich habe auch eine Security_Tabelle auch mit ID, ACCESS (als ADMIN/USER), USERID(als URL), AbteilungsNr., Kostenstelle und Jahr. Mein Primäry Key ist (AbteilungsNr. &'|'& Kostenstelle &'|'& Jahr). Alles in QlikSense Server.

    Ich möchte folgendes erreichen,

    Wenn der Admin1 (BigBoss) mit einer seiner AbteilungsNr. in Qlik anmeldet, dann darf er nur seine Daten sehen, bearbeiten und analysieren, und die Anderen Mitarbeiter_Daten  mit gleichen Abteilungsnummer darf er nicht sehen und nicht bearbeiten.

    Wenn der Admin1 sich mit anderen bestimmten AbteilungsNr. anmeldet oder mit *, darf er alles sehen, bearbeiten und analysieren,

    Wenn Admin1 mehrere Abteilungsnummer hat, dann möchte ich eine von denen nicht erlauben zu sehen, aber er darf die Anderen Mitarbeiter_Daten mit anderen AbteilungsNr. auch sehen.

    Wenn sich Admin2 (z.B Abteilungsmanager) mit seiner Abteilungsnummer anmeldet, darf er nur unter Ihm eingestellten Mitarbeiter_Daten sehen, bearbeiten und andere Abteilungen nicht sehen.

    Normale Mitarbeiter dürfen und Ihre bestimmte Daten sehen,

    Das Problem ist, dass sich die Daten von AbteilungsNr., Kostenstelle und Jahr gleich sind und wiederholt und das lässt sich schwierig filtern.

    wie kann das für die 3000Mitarbeiter  dynamisch gehen oder gefiltert sein und Daten reduziert und eingeschränkt. 

    Gibt's API oder security Rollen oder API die noch Daten einschränken nach Hochladen von SectionAccess.

    ich möchte auch eine API mit .NET SDK in C# entwickeln, der die Daten von andere SQL Tabelle zu meiner Security Tabelle überträgt, Daten vergleicht und löscht und ich weiß nicht, wo ich anfangen soll. 

    ich brauche Eure Tipps und Hilfe,

    Vielen Dank

    A

     

    Show Less
  • Qlik Sense App Development

    positive, negative and greater than values

    Hi,I have Lot of fields in qliksense table,  using two fields in qliksense table those are outstanding amount and original amount,  some values are co... Show More

    Hi,

    I have Lot of fields in qliksense table,  using two fields in qliksense table those are outstanding amount and original amount,  some values are common in these two fields, my client given some conditions for these two fields

     1. Original Amount  = Outstanding  Amount (Positive Amount)
    2. If Outstanding  Amount is Less than Original Amount (Positive amount)                                                                                            3. If Outstanding  Amount  is greater than or Equal To Original Amount (Negative amount)

    all these conditions should come in qliksense table order wise, how can i do this?

    its urgent

    Thanks

     

    Show Less
  • New to Qlik Sense

    Load Skrict get rank

    Hello qlikers 🙂 ,this is my table:ID            TimeLength            Time1              12:15:15                   12.12.20122              00:06:53... Show More

    Hello qlikers 🙂 ,

    this is my table:

    ID            TimeLength            Time
    1              12:15:15                   12.12.2012
    2              00:06:53                   15.12.2012
    3              01:15:56                   16.12.2012
    4              05:14:36                   18.12.2012

    I want to write a Load script that me give a rank. 

    For example, the solution should be: 

    ID            TimeLength            Time                        Rank
    1              12:15:15                    12.12.2012            1
    2              05:14:36                    18.12.2012            2
    3              01:15:56                    16.12.2012            3

    As you can see, I want to create a rank table in my load script.

    But I dont know how I could get the first rank, the second and the third.

    Rank:
    Load
        Time,
        Max(TimeLength)
    Resident Table;

    This script snippet whould give me only all time and the same max. But I want only the first rank, and so on.

    Do you have any ideas? 🙂

    Thank you in advance! 

    Show Less
  • QlikView Deployment

    "Failed to Load" - Qlikview QVW Fail to Open Locally

    Hi All, Running into some problems when other Users are trying to open a file I created.They all received the 'document ***** failed to load' error.I ... Show More

    Hi All,

     

    Running into some problems when other Users are trying to open a file I created.

    They all received the 'document ***** failed to load' error.

    I have tried renaming it and resending, sent it with reduced data, sent other QVDs that had very basic layouts.

    I can still open all these files without any issues.

    Any recommendations? 

    Show Less
  • New to Qlik Sense

    Conditional showing value when percentage exceeds 100%

    Dear Community,Possibly a noob question but I got this dashboard with a sheet with a table on it, showing names and percentages (response rates). The ... Show More

    Dear Community,

    Possibly a noob question but I got this dashboard with a sheet with a table on it, showing names and percentages (response rates). The value of these rates are calculated with the following in the expression editor:

    count(distinct Satisfact_review_id)/sum({<year={$(vCurYear)}>} [No. Patients])

    Example.PNG

    The outcome sometimes exceeds 100% and I want those values to be shown as 100%+, otherwise of course the calculated percentage itself.
    In just language it should be:

    IF <result above mentioned expression> greater than 100%
    show 100%+
    ELSE show <result above mentioned expression>

    I tried diverse IF constructions, looked for some other options like pick for example but I could not get it working.
    Are conditional expressions possible in this specific case and if yes, how can I put it together the right way?

    Thanks in advance for thinking along and reaction and kind regards,

     

    Aad Dijksman

    The Netherlands

    Show Less
  • New to QlikView

    Conditionally Showing Text Boxes

    Hi All, I have one List box and 3 text boxes.like in list box having C 1 , C 2, C 3, C 4 and Text box Having C 1, C 2, C 3 and C 4,If i select C 1 in ... Show More

    Hi All, 
    I have one List box and 3 text boxes.

    like in list box having C 1 , C 2, C 3, C 4 and Text box Having C 1, C 2, C 3 and C 4,

    If i select C 1 in list box then display the C 1 text and if i clear all the sections then display All text boxes.

    Please suggest me how to achieve this scenario.

     

    Thanks & Regards, 

    Lakshman

    Show Less

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements for October and November 2019.

Blogs

Qlik Support Updates Blog

Read the latest blogs from Qlik Support and get important and useful support information.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members

Events

Qlik World 2020

Transform your digital world. Join us for our annual conference (formerly Qonnections) in Phoenix, AZ. Register by January 31, and save $300.

May 11- 14, 2020 Global Conference

Events

Events & Meetups

Participate in an upcoming local Qlik Meetup


Events

Customer Spotlight Series

Discover the secrets behind data-driven transformation with real-world examples from Qlik customers.

Watch the Series Today