Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,540 members
  • 7,665 online
  • 1,995,323 posts
  • 149,526 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Use a variable with Dimension of Pivot Table

    Hello I need some help 😉 I have dimension AA with values 'one' and 'two' I have another dimension BB with values 'red' and 'green' I have several  va... Show More

    Hello

    I need some help 😉

    I have dimension AA with values 'one' and 'two'

    I have another dimension BB with values 'red' and 'green'

    I have several  variables:

    one_red = 1,  one_green=2, two_red=3, two_green=4

     

    how can I build my formula so that when looping through the table, each cell in the table is the right combination?

     

    Pivot table: 

                   red  |  green

    one          1          2

    two           3         4

     

    I tried : $(=Only(AA)) & '_' & $(=Only(BB))   right but not evaluated as a varible 😞

    Any help will be welcome... Thank's in advance

     

    Show Less
  • forum

    New to Qlik Analytics

    Get Max(valid_from) if valid_from <= today

    Hello,I have a price list with a “valid from” date.I always want to load the current price in the load script. How can I do that? I thought maybe some... Show More

    Hello,
    I have a price list with a “valid from” date.
    I always want to load the current price in the load script.

    How can I do that? I thought maybe something similar to what was written in the title.

    Can you help me?

     

    Price valid from
    10,00 01.01.2024
    15,00 15.03.2024
    12,00 01.04.2024
    18,00 01.05.2024
    Show Less
  • forum

    New to Qlik Analytics

    Data loading fails for License Monitor app after the upgrade to version Feb 2024

          hello All,   Hello All, Does anyone facing the dataloading issues with license monitor app in qlik sense?    License app error: I/O error   The ... Show More

     

     

     

    hello All,

     

    Hello All,

    Does anyone facing the dataloading issues with license monitor app in qlik sense? 

     

    License app error:

    I/O error
     
    The error occurred here:
    LogContent: NoConcatenate Load * FROM lib://ServerLogFolder/governanceLicenseLog_7.19.0_file.qvd (qvd) WHERE LogTimeStamp >= '2023-04-23'
     
     
    Thanks
    Vamsi
     
     
    Show Less
  • forum

    App Development

    Sugestão de Melhoria para mudar a cor da linha de total no gráfico de pivot tabl...

    Olá! Gostaria de solicitar a melhoria do gráfico de pivot table para termos a opção de escolher a cor da linha de total baseado em um critério/express... Show More

    Olá!

    Gostaria de solicitar a melhoria do gráfico de pivot table para termos a opção de escolher a cor da linha de total baseado em um critério/expressão.

    Show Less
  • forum

    QlikView App Dev

    How to set a different background color based on value comparison with the row a...

    in Qlikview please: For example, if the value in the 2nd row is lower than in the row above to be colored in green.   Thank you
  • forum

    Qlik Cloud Data Integration

    ServiceNow data connection issue

    HiI'm trying to connect ServiceNow data in Qlik cloud,I was able to connect to ServiceNow instance I see tables but when I click on any of them to see... Show More

    Hi

    I'm trying to connect ServiceNow data in Qlik cloud,
    I was able to connect to ServiceNow instance I see tables but when I click on any of them to see details and pick columns there is nothing but a spinning circle and an error about Qlik Sense error.

    Show Less
  • forum

    Qlik Application Automation

    Can't attach report to sendgrid in automation

    I'm new to automation stuff, I have a table in a sheet of an analysis that I need to send via email. My automation is quite simple: Create Report Add ... Show More

    I'm new to automation stuff, I have a table in a sheet of an analysis that I need to send via email.

    My automation is quite simple:

    Create Report

    Add sheet to report (that is the sheet where the table is built)

    Generate report.

    Send mail.

     

    Now, I'm not able to attach the generated report to the email. First I've tried with the standard "send mail" block, but it was throwing an error due to authentication. Then I moved to Outlook 365 send mail but It still does not support attachement.

    My final choice was the sendGrid module, since I have a sendGrid account. The email is working just fine, i can send mails with text from the automation. The problem is when I attach the generated report. It throws this error:

    message:
    The attachment content is required.
    field:
    attachments.0.content
    help:
     
    As attachment I put the output of the generate report block.
     
    I don't understand how can I solve this
    Show Less
  • forum

    New to Qlik Analytics

    Initial Data Load Too Large - alternatives???

    I'm new to Qlik sense -  I'm a new Qlik Sense business analysis and I'm building a Qlik Sense app for analysis to replace excel VBA code to pull histo... Show More

    I'm new to Qlik sense - 

    I'm a new Qlik Sense business analysis and I'm building a Qlik Sense app for analysis to replace excel VBA code to pull historical purchases for one or more items - IT will no longer support the excel VBA :(. My organization is large and the total number of records in my PO data warehouse exceeds over well over 100M records. Requirement is that I use Qlik Sense to pull the same data as the excel VBA code.

    My only search criteria is item number. There is no limit to time, geography or entity. 

    When i build the SQL to the data warehouse, I write the SQL in the Data Load Editor and it pulls all PO data... over 100M+ records. Couple of challenges:

    1/ When Qlik Sense users attempt to use the app, they often run into Out of Memory errors.

    2/ When the App works, it takes more than 20min for the sheet to display and users can enter item numbers. 

    Questions:

    1/ is this expected behavior for Qlik Sense to frequently result in errors for such large data sets? I filtered the data sets to return about 50M records and it still results in error, sometimes. 

    2/ Is there a way in Qlik Sense to allow users to enter the item numbers BEFORE the initial data load and have only the required item number PO history be pulled? 

    3/ I tried building a QVD file but it takes 20 min to load the data then another 30 minutes to index. Waiting nearly an hour to run a report doesn't seem to make sense. 

    What other options, if any, do i have in Qlik Sense to limit the initial data load? 

    Show Less
  • forum

    Integration, Extension & APIs

    Route multiple QlikSense servers through Nginx

    Hello everyone, We have 2 QlikSense servers in our internal infrastructure and we want to expose these 2 servers externally, through Nginx.We would li... Show More

    Hello everyone,

    We have 2 QlikSense servers in our internal infrastructure and we want to expose these 2 servers externally, through Nginx.
    We would like to be able to access these servers via ourdomain.com/qliksense1 and ourdomain.com/qliksense2.
    Is it possible to configure Nginx to allow this?

    Furthermore, we also require virtual proxies for some of our custom apps and we would like to be able to access the virtual proxy via ourdomain.com/qliksense1/virtualproxy and ourdomain.com/qliksense2/virtualproxy.
    Is this possible?


    Thank you!

    Show Less
  • forum

    App Development

    Delete unwanted data in QVD's.

    Hello Everyone, i have one some data which all are loaded to qlik tables in Sql server that data has been using in qlik Qvd. As per customer requireme... Show More

    Hello Everyone,

    i have one some data which all are loaded to qlik tables in Sql server that data has been using in qlik Qvd. As per customer requirement we have changed filters and applied new logics in the Backend and some data has been updated and deleted in backend. when i'm checking in qliksense that data not reflecting. i have checked with collegues they were saying once data store in the qvd's there no way to modify data in qliksense. is there anyway to update data in Qlik sense.

    can anyone help me on this request.

    Show Less
Leaderboard

Customer Story

Qlik Data Integration & Qlik Replicate story

Qlik enables a frictionless migration to AWS cloud by Empresas SB, a group of Chilean health and beauty retail companies employing 10,000 people with 600 points of sale.

Customer Story

Building a Collaborative Analytics Space

Qlik Luminary Stephanie Robinson of JBS USA, the US arm of the global food company employing 70,000 in the US, and over 270,000 people worldwide.

Location and Language Groups

Choose a Group

Join one of our Location and Language groups. Find one that suits you today!

Collaborate

Healthcare User Group

Healthcare User Group

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

All are welcome

Japan Group

Japan

Qlik Communityの日本語のグループです。 Qlik製品に関する日本語資料のダウンロードや質問を日本語で投稿することができます。

Request to join

Brasil Group

Brazil

Welcome to the group for Brazil users. .All discussions will be in Portuguese.

open to all

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!