Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
9,063 online
Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

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

Support

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

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.

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

    QlikView App Dev

    Problem loading Excel file with Year and Week to QlikView

    Hi, I need load an Excelfile to a QlikView application.  I have tried with the following script : LOAD Year, Week, %FOKID, NoPackagesFROM [$(vG.Import... Show More

    Hi,

    I need load an Excelfile to a QlikView application.  I have tried with the following script :

    LOAD
    Year,
    Week,
    %FOKID,
    NoPackages
    FROM [$(vG.ImportPath)File_to_load.xlsx]
    (ooxml, embedded labels, table is QVData);

    The file consists of YTD data with Year, Week and %FOKID together with a count of packages (NoPackages).

    Now, after loading the application, all the data in the application is "filtered" to show only those weeks and %FOKIDs as in the file - what do I need to change in my script?

    Year, Week and %FOKID are all existing fields in the application. NoPackages is new information which will be updated weekly in the file.

    We are running QlikView 12.60, May 2021 SR1

    Thanks,
    Anders

    Show Less
  • forum

    QlikView App Dev

    Data checker

    Hello Team,Want to create one application in Qlikview as Data Checker, this app should check below points- -Check QVD1 size, if it is 0KB then set Fla... Show More

    Hello Team,
    Want to create one application in Qlikview as Data Checker, this app should check below points-

    -Check QVD1 size, if it is 0KB then set Flag1=False 

    -Check count of QVD1 >0 then set Flag2='Data is available'

     

    Thanks in advance 

    Show Less
  • forum

    App Development

    Left Join

    Hi everybody, I'm trying to join multiple tables in order to make links between my tables and I'm facing an issue when "creating" a new field. Table 1... Show More

    Hi everybody,

    I'm trying to join multiple tables in order to make links between my tables and I'm facing an issue when "creating" a new field.

    Table 1 - Invoice

    • InvoiceId
    • InvoiceDate
    • JnlType
    • InvoiceNo
    • InvoiceSite

    Table 2 - Order 

    • InvoiceId
    • DeliveryClientNo

    Table 3 - Client

    • DeliveryClientNo
    • ClientNo

    Table 4 - ClientMovement

    • ID ( which can be obtained with ->Year(InvoiceDate)&JnlType&InvoiceNo&InvoiceSite&ClientNo)

     

    So, I made this but I'm stuck for 2 reasons.

    [Invoice]
    LOAD
         FactId,
         FactDate,
         FactJournal,
         FactNo,
         FactSite,
         Year(FactDate) &'|'& FactJournal &'|'& FactNo &'|'& FactSite AS ClientDocNo
    FROM [lib://.../invoice.qvd] (qvd);

    LEFT JOIN([Invoice])
    LOAD
         InvoiceId,
         TEXT(RTRIM(DeliveryClientNo)) 
    FROM [lib://...Order.qvd] (qvd);

    LEFT JOIN[Invoice])
    LOAD
         TEXT(RTRIM(DeliveryClientNo))
    FROM [lib://.../Client.qvd] (qvd);

     

    After that, i do not know how to make my link between my CLIENT and INVOICE table and to create the field I need for having the ID of table 4.

     

    Can someone please help me?

    Have a nice day

    Show Less
  • forum

    New to Qlik Sense

    regroupement

    bonjour, je suis sur Qlikview j'ai une table contenant : Date, Numéro de compte, vecteur. Date Analyse numéro de compte vecteur 2021-10-14 011609... Show More

    bonjour, je suis sur Qlikview

    j'ai une table contenant :

    Date, Numéro de compte, vecteur.

    Date Analyse numéro de compte vecteur
    2021-10-14 011609368 AlloPari
    2021-10-15 011609368 SMS
    2021-10-16 011609368 AlloPari
    2021-10-16 011609368 SMS
    2021-10-18 011609368 SMS
    2021-10-24 011609368 SMS
    2021-10-25 011609368 AlloPari
    2021-10-26 011609368 AlloPari
    2021-10-26 011609368 SMS
    2021-10-29 011609368 AlloPari
    2021-10-30 011609368 SMS
    2021-10-01 018650287 VIBER
    2021-10-02 018650287 VIBER
    2021-10-03 018650287 VIBER
    2021-10-08 018650287 VIBER
    2021-10-09 018650287 VIBER
    2021-10-11 018650287 VIBER
    2021-10-15 018650287 AlloPari

     

    Je voudrais identifier par un tag les comptes ayant uniquement un seul vecteur (ex VIBER), ceux qui ont deux vecteurs (ex VIBER et SMS) et ceux qui ont les trois (AlloPari, SMS et Viber).

    Quelqu'un aurait-il un solution à me proposer.

     

    en vous remerciant

    françois

     

    Show Less
  • forum

    QlikView App Dev

    Expression Help

    Hi Friends, I have Some no. of raw data, Now I have to make an expression Like - In Others Row - The Value will substract the Value from Top 50 Row. I... Show More

    Hi Friends,

    I have Some no. of raw data, Now I have to make an expression Like - In Others Row - The Value will substract the Value from Top 50 Row.

    I have given the Input and Output in attached xls. Please check the xls and help me to make an expression for the same.

    Thanks.

    Show Less
  • forum

    New to Qlik Sense

    Lock a variable in line chart.

    Hey! I have a problem with locking a variable in my timeline. Basically my line chart is based on the Fiscal year 21/22 (July 2021 - June 2022). In th... Show More

    Hey! I have a problem with locking a variable in my timeline.

    Basically my line chart is based on the Fiscal year 21/22 (July 2021 - June 2022).

    In this line chart, I have data up until  November.

    Afterwards I would like to project future number of the figure, based on a quite simple formula.

    The formula I have tried using is the following:

    if([Historic PP] <> 0, [Historic PP]

    ,

    RangeSum(Sum([FuturePP])/1000,0,RowNo())*

    above(alt((Sum ({$1<[YTD]={'YTD'}>} [Historic PP])+Sum ({$1<[YTD]={'YTD'}>} [Planned V])
    +Sum ({$<[YTD]={'YTD'}>} [Actual V]))*alt(1/Sum ({$1<[YTD]={'YTD'}>} [Historic PP]),1)))

    +RangeSum(Sum ({1} {$<[YTD]={'YTD'}>} [Historic PP])/1000*

    above(alt((Sum ({1} {$<[YTD]={'YTD'}>} [Historic PP])+Sum ({1} {$<[YTD]={'YTD'}>} [Planned V])
    +Sum ({1} {$<[YTD]={'YTD'}>} [Actual V]))*alt(1/Sum ({1} {$<[YTD]={'YTD'}>} [Historic PP]),1)))

    )

    Where the first part of the if statement is working. However, the second part the variable [FuturePP] will vary from December 2021 till June 2022, and the other part of the formula is varying from June 2021 til November 2021.

    In this formula, I would like to use the calculated value at November 2021, and then have the same constant timed on [FuturePP] from December 2021-June 2022.

    To elaborate the last part of the if/else statement works if I hardcode the constant (example below)

    RangeSum(Sum([FuturePP])/1000,0,RowNo())*

    0.5

    +RangeSum(Sum ({1} {$<[YTD]={'YTD'}>} [Historic PP])/1000*

    0.5

     

    Can anybody help here?

     

    Show Less
  • forum

    New to Qlik Sense

    Calcul Chiffres d'affaire à M-1

    Bonjour, je cherche à calculer le chiffres d'affaire : exemple decembre 2021 vs decembre 2020 du mois précédent du mois selectionné (ex 2021/11 vs 20... Show More

    Bonjour,

    je cherche à calculer le chiffres d'affaire :

    • exemple decembre 2021 vs decembre 2020
    • du mois précédent du mois selectionné (ex 2021/11 vs 2021/12)

    J'ai chercher dans la communauté mais pas trouvé de solution à ma simple demande.

    En vous remerciant

    François

     

    Show Less
  • forum

    New to Qlik Sense

    Displaying customers who has not made an order for the past 6 months.

    I've dropped the App with exported data below. How would one go on about this? I would like to show/display every customer who haven't placed an order... Show More

    I've dropped the App with exported data below.

    How would one go on about this? I would like to show/display every customer who haven't placed an order for the past 6 months. I'm very new to this so any help would be appreciated. 

    Show Less
  • forum

    QlikView App Dev

    Werte aus einer Spalte aufteilen

    Hallo zusammen, ich habe in meiner App eine Spalte die mit verschiedenen Werten gefüllt ist. Die Werte sehen zum Beispiel so aus: 2021PL9045 2021TZ456... Show More

    Hallo zusammen,

    ich habe in meiner App eine Spalte die mit verschiedenen Werten gefüllt ist. Die Werte sehen zum Beispiel so aus:

    2021PL9045

    2021TZ4567

    2021MN0912

    Ich habe jetzt alle Werte aus dieser Spalte mithilfe der wildmatch Funktion in neue Spalten aufgeteilt, nach einer bestimmten Variable, z.B.:

    Spalte PL

    Spalte TZ

    Spalte MN

    Jetzt wird in der Spalte "PL" anstatt "2021PL9045" ein numerischer Wert wiedergegeben, z.B. 0,1,2,3,4 usw. Kann ich anstatt der Zahlen auch die vollständige Bezeichnung aus der Spalte anzeigen lassen, z.B. "2021PL9045"?

    Danke für eure Hilfe.

    Show Less
  • forum

    Qlik Application Automation

    Dynamic filter in automation

    Hi, can anybody explain how to set a dynmic filter in application automation? I want to select in field Year month the value of actual month, in expre... Show More

    Hi,

    can anybody explain how to set a dynmic filter in application automation?

    I want to select in field Year month the value of actual month, in expression it would be date(today(),'YY MMMM').

    Thank you

    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