Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
7,506 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

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

    QlikView App Dev

    Conditional IF Statement

    I am attempting to calculate the Sum of a group of receipts for multiple markets. However there are 2 markets in which I need the Sum cut in half. I h... Show More

    I am attempting to calculate the Sum of a group of receipts for multiple markets. However there are 2 markets in which I need the Sum cut in half.

    I have tried several nested IF statements so that those 2 are always cut in half, and the sum of all are brought in but have yet to figure it out.

    Any ideas?

    Show Less
  • forum

    New to Qlik Sense

    Storing new csv's in existing qvd

    hi, im pulling in multiple csvs into one qvd. however i want the script to only read in new csvs and store it into the existing qvd, i dont want it to... Show More

    hi,

    im pulling in multiple csvs into one qvd. however i want the script to only read in new csvs and store it into the existing qvd, i dont want it to reread every csv file every time as it will be quite slow due to large amount of csvs.

    im having a few problems,

    firstly when it runs it doesn't update the qvd if i put a new csv in a folder, 

    second, i want to be able to identify a specific string in all the files, but i only know how to do it for each field, is it possible to search the entire file instead of a specific field?

    my code:

    SUB DoDir(Root)

    FOR each File in filelist( Root & '\*.csv')

    test:
    LOAD *, RowNo() as rows, filename() as filename,
    if(wildmatch([Sector 27],'*¡MM')=1, [Sector 27]) as Sector27MM_Fails,
    if(wildmatch([Sector 27],'*¡MM*')+wildmatch([Sector 27],'*¡NR*')+
    wildmatch([Sector 27],'*¡WL*')+ wildmatch([Sector 27],'*¡BG*')+ wildmatch([Sector 27],'*¡FG*')=1, [Sector 27]) as Sector27AllFails

    FROM
    [$(File)]
    (txt, codepage is 28591, embedded labels, delimiter is ',', header is 1 lines);
    STORE test INTO [lib://........completeQvd.qvd] (qvd);

    NEXT File

    FOR each Dir in Dirlist (Root&'\*')

    CALL DoDir(Dir)


    NEXT Dir

     

    END SUB


    CALL DoDir('[lib://..../LVS')

    Show Less
  • forum

    New to Qlik Sense

    Help in set analysis

    Hi there, Please kindly help me out in the expression - I want until the first word after comma .   My requirement is  to show  in else statement - C... Show More

    Hi there,

    Please kindly help me out in the expression -

    I want until the first word after comma .

    scenario.PNG

     

    My requirement is  to show  in else statement -

    COLLINS, KYM

    ALLEN, CHRISTOPHER

    ADAM, JOHN

    expression I tried -

    ashmitp869_0-1642733803559.png

     

    Show Less
  • forum

    New to Qlik Sense

    Which timestamp is in the script log

    Hello, If I have my raw data on a separate server running linux (with different time settings) and the processed QVD files on a windows machine, from ... Show More

    Hello,

    If I have my raw data on a separate server running linux (with different time settings) and the processed QVD files on a windows machine, from which server does the script log (app task execution) get its timestamp from? Will it be from the original linux server where it gets the raw data or from the windows machine where it saves the processed qvd files at?

    Show Less
  • forum

    New to Qlik Sense

    Expression

    Hi All, I am trying to write a expression like below but this is not giving me any output even there is not error in the expression  Can someone pleas... Show More

    Hi All,

    I am trying to write a expression like below but this is not giving me any output even there is not error in the expression 

    Can someone please correct me  on this 

     

    Expression :

    =if(Floor(DelDate)=Floor(ColectDate),
    count({<Status={'Closed'},
    Sales={'Ach'}>}ID))

    Thanks in Advance 

    Show Less
  • forum

    New to Qlik Sense

    How do I load a table by removing line associated to datas part of a second tab...

    Dear all, I'm new to Qlik sense and facing an issue with a specific table I try to load. Indeed I have two tables (= see example below) : [COST CENTER... Show More

    Dear all,

    I'm new to Qlik sense and facing an issue with a specific table I try to load.

    Indeed I have two tables (= see example below) :

    [COST CENTER]:

    Cost center ID Budget owner ID
    2K29 0124528Z
    2028  
    25A3 0147889A
    4587 7305485

     

    In this first table, I find all cost centers and the budget owner ID associated for each of them.

    For some cost center there is no budget owner determined. The field Budget owner ID stay blank.

    [USER ID]

    User ID
    0124528Z
    0147889A
    0879547X
    7354789

    In a second table, I have a list of User ID.

     

    I want to display the first table by removing the line on which I can find a User ID part of [User ID] table.

    I want also to keep the line on which there is no budget owner ID determined.

    So, if we keep example below, at the end I want a table loaded like below:

    [COST CENTER}:

    Cost center Budget owner ID
    2028  
    4587 7305485

     

    Indeed, 

    0124528Z is part of [User ID] table so I want the line removed

    0147889A is part of [User ID] table so I want the line removed

    7305485 is not part of  [User ID] table so I want to keep and display the line

    For the cost center 2028, there is no Budget owner ID so I want to keep the line.

     

    At the end, there is only the two lines above displayed.

     

    How in data load editor, I can handle this?

     

    Looking forward to an answer.

     

    Best regards

     

    David

    Show Less
  • forum

    Qlik Enterprise Manager

    Qlik Enterprise Manager November 2021 Release Now Available

    We are pleased to share that the Qlik Enterprise Manager November 2021 initial release is now available.   This release includes a number of enhanceme... Show More

    We are pleased to share that the Qlik Enterprise Manager November 2021 initial release is now available.   

    This release includes a number of enhancements, including support for all Replicate notifications within Enterprise Manager, allowing you to manage all of the notifications related to your Replicate servers and replication tasks in a single location.

    More information about the release can be found on our product innovation blog.   

    Show Less
  • forum

    New to Qlik Sense

    Adding like condition in a set analysis expression

    Hi there, Please kindly assist me with the expression- below expression is helping me to get the [GP Full Name] which is not "GP, NO GP","GP, NOT KNOW... Show More

    Hi there,

    Please kindly assist me with the expression-

    below expression is helping me to get the [GP Full Name] which is not "GP, NO GP","GP, NOT KNOWN","GP, NOT LISTED","GP, NOT STATED","GP, NOT FOUND","GP, NO CONSENT" .

    =Aggr(Only({<[GP Full Name] -= {"GP, NO GP","GP, NOT KNOWN","GP, NOT LISTED","GP, NOT STATED","GP, NOT FOUND","GP, NO CONSENT"}>} [GP Full Name]), [GP Full Name])

    with the above expression -partly working 

    working.PNG

    But I want to add in the condition [GP Full Name]  like "%PRACTICE%","%MEDICAL%","%CENTRE%" should also not show i.e come NULL else show [GP Full Name]

    I want to add the condition so that the below should also not show up

    notworking.PNG

    Trying something like below but not working

    =Aggr(Only({<[GP Full Name] -=like {"GP, NO GP","GP, NOT KNOWN","GP, NOT LISTED","GP, NOT STATED","GP, NOT FOUND","GP, NO CONSENT","%PRACTICE%","%MEDICAL%","%CENTRE%"}>} [GP Full Name]), [GP Full Name])

    Thanks

    Show Less
  • forum

    Deployment & Management

    Creating a Time Range for Email Reports

    Hi All! I'm setting up an email report and I want to setup a default selection where users can only view the data from the past 30 days.  I'm using a ... Show More

    Hi All!

    I'm setting up an email report and I want to setup a default selection where users can only view the data from the past 30 days.  I'm using a bookmark to make this the default selection when people are viewing the dashboard, so I'm wondering if there is a way to apply this bookmark to the automation that I'm creating to send out the email report.

    Thanks,

    Sam

    Show Less
  • forum

    New to Qlik Sense

    Avg and sum in "Show Totals"

    Hello! I'm having trouble with this table: I used the following formula so in the first column, the numbers underlined in red calculate the average o... Show More

    Hello!

    I'm having trouble with this table:

    rociomendez_3-1642704672486.png

    I used the following formula so in the first column, the numbers underlined in red calculate the average of the numbers to their right instead of showing the sum, and the totals of every column show the sum of their numbers below:

    if(Dimensionality()=0,
    sum((calificacionM/100)*porcentaje),
    avg(aggr(sum((calificacionM/100)*porcentaje), [MESAÑO_CON], nombreClasificaciones, num_porcentaje)))

    What I'm having trouble with is that I need the number highlighted in yellow to sum the numbers below, not the numbers to its right, so I can have 96.75 instead of 967.48.

     

    Any ideas? Is it possible? Thanks so much for your help!!

    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