Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 219,082 members
  • 8,221 online
  • 1,997,842 posts
  • 149,777 Solutions
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    QlikView Administration

    Qlikview upgrade to 12.20 Latest version

    HiI'm planning to upgrade the QlikView server and QlikView Publisher, and the version is 12.20. I need to know the best way to upgrade. Furthermore, I... Show More

    Hi

    I'm planning to upgrade the QlikView server and QlikView Publisher, and the version is 12.20. I need to know the best way to upgrade. Furthermore, I would like to upgrade to May 2021. What are your recommendations, please?

    Greetings

    Show Less
  • forum

    New to Qlik Analytics

    Crear una columan Total en un Grafico

    Buenos dias,   necesito armar un Grafico por mes y por Lugar pero que la ultima columna sea un Total de los otros meses LUGAR Mes Target Valor Actu... Show More

    Buenos dias,

     

    necesito armar un Grafico por mes y por Lugar pero que la ultima columna sea un Total de los otros meses

    LUGAR Mes Target Valor Actual B / (W)
    XXXX 1 52.91416497 90 -61
    XXXX 2 192.4980829 109 -4
    XXXX 3 213.8462115 210 -94
    YYYY 1 57.16937735 137 -105
    YYYY 2 207.9782521 151 -39
    YYYY 3 231.0431388 122 4
    ZZZZ 1 179.1306451 539 -441
    ZZZZ 2 651.6649331 625 -273
    ZZZZ 3 723.934883 577 -185
    HHHH 1 76.34358409 26 15
    HHHH 2 123.3615513 24 42
    HHHH 3 307.3236405 28 138
    RRRR 1 5.15686373 7 -4
    RRRR 2 18.76031461 7 4
    RRRR 3 20.84084239 4 7
    TTTT 1 85.96053278 107 -61
    TTTT 2 312.71849 135 35
    TTTT 3 347.3991187 232 -44
    YTD YTD 3808.044627 3131 -1065

     

    Lucho88_0-1715190208838.png

    El YTD que tengo hoy es el total de los lugares y solo necesito de XXXX

     

    Me podrian ayudar, Muchas gracias!

    Show Less
  • forum

    New to Qlik Analytics

    How to add a blank dimension in a sheet

    Hello, I'd like to add a blank dimension, which mean nothing has to show in that column. What will be the expression for this, or is there any way tha... Show More

    Hello,

    I'd like to add a blank dimension, which mean nothing has to show in that column. What will be the expression for this, or is there any way that I can do this?

    The purpose of this is to facilitate the copy of the data in an Excel sheet that has an extra column compare to the original extract in Qlik.

    Thanks everyone!

    Show Less
  • forum

    Qlik Replicate

    Snowflake Target Endpoint - Support new Hybrid Tables as Targets

    In March of 2024, Snowflake announced that Hybrid Tables are now in QA. Will the Snowflake target endpoint connector be modified to support replicatin... Show More

    In March of 2024, Snowflake announced that Hybrid Tables are now in QA.

    Will the Snowflake target endpoint connector be modified to support replicating data to Hybrid Tables as well as traditional Snowflake tables? Is this on the roadmap?

    https://docs.snowflake.com/en/release-notes/2024/other/2024-03-05-hybrid-tables
    https://docs.snowflake.com/en/release-notes/2024/other/2024-03-13-hybrid-tables

     

    Show Less
  • forum

    Brasil

    Comparação em % Mes anterior e Mes Atual - help

    Bom dia! Estou tentando criar um campo de comparacao em % em uma tabela dinamica com filtros, onde gostaria de fazer (MES ANTERIOR - MES ATUAL) / MES ... Show More

    Bom dia!

    Estou tentando criar um campo de comparacao em % em uma tabela dinamica com filtros, onde gostaria de fazer (MES ANTERIOR - MES ATUAL) / MES ANTERIOR por exemplo
    mes 1 vendeu-se 499 unidades mes 2 vendeu-se 249 unidades ou seja -50% em comparacao ao mes anterior
     oq estou usando é:
    (Count(CardCode_Ab) - Above(Count(CardCode_Ab))) / Above(Count(CardCode_Ab)) * 100 mas esta retornando nada
    os campos da minha view sao: QT = CardCode_Ab(é um count), MES: Mes_Ab e por fim ANO: Ano_Ab

    Livia_MF02_0-1715262458452.png

     

    Show Less
  • forum

    New to Qlik Analytics

    how to show last 6 months Sales in current year and previous year 6 months Sales...

    Hi friends, how to show last 6 months in current year and the same 6 months in previous year in line chart in Qliksense? dimension: inv_months measure... Show More

    Hi friends,

    how to show last 6 months in current year and the same 6 months in previous year in line chart in Qliksense?

    dimension: inv_months

    measure1:=Sum({<Inv_Date={">=$(=addmonths(monthstart(Max(Inv_Date)),-6))<=$(=Max(Inv_Date))"}>}Sales)

    how to write measure2? for example like below table, need to display in line chart

    venky77777_0-1715270418792.png

     

     

    Show Less
  • forum

    Administering and Monitoring

    Trigger in QlikView management control - multiple event

    Hi Team, one of the Task is dependent on 3 other tasks.. so all the other 3 tasks are dependent on each other..  For example: So, instead of kicking ... Show More

    Hi Team,

    one of the Task is dependent on 3 other tasks.. so all the other 3 tasks are dependent on each other.. 

    For example:

    Ranjanac1_0-1715275920278.png

    So, instead of kicking this one by one...

    I have tried to create a trigger " on multiple events completed". but its not working out... Could you please assist..?

    Ranjanac1_1-1715275973637.jpeg

    Thanks & Regards,

    Ranjana 

    Show Less
  • forum

    App Development

    Using GetObjectDimension in Aggr

    Is there way in how we can use the function GetObjectDimension in the Aggr-function?GetObjectDimension returns the name of a dimension, but this is no... Show More

    Is there way in how we can use the function GetObjectDimension in the Aggr-function?

    GetObjectDimension returns the name of a dimension, but this is not sufficient for the Aggr-function. 

    Anyone knows about a possible solution to this problem?

     

    P.S.: Adding square brackets to the function as in '[' & function & ']' won't work.

     

     

    Kind regards,

    Tim P.

    Show Less
  • forum

    Qlik Replicate

    QR: Log stream vs header__timestamp

    Hi, Just need a conformation of header__timestamp in regards to reading from the Log stream task: Is the header__timestamp in the S3 json file the ti... Show More

    Hi,

    Just need a conformation of header__timestamp in regards to reading from the Log stream task:

    Jon_Donker_0-1704753381789.png

    Is the header__timestamp in the S3 json file the timestamp of the change on the source? 

    Or the time the change was written to the log stream?

     

    Show Less
  • forum

    App Development

    Using Set Analysis to Filter a Histogram by Date

    Hello, I'm trying to create a histogram from my data that selects for only the current date.  Currently, I have this as my "Field": ={<[DATE_FIELD] = ... Show More

    Hello,

    I'm trying to create a histogram from my data that selects for only the current date. 

    Currently, I have this as my "Field":

    ={<[DATE_FIELD] = {"$(=Date(Today(), 'M/D/YYYY'))"}>} [VALUE_FIELD]

    But this isn't filtering out the other dates. Is there another approach I should be taking?

    Thanks in advance!

    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!