Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
1,974 online

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

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.

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.

Qlik Academic Program

Enabling professors and students with data and analytics.

About

Get started, 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

    New to Qlik Sense

    Number Format

    Hi.I have below expression that sits in a pivot table under dimensions.Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Descri... Show More

    Hi.

    I have below expression that sits in a pivot table under dimensions.

    Aggr(Round(Sum({<[Pdiv Id No]-={6,11,12}, [SK Plan Type No]={1}, [Season Description EP]={'Winter'}>}[Binc Sale Sell Amt])), Division, Department).

    This is returning the number format of 123456789.

    I would like the above expresion to return 123 456 789.

    How am I able to achieve that?

    Show Less
  • forum

    QlikView App Dev

    Simplifying if conditions in the script

    Hi All, PFB script. Can you please suggest how to simplify if statement from the script.if(ApplyMap('AcquisitionMonth',ASSET_STATIC_ID,null())=Month, ... Show More

    Hi All,

     

    PFB script.

     

    Can you please suggest how to simplify if statement from the script.

    if(ApplyMap('AcquisitionMonth',ASSET_STATIC_ID,null())=Month, ApplyMap('AcquisitionMonth',ASSET_STATIC_ID,null()),null()) as ASSET_ACQUISITION_MONTH,
    if(ApplyMap('AcquisitionQuarter',ASSET_STATIC_ID,null())=Quarter, ApplyMap('AcquisitionQuarter',ASSET_STATIC_ID,null()),null()) as ASSET_ACQUISITION_QUARTER,

     


    if( len(Month)>2 and [Object Type Code]='A',(
    ApplyMap('DispositionMonth',[%KEY_ASSET_SCD],'-')),
    if(len(Quarter)>2 and [Object Type Code]='A',(
    ApplyMap('DispositionQuarter',[%KEY_ASSET_SCD],'-')))) as PropertySold_Diversification,


    if(len(Month)>2 and [Object Type Code]='A',(
    ApplyMap('DispositionMonth_asset',[%KEY_ASSET_SCD],'-')),
    if(len(Quarter)>2 and [Object Type Code]='A',(
    ApplyMap('DispositionQuarter_asset',[%KEY_ASSET_SCD],'-')))) as PropertySold_Asset_download,


    if( len(Quarter)>2,(
    if(((Applymap('On_Off_Rules_Start_Qtr_MVRF',VEHICLE_STATIC_ID,'')<= Replace(Quarter,'Q','')) and
    (Replace(Quarter,'Q','')<= Applymap('On_Off_Rules_End_Qtr_MVRF',VEHICLE_STATIC_ID))),'PL_OFF','0')
    ),
    if( len(Month)>2,(
    if(((Applymap('On_Off_Rules_Start_Mth_MVRF',VEHICLE_STATIC_ID,'')<= (num#(Month))) and
    ((num#(Month))<= Applymap('On_Off_Rules_End_Mth_MVRF',VEHICLE_STATIC_ID))),'PL_OFF','0')))) as PL_OFF,


    if( len(Quarter)>2,(
    if((((Applymap('On_Off_Rules_Start_Qtr_NAV',VEHICLE_STATIC_ID,'')<= Replace(Quarter,'Q','')) and
    (Replace(Quarter,'Q','')<= Applymap('On_Off_Rules_End_Qtr_NAV',VEHICLE_STATIC_ID)))) ,'IL_OFF','0')
    ),
    if( len(Month)>2,(
    if((((Applymap('On_Off_Rules_Start_Mth_NAV',VEHICLE_STATIC_ID,'')<= (num#(Month))) and
    ((num#(Month))<= Applymap('On_Off_Rules_End_Mth_NAV',VEHICLE_STATIC_ID)))),'IL_OFF','0')))) as IL_OFF,


    Thanks

    Show Less
  • forum

    QlikView App Dev

    how to execute partial reload properly in script - No lines loading

    Hello everyone, I can't seem to do partial reload correctly in scriptWhen i do if IsPartialReload() thenTRACE "PARTIAL LOAD";TABLE_1:Load *From Table ... Show More

    Hello everyone,

     

    I can't seem to do partial reload correctly in script

    When i do 

    if IsPartialReload() then
    TRACE "PARTIAL LOAD";

    TABLE_1:

    Load *

    From Table 1;

    ELSE 

    TABLE_2:

    Load *

    From Table 2;

     

    TABLE_3:

    Load *

    From Table 3;

    ENDIF;

     

    What i don't understand is when i do partial reload using a button or CTRL + SHIFT + R i always get

    LESSASSY_K_0-1623661613132.png

     

    Anyone can tell me what i did wrong ? No lines is loading during my partial load.

    Thanks

    Show Less
  • forum

    App Development

    Créer plusieurs indicateurs - pb de script

    Bonjour à tous,Je débute avec Qlik Sense depuis qq semaines et j'aurai besoin de votre aide.J'ai un fichier (dont le mais est de lister les dossiers e... Show More

    Bonjour à tous,

    Je débute avec Qlik Sense depuis qq semaines et j'aurai besoin de votre aide.


    J'ai un fichier (dont le mais est de lister les dossiers en cours non traité) comprennant une colonne "Days" (avec des nombres entiers) et je cherche à créer 4 catégories pour définir des KPI sur le nombre de jours depuis lequel ils sont ouverts/non-traités :
    - <2 (KPI 1)
    - entre 3 et 5 (KPI 2)
    - entre 6 et 10 (KPI 3)
    - >10 (KPI 4)

    Pour le moment, j'ai créé le script avec ça :
    " [Days],
    if ([Days]<3, '[:0-2 days]', if ([Days]<6, '[:3-5 jours]', if ([Days]<11, '[:6-10 days]', if ([Days]>10, '[>10 days]')))) comme Days_WF "

    Pour la création de mes graphiques, je m'en sorte très bien jusqu'à-là (même si le script est surement peu académique), mais arriver à fixer des valeurs de KPI différents selon chaque KPI c'est là que je suis perdue .

    J'ai bien compris que la représentation 'indicateur' ne pouvait pas combiner plusieurs dimensions, mais si mes KPI sont bien définis, je pourrai à minima utiliser un graphique pour chaque avec la représentation 'indicateur'


    Merci d'avance pour votre aide ! 🙂

    Show Less
  • forum

    App Development

    Problem with dates

    Hello everyone!I have a problem with my date fields in my app. this is the structure of my app, basically I have a date range in table "Budget" from "... Show More

    Hello everyone!

    I have a problem with my date fields in my app. 

    Cattura.PNG

    this is the structure of my app, basically I have a date range in table "Budget" from "datainizio" to "datafine".

    I have to display in my app a table which shows a value from table "Globale" and a value from table "Budget" in the same period but I don't know ho to link the date fields in "Budget" table to my Master Calendar.
    If I use month(datainizio) I can see "budget"field (from table Budget) in each month but I don't see "molt"field (from table Globale). If I use month(data01) (which is "Mese" in my master calendar) I can see "molt"field in each month but I don't see "budget"field.

    Cattura2.PNG

    Cattura3.PNG

    I don't know if I am clear with my deal, could anyone help me?

    This is my script:

     

    //** GLOBALE TABLE

    Globale:
    LOAD
    idMarca &'_'& [pv] as [% Key marca_pv],
    scontrino,
    idMarca,
    azienda,
    nomeazienda,
    tipodoc,
    destipodoc,
    numerodocumento,
    data01,
    [pv],
    puntovendita,
    codmailing,
    ragsoc,
    tipologiaCliente,
    agente,
    tipoAgente,
    desagente,
    segno,
    molt,
    clifor,
    preventivo,
    ordinefornitore,
    tipostat,
    idarticolo,
    descrizione,
    codesterno,
    marca,
    gruppo,
    linea,
    reparto,
    codreparto,
    famiglia,
    codfamiglia,
    idmagprovenienza,
    idmagazzino,
    magprovenienza,
    magazzino,
    qta,
    prezzo,
    sconto1,
    sconto2,
    sconto3,
    importo,
    costo,
    provvigioni,
    costoAnagrafico,
    prezzolistino1,
    prezzolistino2,
    prezzolistino3,
    prezzolistino4,
    prezzolistino5,
    prezzolistino6
    FROM [lib://letturadati/Globale.qvd]
    (qvd);

     

    //** BUDGET TABLE

    Budget:
    LOAD
    Budget.idMarca &'_'& Budget.pv as [% Key marca_pv],
    Budget.idMarca,
    ID,
    Budget.tipo,
    Budget.tipostat,
    Budget.descrizione,
    datainizio,
    datafine,
    Budget.pv,
    idAgente,
    Budget.codmailing,
    budget,
    peso,
    budget*peso as budgetcalc
    FROM [lib://letturadati/BudgetMarca.qvd]
    (qvd);

     

    //** CALENDAR

    QuartersMap:
    MAPPING LOAD
    rowno() as Mese,
    'T' & Ceil (rowno()/3) as Trimestre
    AUTOGENERATE (12);

    Temp:
    Load
    '01/01/2021' as minDate,
    max(data01) as maxDate
    Resident Globale;

    Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
    Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
    DROP Table Temp;

    TempCalendar:
    LOAD
    $(varMinDate) + Iterno()-1 As Num,
    Date($(varMinDate) + IterNo() - 1) as TempDate
    AutoGenerate 1 While $(varMinDate) + IterNo() -1 <= $(varMaxDate);

    MasterCalendar:
    Load
    TempDate AS data01,
    week(TempDate) As Settimana,
    Year(TempDate) As Anno,
    Month(TempDate) As Mese,
    Day(TempDate) As Giorno,
    YeartoDate(TempDate)*-1 as CurYTDFlag,
    YeartoDate(TempDate,-1)*-1 as LastYTDFlag,
    inyear(TempDate, Monthstart($(varMaxDate)),-1) as RC12,
    date(monthstart(TempDate), 'MMM-YYYY') as MeseAnno,
    ApplyMap('QuartersMap', month(TempDate), Null()) as Trimestre,
    Week(weekstart(TempDate)) & '-' & WeekYear(TempDate) as WeekYear,
    WeekDay(TempDate) as WeekDay
    Resident TempCalendar
    Order By TempDate ASC;
    Drop Table TempCalendar;

     

    Thank to all!

    Show Less
  • forum

    Deployment & Management

    Not find the ticket number for Support Call

    Hi, how to find the ticket number for my post that I can give to the Support Team call?? People from call have required me to give. But I couldn't fin... Show More

    Hi, 

    how to find the ticket number for my post that I can give to the Support Team call?? People from call have required me to give. But I couldn't find the number.
    When I tried to give the number in the url like 1812105 in https://community.qlik.com/t5/Deployment-Management/Slow-Performance-to-open-sheets-and-calculate/td-p/1812105 . People say this is not my ticket. I am really confused.

    regards

    Kefang

    Show Less
  • forum

    New to Qlik Sense

    How to check the non matching values in one table referring another

    Hi All,Requirement: I have two tables, let's call them Table A and Table B. For this requirement I'll be referring only two columns from both tables i... Show More

    Hi All,

    Requirement: I have two tables, let's call them Table A and Table B. For this requirement I'll be referring only two columns from both tables i.e. Number and ID. I need to look for Numbers from Table A in the Table B and check if the ID(s) associated with the Number in Table B are not different in Table A.  Please keep in mind that there can be duplicates as well as multiple IDs associated with the same Number.

    Let's look at the below scenario for better understanding.

    Table A:

    Number           ID

    123                      1

    124                      2

    124                      3

    125                      4

    125                      4

    125                      5

    126                      6

    127                      8

     

    Table B:

    Number             ID

    123                       1

    124                       2

    124                       4

    125                       5     

    126                       7     

    127                       8

    127                       9

    From this scenario - Numbers 124,126 and 127 falls under the issue category that I need to show the users.

    In Table B there's an ID 4 which is related to Number 124 but not in Table A and 126 is straightforward as IDs don't match in both tables for this Number. For the Number 127, there's only one record in Table A but two in Table B and ID 9 is not present in Table A for the same Number.

    123 is a straight match with  ID 1 and 125 has only onw record in Table B compared to 3 records in Table A albeit one being a duplicate but ID 4 is present in the Table A as well so this one is fine.

    I hope i have made the requirement clear, if not then please let me know. Any suggestion or help will be appreciated.

    Thanks!                          

     

    Show Less
  • forum

    App Development

    Lista que seleciona objeto do Contêiner

    Olá, sou nova no Qlik e não sei se há como fazer o que preciso.Abaixo detalharei.Tenho um contêiner, que contém outros objetos(Gráficos dinâmicos), mi... Show More

    Olá, sou nova no Qlik e não sei se há como fazer o que preciso.

    Abaixo detalharei.

    Tenho um contêiner, que contém outros objetos(Gráficos dinâmicos), minha pergunta/dúvida é, há como através de um campo Lista, ou botão ter uma opção que eu pudesse selecionar o Gráfico dinâmico 2(por exemplo) sem precisar ir na caixa de seleção do contêiner? ( no desenvolvimento de software eu saberia como resolver fácil a questão).

    Dessa forma ficaria mais dinâmico para o usuário poder selecionar o que gostaria de visualizar, sem que eu precise mexer nas estrutura de como está hoje esses gráficos(sem inclusões de if's nas expressões)

    Show Less
  • forum

    QlikView Administration

    Log Fetcher is not working for QlikView scalability

    I am performing scalability testing for QlikView. After end of run, log fetcher is not opening. i tried it from "Tools" menu. That option is also not ... Show More

    I am performing scalability testing for QlikView. 

    After end of run, log fetcher is not opening. i tried it from "Tools" menu. That option is also not working.

    Please help here with solution.

    Show Less
  • forum

    Deployment & Management

    Qlik Sense Post Upgrade Issue

    We have upgraded  Qlik sense from April 2018, Patch 1 to Feb 2021, Patch 7. After the upgrade, I have some apps that fail to load from QMC Task, but a... Show More

    We have upgraded  Qlik sense from April 2018, Patch 1 to Feb 2021, Patch 7. 

    After the upgrade, I have some apps that fail to load from QMC Task, but are fine when I load data using Data Load Editor. The tasks in the red box are those that ran after the upgrade. The 3 selected ones keep failing. I have tried to reload the data using data load editor, then republish the app, and try to rerun the reload from task, but they still fail.

    Could you check what could be the issue? Not sure if this will happen for the other apps whose reload tasks are not executed yet...

    Attached are the log file and screenshot for your reference. 

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

May 18, 2021 10AM EST

Events

Qlik Insider - Webinar Series

This webinar will cover key new capabilities that drive Active Intelligence in your organization, helping your users go beyond the dashboard, to collaborate and take action at the point of decision.

May 26, 2021