Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 218,834 members
  • 6,118 online
  • 1,997,371 posts
  • 149,738 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Cloud Data Integration

    Data Gateway Movement limitation

    Hello Qlik Team,   Are there any limitations on the number of connections using one QCDI gateway ? Can I utilize the data gateway server for multiple ... Show More

    Hello Qlik Team,

     

    Are there any limitations on the number of connections using one QCDI gateway ?

    Can I utilize the data gateway server for multiple source connections?

    Could you please advise on the best practices in this regard?

     

    Regards,
    Harsh

    Show Less
  • forum

    App Development

    QMC task prioritization while waiting for node

    Hi,Is it possible to configure QMC settings so that certain highly important task can be prioritized (bumped to the front of the line) while waiting f... Show More

    Hi,
    Is it possible to configure QMC settings so that certain highly important task can be prioritized (bumped to the front of the line) while waiting for a node?
    My environment is only set to run 13 tasks at a time and all other tasks need to wait for a spot to open up.

    Qlik Insight Advisor

    Show Less
  • forum

    New to Qlik Analytics

    Set expression to display previous year December values (with if statement insid...

    I want to create a Column 'Equity Previous Year December' to display Equity for the Previous year's December values against the PERIOD_YEAR_MONTH colu... Show More
    I want to create a Column 'Equity Previous Year December' to display Equity for the Previous year's December values against the PERIOD_YEAR_MONTH column ranging from 2023-01 to 2024-03

    PERIOD_YEAR_MONTH Equity current period Equity Previous Year December
    2024-03
    2024-02
    2024-01
    2023-12
    2023-11
    --
    --
    2023-01
    2022-12
    324234
    755456
    342555
    657574
    2131821
    --
    --
    485325
    723944
    657574
    657574
    657574
    723944
    723944
    --
    --
    723944
     
     
    I tried the set expression below but only the first part of if condition gets evaluated. How can I achieve my goal? 😕 

    =Sum({< 
         PERIOD_YEAR = {"$(=If(PERIOD_YEAR = '2024', '2023', '2022'))"}, 
         PERIOD = { '12' }
        >}
    Total Equity current period)

     

    Show Less
  • forum

    掲示板

    أعمال تهييج جلب الحبيب (00.966.57ِ8385.770)تحقيق الوفاء في العلاقة

        そこで、PrivateLink​でサーバー(EC2)とTalendCloudを接続して、インストーラをダウンロードできないか考えています。
  • forum

    App Development

    Crosstable Challenge. SalesMan Comissions by Product Group

    Hi guys, I have an input table with the % of comission for each Product Type Sale for each SalesMan.  The table looks like this (in the real case the ... Show More

    Hi guys, I have an input table with the % of comission for each Product Type Sale for each SalesMan. 

    The table looks like this (in the real case the SalesManID is dynamic, it's not only for 4 salesman) :

            4 5 12 14
    CompanyCode FamilyCode SubFamilyCode FamilyDescription SalesmanId4 SalesManId5 SalesManId12 SalesManId14
    1 ANIM ********** XXX 10% 5% 10% 10%
    1 APPR ********** YYY 5% 10% 5% 10%
    1 AV ********** ZZZ 10% 10% 10% 5%

     

    And I'd like to get an output of a desired table like this :

    FamilyCode SalesManId %Comission
    ANIM 4 10%
    ANIM 5 5%
    ANIM 12 10%
    ANIM 14 10%
    APPR 4 5%
    APPR 5 10%
    APPR 12 5%
    APPR 14 10%
    AV 4 10%
    AV 5 10%
    AV 12 10%
    AV 14 5%

     

    Could anybody help me please? I don't know if crosstable it's the best option, I'm trying to do it but with no results.

    PD : I've attached the example in excel, in order to make it easier for everyone to understand.

    Kind regards, Marcel.

    Show Less
  • forum

    Qlik Cloud Data Integration

    Exclude Numbers from Data

    Hi, I was wondering is there was a way to exclude numbers from a result.For example: The data I have being returned looks like this: "First Group Name... Show More

    Hi, I was wondering is there was a way to exclude numbers from a result.

    For example:

    The data I have being returned looks like this:

    "First Group Name123456789"

    "Second Group Name116416512"

    "Third Group Name987654321"

     

    I would like to just return everything before the first number. So it would return:
    "First Group Name"
    "Second Group Name"

    "Third Group Name"

    Show Less
  • forum

    掲示板

    أسرار الحب لجلب الحبيب00.966.57ِ8385.770💯التغلب على المشاكل الزوجية

        インターネット環境がないサーバー(EC2)にTalendStudioのインストーラを持っていきたいと考えています。
  • forum

    New to Qlik Analytics

    Insert Data in column

    Hello, i need help please :  i have the following data :  ORD_Number MOV_Material  MOV_Reference  5102742773 5009583994 76840059   4041989847 7... Show More

    Hello, i need help please : 

    i have the following data : 

    ORD_Number MOV_Material  MOV_Reference 
    5102742773 5009583994 76840059
      4041989847 76840059006_0393
      4041989973 76840059007_0393
      4041990003 76840059002_0393

     

    FOr exemple, i passed a command with mov_reference 76840059, that generated me a ORD_Number 5102742773. 

    Later on, i had a problem with my command (76840059). i created 3 new lines (76840059006_0393, 76840059007_0393, 76840059002_0393) that represents the Mov_Reference of each problem i had. By Default, there is no ORD_Number Attached to theses lines. 

    Also note that the first 8 caracters of these 3 lines represents the initial mov_reference 76840059.

    Note that this is just an example, i have many commands in my data source

    In qlik, i want a code that will help me replace the empty values or null values in ORD_Number by that of the original MOV_Reference, for each MOV_Reference

    here is the result at the end : 

    ORD_Number MOV_Material  MOV_Reference 
    5102742773 5009583994 76840059
    5102742773 4041989847 76840059006_0393
    5102742773 4041989973 76840059007_0393
    5102742773 4041990003 76840059002_0393


     

    Show Less
  • forum

    New to Qlik Analytics

    How to carry forward the extra selections on default bookmark within the sheets

    Hi All, I have created a default bookmark selections for all sheets. I'm selecting few extra selection in a sheet with default bookmark and switching ... Show More

    Hi All,

    I have created a default bookmark selections for all sheets. I'm selecting few extra selection in a sheet with default bookmark and switching to another sheets. Post switching to another sheet i'm only able to see the default bookmark not the extra selections with it.

    I want to carry the extra selections with default bookmark when i switching the sheets within the application.

    Thank you in advance!

    Daya

    Show Less
  • forum

    掲示板

    جلب الحبيب مضمون💯𝟓𝟳𝟖𝟑85𝟳70 0𝟬𝟗𝟞𝟞♻️سحر محبة البحرين

    これはライセンスの問題でしょうか?(TalendCloudは試用期間のものを使用しています)​
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!