Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 217,675 members
  • 7,289 online
  • 1,995,576 posts
  • 149,556 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    Design and Development

    Connecting Talend to Azure SQL Database

    Hi,I'm trying to connect to Azure SQL DB from Talend 7.3 studio. Need some help on how to connect to Azure .Regards,Anitha
  • forum

    App Development

    Bar chart question.

    Hello, Hive Mind, I need your help! I need a Barchart that allows me to format the color of the bars independently via different measures. My example ... Show More

    Hello, Hive Mind, I need your help! I need a Barchart that allows me to format the color of the bars independently via different measures. My example is displaying the productivity of a machine operator vs his goals for a shift. The goal will be a constant - set within the load script, and the customer wants it to be Green, while the other measure is the number of units produced, which needs to be red until it reaches the same value as the goal, at which time it should turn green.

    With the standard Barchart included with Qlik sense, I can use the color by Expression to do what is needed for the units produced, but cannot find a way to color the Goal bar a different color while the units produced is Red. 

    Anyone have an idea or seen an extension that will allow this?

    Show Less
  • forum

    New to Qlik Analytics

    Multiple Single Select (Always one selected)

    In our system, there are two single select fields with a parent-child relationship. Selection of the parent with single unique child is not possible, ... Show More

    In our system, there are two single select fields with a parent-child relationship. Selection of the parent with single unique child is not possible, because that particular child selection is not possible as its unique and is not available for the currently selected parent and that particular parent selection  is not possible as it has only one child.Is there a solution that allows users to make this selections.

    And even if the selection is made possible by default , it creates a locked scenario where the user cannot alter the selection. This occurs because the parent has only one child, leaving no other options available. Is there a solution that allows users to make different selections in this scenario.

    Show Less
  • forum

    App Development

    Format dimension Inline table script

    I have a QV report that I inherited.  It uses an Excel template to read in the left side row labels and the expressions for each cell.  Then there is ... Show More

    I have a QV report that I inherited.  It uses an Excel template to read in the left side row labels and the expressions for each cell.  Then there is an inline table

    This is the excel template-

     

    Brip51_0-1713970985888.png

     

    Then the inline table -

    LOAD
    IF(Match(RowNo(), 1, 4, 6, 10, 15, 17, 20, 22, 26, 29, 31, 34), '<b>') AS _Formatting,
    RowNo() AS _Index,
    _Metric,
    _ExpectedPVCashFlow,
    _Expression2,
    _Expression3,
    _Expression4,
    _Expression5,
    _Expression6,
    _Expression7,
    _Expression8,
    _Expression9,
    _Expression10,
    _CSMLessLRC,
    _Expression11,
    _Expression12,
    _Expression13
     
    FROM $(v_ExcelSource)ToaRe Tracking IFRS PAA.xlsx
    (ooxml, embedded labels, table is IFRSRD);

     

    Then the table uses _metric as a dimension.  Here is the QV report

    Brip51_1-1713971390270.png

     

    I am trying to format the row labels with indentation.  I can make them bold by including

    <b> in the _Format column.

     

    I want to indent particular rows like such –

    CHANGES IN THE STATEMENT OF PROFIT OR LOSS & OCI

        Modified Retrospective

        Fair Value

    Other

    Insurance Revenue

          Incurred claims and other insurance service expenses

          Amortization of insurance acquisition cash flows

              Losses and reversal of losses on onerous contracts

              Adjustments to liabilities for incurred claims

    Insurance Service Expense

        Investment components

    Insurance Service Result

     

     

     

    I have tried to use the format column and &nbsp to insert spaces, but that did not work

    Is this possible to do ?

    Any thoughts on this would be greatly appreciated.

    Thanks,

    Brian

     

    Show Less
  • forum

    New to Qlik Analytics

    How to identify user by email address in an expression in Qlik Sense SaaS?

    Hi, I would like to allow users to see only particular filter fields according to their email addresses. Something like this in the expression for the... Show More

    Hi,

    I would like to allow users to see only particular filter fields according to their email addresses. Something like this in the expression for the field of a table object:

    = if(USER.EMAIL='user1@domain.com', [FIELD1],
        if(USER.EMAIL='user2@domain.com', [FIELD2],
       [DEFAULT_FIELD])) // for other users

     

    And in the access section of the load script something like

    Section Access;

    OMIT_FIELDS:
    Load * INLINE [
        ACCESS, USER.EMAIL, OMIT
       USER, user1@domain.com, FIELD2
       USER, user1@domain.com, DEFAULT_FIELD
     
       USER, user2@domain.com, FIELD1
       USER, user2@domain.com, DEFAULT_FIELD
    ];
     
    Does it make sense? Any idea how to implement this? In the table object no entries are displayed for those users for that field. But other users can see the content of the default field as expected. Thanks for any advice!

     

    Show Less
  • forum

    Connectivity & Data Prep

    MS SQL server or ODBC or OLEDB

    Hi There   when connecting to a sql server is there any logic when one shoudl use a ODBC or a OLE DB or a MS sql serverconnector? Best Indrani Show More

    Hi There 

     when connecting to a sql server is there any logic when one shoudl use a ODBC or a OLE DB or a MS sql serverconnector?

    Best

    Indrani

    Show Less
  • forum

    Data Quality, Preparation & Stewardship

    Talend open studio for data quality

    Hey ! I'm on the lookout for Talend for Data Quality software, but I'm having trouble finding it. Can anyone confirm if it's still available for insta... Show More

    Hey !

    I'm on the lookout for Talend for Data Quality software, but I'm having trouble finding it. Can anyone confirm if it's still available for installation? Any help would be greatly appreciated! Thanks in advance! 🙏

    Show Less
  • forum

    QlikView Administration

    Gerenciamento de Documents cal

    Olá a todos,  sou novo aqui e não tenho muita experiencia,  ouvi falar que existe uma feramenta para gestão de documents cal  mas não a encontrei para... Show More

    Olá a todos,  sou novo aqui e não tenho muita experiencia,  ouvi falar que existe uma feramenta para gestão de documents cal  mas não a encontrei para baixar... alguém tem o instalador?  na licença da empresa que trabalho diz que todas estão em uso mas só consigo ver 15. as outras devem estar perdidas/alocadas em algum lugar. poderiam me ajuda?

    Show Less
  • forum

    App Development

    PUSANTE SELEZIONE

    Buongiorno, Come eseguire una selezione multipla su più elementi in un campo mediante un Pulsante ? (Azione: Seleziona nel Campo...) Con Sense si mett... Show More

    Buongiorno,

    Come eseguire una selezione multipla su più elementi in un campo mediante un Pulsante ? (Azione: Seleziona nel Campo...)

    Con Sense si mette il punto e virgola tra un elemento e l'altro, tra apici...ma in View non funziona...

    Grazie, Maurizio

    Show Less
  • forum

    New to Qlik Analytics

    Default selection in Qlik senses

    Hi guys,I am new in Qlik sense.I have a year and quarter filters, when I open the application, default selection is year 2021 and quarter Q2(previous ... Show More

    Hi guys,

    I am new in Qlik sense.

    I have a year and quarter filters, when I open the application, default selection is year 2021 and quarter Q2(previous quarter),how to do that,also I need to reflect 3 charts when selections applied.

    Please help me anyone.

    Thanks in advance 🙏

    Regards,

    Subba

     

     

     

     

    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!