Qlik Community

Welcome to Qlik Community

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

    Qlik Replicate

    Data Tokenization via replication

    Hi We have a requirement, to tokenize a specific column when the data is replicated from a source to target (In flight) I have seen you can add "Exter... Show More

    Hi We have a requirement, to tokenize a specific column when the data is replicated from a source to target (In flight)

    I have seen you can add "External API" custom code that you then can add the API call to Tokenize the data.

    We will need to connect / get tokenized by a system called Voltage, but have no idea where to even start.

    Show Less
  • forum

    App Development

    Advanced set analysis

    Hello. I analyze sales on ebay auctions. I have an auction list and a sale on them (by days [SalesDate]). Each auction has a start and end date (Aucti... Show More

    Hello.

    I analyze sales on ebay auctions. I have an auction list and a sale on them (by days [SalesDate]). Each auction has a start and end date (AuctionEndDate). I want to count auctions completed in a month that had sales in the last 7 days before the end.

    I want to get a simple table with two columns:

    1. month([AuctionEndDate]) and it is ok
    2. count of auctions with sales in last 7 days

    I tried with 

    count(DISTINCT {<[AuctionID] = {"=Sum({<[SalesDate]={">$(=date([AuctionEndDate]-7))"}>}[Sales])>'0' "}>} [AuctionID])

    ... but without success.

    Please help 🙂

    Thanks,

    M

    Show Less
  • forum

    Search the Community

    Error loading data

    Hello ,  please can someone tell me this error is due to what 
  • forum

    App Development

    Multiple Date filter

    Hi all, I am generating some numbers and showing in text objects based on certain conditions. There are multiple text objects on the sheet and each ha... Show More

    Hi all,

    I am generating some numbers and showing in text objects based on certain conditions. There are multiple text objects on the sheet and each has a different condition. I have two separate categories for the text objects and want to be able to apply date filters to these two categories separately, e.g. 2020 to one category and 2021 to the other category. I have created two separate Date fields as well to use as listbox but when i am selecting one date filter, the other one deselects. Tried Alternate State but it does not show any count in the respective text object when applied to one listbox and in the text object expression.  please help share some idea as to how to solve this.

    I am using the below expression for Alternate State named as "TESTING":

    =num(Count({TESTING} distinct {$<[As of Date]={'$(vCurrMonth)'},[In Progress]={'1'},[Testing Type]={'1'},}testno),'#,##0')

    Show Less
  • forum

    Brasil

    PROBLEMA GRAVE! Qlik Cloud alterou as variáveis de um aplicativo!

    Bom dia! gostaria de compartilhar um problema que tive, para que fiquem atentos e tomem medidas preventivas caso aconteça com vocês! Estou trabalhando... Show More

    Bom dia!

    gostaria de compartilhar um problema que tive, para que fiquem atentos e tomem medidas preventivas caso aconteça com vocês!

    Estou trabalhando em um cliente que utiliza o Qlik Cloud (versão SaaS do QlikSense). Ontem no final da tarde, após uma atualização dos dados, percebi que vários objetos estavam sem valores, e quando fui investigar, as variáveis que guardavam as fórmulas estavam com a definição completamente diferente do original! SIM! A definição da variável foi mudada completamente! 

    Para minha sorte, eu utilizo o KPI Repository do Christof Schwarz, então as variáveis que foram definidas no script não sofreram alteração, porém, as que foram criadas diretamente no editor estavam totalmente diferentes do original.

    E para a minha sorte [2] eu tinha um backup do aplicativo do dia 17 na minha máquina.

    Olhem um exemplo, são as mesmas variáveis. Na primeira imagem é o meu backup do dia 17 (no Sense Desktop), e na segunda imagem é o aplicativo no QlikCloud:

    desktopdesktopSaaSSaaS

    Portanto amigos, fica de lição aprendida... backup diário das aplicações quando estiverem trabalhando com SaaS! Se não fosse o KPI repository e o meu backup, poderia ter SEMANAS de trabalho completamente perdido!

    Show Less
  • forum

    New to Qlik Sense

    I can't create a new analytics app in Qlik sense cloud

    I can't create a new analytics app in Qlik sense cloud. What's wrong? Upload doesn't work either with the same error.        
  • forum

    App Development

    Load data from time DATE_STARTED, 2 weeks back.

    Hello Everybody   I am still a beginner when it comes to QlikSense. In the app I'm trying to create, I want to load all data older than 2 weeks than t... Show More

    Hello Everybody

     

    I am still a beginner when it comes to QlikSense. In the app I'm trying to create, I want to load all data older than 2 weeks than the newest time of DATE_STARTED.

    What I have tried until now without success.

    LOAD

    Timestamp([DATE_STARTED] , 'D/M/YYYY') AS [DATE_STARTED]

    ....

    Where DATE_STARTED >= (today()-14);

     

    What I'm missing, or is this approach efficient ?

    Thanks for your time and help 

     

     

    Show Less
  • forum
  • forum

    New to Qlik Sense

    qlik sense desktop installation free

    hello I want to install the qlik sense desktop free  in my pc but I cannot see the link in webpage. I could only find to install  the qlikview  but no... Show More

    hello I want to install the qlik sense desktop free  in my pc but I cannot see the link in webpage.

    I could only find to install  the qlikview  but not the  sense 

     

    could you please help me where can I find the link for the download of qlik sense desktop?

     

    thanks

     

    Show Less
  • forum

    QlikView App Dev

    Code block reusability in LOAD script

    I have a LOAD script like:   Concatenate(Sales) SELECT aa, bb FROM $(vMyPath)file1.xlsx (ooxml, embedded labels, table is INPUT) ;   Concatenate(Sales... Show More

    I have a LOAD script like:

     

    Concatenate(Sales)

    SELECT

    aa,

    bb

    FROM $(vMyPath)file1.xlsx (ooxml, embedded labels, table is INPUT)

    ;

     

    Concatenate(Sales)

    SELECT

    aa,

    bb

    FROM $(vMyPath)file2.xlsx (ooxml, embedded labels, table is INPUT)

    ;

     

    I.e. 2 blocks of code where only the names of the excel source files differ. (How) Can I reuse the main part of the code to shorten the script and do something like:

     

    Sub MySub(MyExcelFile)

        Concatenate(Sales)

        SELECT

        aa,

        bb

        FROM $(vMyPath)MyExcelFile (ooxml, embedded labels, table is INPUT)

        ;

    end sub

     

    call MySub(file1.xlsx)

    call MySub(file2.xlsx)

    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