Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,317 members
  • 5,386 online
  • 1,989,540 posts
  • 149,021 Solutions
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    How to create incremental load using 2 fields ?

    Hi I trying to write script of an incremental load using 2 fields (VehicleID , RowID). I would appreciate your help in writing the code for the proces... Show More

    Hi

    I trying to write script of an incremental load using 2 fields (VehicleID , RowID).

    I would appreciate your help in writing the code for the process of incremental loading.

    I want to take each time the new Data (Increment), which does not appear in the existing table, and add it to the existing data (Initial Data) and update if data was changed. 

    Thanks. 

    Initial Data: 

    VehicleID RowID
    12345 1
    12345 2
    12345 3
    21212 1

     

    Increment: 

    VehicleID RowID
    12345 4
    21212 2
    34343 1
    Show Less
  • forum

    Design and Development

    Convert Datetime to Integer

    Hi, i need to convert Datetime to Integer in Talend - First i convert datetime to string  TalendDate.formatDate("yyyy-MM-dd HH:mm:ss:SSSS",row4.TimeSt... Show More

    Hi, i need to convert Datetime to Integer in Talend

    - First i convert datetime to string 

    TalendDate.formatDate("yyyy-MM-dd HH:mm:ss:SSSS",row4.TimeStamp)

    - Second i convert string to integer

    StringHandling.LEFT(Var.var1,4) ==> as var2 (for getting date in expression)

    Integer.valueOf(Var.var3) ==> (in output table)

    but get wrong like below

    asafrian1700127126_0-1710824448201.png

    There is no null data from the original table.

    Then I added the following command and the data was successfully streamed but something went wrong in the YEAR column 
    Var.var2!=null?Integer.parseInt(Var.var2):null

    the result 

    asafrian1700127126_1-1710824911166.png

    The year column contains a NULL value and the data contents in the YEAR column are not aligned with the rows so they do not match the TimeStamp column.

    Can you help to resolve this problem?

    Show Less
  • forum

    QlikView App Dev

    Unable to Fire Macros

    I wrote the below Macro code using VBScript  I know the code is correct. Anytime I press the button attached to macro on my system instead of the scri... Show More

    I wrote the below Macro code using VBScript  I know the code is correct. Anytime I press the button attached to macro on my system instead of the script to fire it was reopening the macro editor. please, what can I do apart from changing module security to system access in which I did but it is not running. 

    Sub HideTabRow
    Set DocProp = ActiveDocument.GetProperties
    DocProp.ShowTabRow=False
    ActiveDocument.SetProperties DocuProp
    End Sub

    Sub ShowTabRow
    Set DocProp = ActiveDocument.GetProperties
    DocProp.ShowTabRow=True
    ActiveDocument.SetProperties DocuProp
    End Sub

     

    Show Less
  • forum

    New to Qlik Analytics

    map in qlikview

    This is the tableau sheet denoting sales and profit of a country in a map how can i achieve it in qlikview.Size of bubble depending on sales.and colo... Show More

    Madhura_1-1710786162738.png

    This is the tableau sheet denoting sales and profit of a country in a map how can i achieve it in qlikview.Size of bubble depending on sales.and color gradient depend on profit.

    Show Less
  • forum

    New to Qlik Analytics

    Matching Disunified Data

    I have 2 sheets that I am trying to use to obtain the scores of that particular device but the data is not unified automatically because the values di... Show More

    I have 2 sheets that I am trying to use to obtain the scores of that particular device but the data is not unified automatically because the values differ slightly. How do I go about creating a formula that will match the "buzz values" to the cell I am trying to pull data from? Below is an example of what I am dealing with: I want the data value on the right to automatically associate the score from the data on the left by matching key words/value. 

     

    m_white_0-1710786586892.pngm_white_1-1710786600611.png

     

    Show Less
  • forum

    Qlik Replicate

    Qlik Replicate Filter Expression

    Hi everyone, I wanted to apply the below filter on replicate but dont know whats the correct syntax for that , can someone help me on this select * fr... Show More

    Hi everyone,

    I wanted to apply the below filter on replicate but dont know whats the correct syntax for that , can someone help me on this

    select * from CMS_BDR_AGG_GROUP where keysum not in (select distinct '%X'||agg_id||'X%' as keysum from CMS_REF_AGG where (agg_type=3 and NAME='HBCA') OR (agg_type=2 and NAME like '%HBCA%')) ;

    MSSOT_RIVA_HSBC1_0-1710822642487.png

    MSSOT_RIVA_HSBC1_1-1710822844065.png

     

    Show Less
  • forum

    New to Qlik Analytics

    Top N

    I have been following the Top N the example on YouTube, but I guess I lost.   While the example only looks at Brand and Sales In my example. I group F... Show More

    I have been following the Top N the example on YouTube, but I guess I lost.

     

    While the example only looks at Brand and Sales

    In my example. I group Function, Name on Sales

    When I do the of

     

    Rank(Sum(Sales), Function, Name)<=10

    It tested for -1 and 0. -1 means the Sales falls within the Top 10

    However, when I try to bring the actual result so I can use variable input, it does not work.

    This is what I am using to try to filter the column for only the Top 10

    Sum(

    {<

    Function, Name={“= Rank(Sum(Sales), Function, Name)<=10

    ”}

    >}

    Sales)

     

    Show Less
  • forum

    New to Qlik Analytics

    Color Expression issue with Dimension group

    Hi Team, I've created a bar graph in Qlik, where I've organized the data by month to visualize both January and February. Each bar represents four mon... Show More

    Hi Team,

    I've created a bar graph in Qlik, where I've organized the data by month to visualize both January and February. Each bar represents four months of data; for example, in the January bar graph, I'm displaying data from October, November, December, and January. I've implemented a condition in the graph where the color of the bar changes based on certain criteria. If the percentage of the smallest month's classification is less than 100%, the bar turns red. If it equals 100%, the bar turns green. Otherwise, all other months will be represented in blue. This condition is working correctly for January, but not for February. What might be the reason for this discrepancy?
     
    Formula used in Color expression:
     
    if((['Month-Year']) = Min(total(['Month-Year'])) and [Percentage Classified] < '100.0%' and ['Month-Month'] = 'January' or ['Month-Month'] = 'February', 'Red', 
    If((['Month-Year']) = Min(total(['Month-Year'])) and [Percentage Classified] = '100.0%' and ['Month-Month'] = 'January' or ['Month-Month'] = 'February', 'Green', 'Blue'))

     

    Attached are the visualization that i need and currently i am getting

     

    @sunny_talwar Qlik Sense Business 

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    How to connect SQL server into QlikView

    Hi, I have databases in PostgreSQL, and I want to import data from PostgreSQL into QlikView. How can I do that? Thanks
  • forum

    Qlik Replicate

    AWS RDS for Postgres as source - supported versions

    Hi Qlik Community Replicating from a Postgres read replica is merely impossible on the currently supported versions. However, Postgres 16.1 does allow... Show More

    Hi Qlik Community

    Replicating from a Postgres read replica is merely impossible on the currently supported versions. However, Postgres 16.1 does allow read/write on read replicas which enables setting the wal level to 'logical' on the read replica. This is significant progress as Teams opt to use read replicas instead of replicating directly from the primary instance.

    That said, there's limitations like enabling 'Create DDL events' and 'WAL heartbeats'. We'd like to capture the DDL events, and also benefit from keep the slots alive. But these require a 'create statement being run, and Postgres 16.1 is also not supported. Currently we don't have a solution for reading from a Postgres read replica if we want to replicate changes - 'cause full load works but not viable for large databases.

    Can I ask if there's plans to include Postgres 16.1 on the supported source endpoints. If so, when? And if we'd be able to replicate from a read replica, plus benefit from 'Create DDL events' and 'WAL heartbeats'.

    Regards.

    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!