Skip to main content

Welcome to
Qlik Community!

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

Welcome to Qlik Community

Recent Discussions

  • 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

    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

    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

    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
  • forum

    New to Qlik Analytics

    Include NULL Values Handling in KPI charts in Qlik sense

    Hello Everyone, I have an issue with the Set expression in KPI chart. i'm calculating the percentage in my expression i'm using Parent incident id for... Show More

    Hello Everyone,

    I have an issue with the Set expression in KPI chart. i'm calculating the percentage in my expression i'm using Parent incident id for this column is having Null values i want to calculate the Null values. but while calculating the t column not considering. please find the below expression

    Num(sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Status]={0},[Parent Incident ID]={'Null'}>}[Ticket Count])/sum({<Goal={'Cpi - Critical - Restore'},ID={'365'},Reported_13Month={1},[Parent Incident ID]={'Null()'}>}[Ticket Count]),'##.##%')

    please anyone can help me on this.

    Show Less
  • forum

    Move to SaaS

    ⚠️ Upcoming change in Qlik Sense Mobile concerning the clientplatform() function

    This week we plan to fix a product defect concerning Qlik Sense Mobile, where the function clientplatform() does not return the correct value. Current... Show More

    This week we plan to fix a product defect concerning Qlik Sense Mobile, where the function clientplatform() does not return the correct value.

    Current, wrong, values:
    Android: ‘okhttp/4.10.0’
    iOS/iPadOS: (blank value)

    New, correct, values:
    The User agent is not going to be a static value: instead, it’s going to differ over time depending on the device that is used, with a mention of either Android or iPhone/iPad in the string.
    Some examples:
    iOS
    : Mozilla/5.0 (iPhone; CPU iPhone OS 17_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Mobile/15E148 Safari/604.1
    Android: Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36

     

    This might have an impact in case anyone is currently using the wrong value as a logic switch for presentation (i.e. whether to show or not show something to users according to the client used)

    Show Less
  • forum

    App Development

    ⚠️ Upcoming change in Qlik Sense Mobile concerning the clientplatform() function

    This week we plan to fix a product defect concerning Qlik Sense Mobile, where the function clientplatform() does not return the correct value. Current... Show More

    This week we plan to fix a product defect concerning Qlik Sense Mobile, where the function clientplatform() does not return the correct value.

    Current, wrong, values:
    Android: ‘okhttp/4.10.0’
    iOS/iPadOS: (blank value)

    New, correct, values:
    The User agent is not going to be a static value: instead, it’s going to differ over time depending on the device that is used, with a mention of either Android or iPhone/iPad in the string.
    Some examples:
    iOS
    : Mozilla/5.0 (iPhone; CPU iPhone OS 17_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Mobile/15E148 Safari/604.1
    Android: Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36

     

    This might have an impact in case anyone is currently using the wrong value as a logic switch for presentation (i.e. whether to show or not show something to users according to the client used)

    Show Less
  • forum

    New to Qlik Analytics

    VizLib replacement

    Hi All,I am working on vizlib library replacements in QSi have to add one inbuilt Filter pane in place of vizlib filter paneIn that Vizlib filterpane ... Show More

    Hi All,

    I am working on vizlib library replacements in QS
    i have to add one inbuilt Filter pane in place of vizlib filter pane

    In that Vizlib filterpane , Dimension added in CLeveleSelect
    and Filter values condition given as     =IF(ONLY({1} CNLevelOrder)<14,True(),False())

    So in VizLib Filterpane LevelSelect values are shown based on above condition,

    how to show the same in in bulit Qlik filter pane

    Please reply back 
    Thanks

    Show Less
  • forum

    Mobile

    ⚠️ Upcoming change in Qlik Sense Mobile concerning the clientplatform() function

    This week we plan to fix a product defect concerning Qlik Sense Mobile, where the function clientplatform() does not return the correct value. Current... Show More

    This week we plan to fix a product defect concerning Qlik Sense Mobile, where the function clientplatform() does not return the correct value.

    Current, wrong, values:
    Android: ‘okhttp/4.10.0’
    iOS/iPadOS: (blank value)

    New, correct, values:
    The User agent is not going to be a static value: instead, it’s going to differ over time depending on the device that is used, with a mention of either Android or iPhone/iPad in the string.
    Some examples:
    iOS
    : Mozilla/5.0 (iPhone; CPU iPhone OS 17_4_1 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Mobile/15E148 Safari/604.1
    Android: Mozilla/5.0 (Linux; Android 10; K) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/114.0.0.0 Mobile Safari/537.36

     

    This might have an impact in case anyone is currently using the wrong value as a logic switch for presentation (i.e. whether to show or not show something to users according to the client used)

    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
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!