Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 230,737 members
  • 3,010 online
  • 2,013,313 posts
  • 151,130 Solutions
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More

Welcome to Qlik Community

Recent Discussions

  • forum

    App Development

    Previous year sales with Month in Dimension

    Hi, I need to show "Same Month Previous Year" Sales numbers (As shown below in Column E) in a table. The month itself is in the dimension. My current ... Show More

    Hi,

    I need to show "Same Month Previous Year" Sales numbers (As shown below in Column E) in a table. The month itself is in the dimension. My current expressions are:

    Sales: Sum({<[Report Type] = {'Monthly'}, AS_OF_DATE = >}Sales)

    Sales Previous Month: Above (Sum({<[Report Type] = {'Monthly'}, AS_OF_DATE = >}Sales)) 

    Need help with the expression for "Sales Prev Year".  

    BhaskarSharma_0-1726157796376.png

    Appreciate any help!

    Regards,

    Bhaskar

    Show Less
  • forum

    New to Qlik Analytics

    Export data

    Hi, How to export Data in Qmc and audit data to local system ,I was using qliksense enterprise 
  • forum

    New to Qlik Analytics

    Qlik Label mapping from defined seprate table

    Hi All, Can you pleae help me to get Label names from second table to replace IDs in the first table.  Source :  Name ID CID ZID Arunesh 1001 200... Show More

    Hi All,

    Can you pleae help me to get Label names from second table to replace IDs in the first table. 

    Source : 

    Name ID CID ZID
    Arunesh 1001 2001 3001
    Ramesh 2001 3001 40001
    Nancy 5001 7001 6001

     

    Map of label:

    Field Label
    ID ScreenId
    CID CountryId
    ZID ZoneID

     

    output:

    Name ScreenId CountryId ZoneID
    Arunesh 1001 2001 3001
    Ramesh 2001 3001 40001
    Nancy 5001 7001 6001

     

    I am having too many colums so lookng some some automated way in the script. 

    Thanks in advance!

    Best Regards,

    Arunesh

    Show Less
  • forum

    New to Qlik Analytics

    Qlik Sense Script - removing duplicates based on priority field

    Hi Qlik Sense Community, Hope this question finds you well. I need your help to identify the the specific error and solution. The error message I get ... Show More

    Hi Qlik Sense Community,

    Hope this question finds you well.

    I need your help to identify the the specific error and solution. The error message I get is :"Invalid expression" for HighestPriorityFlag in my codes written below.

     

    For your context, I have defined my definition of duplicates:

    if ID and DT_INTERVENTION are the same in other rows, then they are duplicates (highlighted in ythe screenshot below). The error occured when I tried to add a column for row_flag (red column in the screenshot)

    Newbie_QLIK_0-1726155530869.png

    The followings are my codes. Could you kindly let me know why it does not work?

    Thank you so much in advance!

    //Remove duplicates and keep the first row of sorted priority
    HighestPriorityFlag:
    LOAD
    *,
    If(priority = FirstSortedValue(priority, [ID]&[DT_INTERVENTION]), 'Keep', 'Remove') AS row_flag
    RESIDENT OriginalDataWithPriority
    GROUP BY [ID], [DT_INTERVENTION], priority;

    FinalData:
    NOCONCATENATE
    LOAD *
    RESIDENT HighestPriorityFlag
    WHERE row_flag = 'Keep';

    Show Less
  • forum

    Qlik Application Automation

    Label mapping from separate table

    Hi All, Can you pleae help me to get Label names from second table to replace IDs in the first table.  Source :  Name ID CID ZID Arunesh 1001 20... Show More

    Hi All,

    Can you pleae help me to get Label names from second table to replace IDs in the first table. 

    Source : 

    Name ID CID ZID
    Arunesh 1001 2001 3001
    Ramesh 2001 3001 40001
    Nancy 5001 7001 6001

     

    Map of label:

    Field Label
    ID ScreenId
    CID CountryId
    ZID ZoneID

     

    output:

    Name ScreenId CountryId ZoneID
    Arunesh 1001 2001 3001
    Ramesh 2001 3001 40001
    Nancy 5001 7001 6001

     

    I am having too many colums so lookng some some automated way in the script. 

    Thanks in advance!

    Best Regards,

    Arunesh

     

    Show Less
  • forum

    Qlik Replicate

    CDC Taking Time

    Hello Community, We are facing performance issues while bulk insert and updates comes from source, as they too long to reflect on the target. we've ch... Show More

    Hello Community,

    We are facing performance issues while bulk insert and updates comes from source, as they too long to reflect on the target. we've checked both source and target availability, and everything seems fine, but the changes are accumulating at the target apply disk, as shown in the screenshot below.

    Pranita123_0-1726154830201.png

    we also enabled verbose logging for both source and target apply performance but haven't been able to identify any specific issue. any suggestions from our community member on how to resolve this would be greatly appreciated.

    Thank you,

    Pranita

     

    Show Less
  • forum

    Women Who Qlik

    Women Who Qlik Virtual Meetup- Join us!

    Come connect and network with the inspiring Women Who Qlik community! Join us on September 24 for an engaging panel discussion on career advancement,... Show More

    Come connect and network with the inspiring Women Who Qlik community!

    Join us on September 24 for an engaging panel discussion on career advancement, professional growth, personal branding, and more. This is an open forum for you to bring your questions and ideas while sharing insights with fellow data enthusiasts and industry leaders.  

    Whether you're looking to learn, share, or connect—everyone is welcome. If you're passionate about data and AI and want to be part of a network that champions women in the industry, this Meetup is for you!  

    The first 25 attendees to register will receive an exclusive Women Who Qlik t-shirt! 

    When: Tuesday, September 24 at 11am ET / 4pm UK / 5pm CEST

    Where: Zoom Register here 

    Featuring panel discussion moderated by: 

     

    See you then! 

    Show Less
  • forum

    New to Qlik Analytics

    Date sorting problem in a 2-lines chart

    Hello Community!  First of all excuse my bad english.  I had to do a graph that compares 2 different years, and more specifically n days at the near-e... Show More

    Hello Community! 

    First of all excuse my bad english. 

    I had to do a graph that compares 2 different years, and more specifically n days at the near-end-period. Basically it looks the n days before 31/05/2024 and n days before 31/05/2023, i show it in the same graph in 2 different lines with the same scale. For exemple for the 1st of September i want to see in my graph 01 Sept in the dimension and 1000€ in blue for 2024 and 2000€ in red for 2023.

    MyDate is at format DD/MM/YYYY and i am doing this : 

    Dimension : 

     

    Day(MyDate) & ' ' & Month(MyDate)

     

    Measure 1 : 

     

    Sum({< MyDate = {"=MyDate>= Num(Date('$(vDateMax)','DD/MMM')) - $(vNearPeriodEnd)"} >} Amount)

     

     Measure 2 : 

     

    Sum({<MyDate={"=MyDate<= Num(Date('31/05/23','DD MMM')) and MyDate>=Num(Date('31/05/23','DD MMM'))- $(vNearPeriodEnd)"}>}Amount)

     

     

    And it works very well,

    BUT i can't sort dates in the chronological order (without taking care of the year) and i tried lot of things : 

    Sorting by expression with "MyDate" or "Day(MyDate) & ' ' & Month(MyDate)" or Numerically or Alphabetically and i tried to create in the script "Date(NewDate,'DD MMM') as NewDate" and still doesnt work 

    Hope some of you have an idea. 

    Thanks !! 

    Val

    Show Less
  • forum

    New to Qlik Analytics

    Match in Load Script - function argument

    Hi! I have a parameterized "match" function in load script. That is, I have a variable that handles arguments in the "match" function. In several pla... Show More

    Hi!

    I have a parameterized "match" function in load script. That is, I have a variable that handles arguments in the "match" function. In several places I would like it to stay that way, but for match to contain all the data for the field.

    The question is, what to enter in match so that it "takes" everything?

    match(XXX,'*') doesn't work, does it?

    Show Less
  • forum

    Qlik Replicate

    SQL server endpoint encountering error

    We received an email alert from Qlik Replicate saying a task has the following error. The issue happens frequently though is not causing any issues. T... Show More

    We received an email alert from Qlik Replicate saying a task has the following error. The issue happens frequently though is not causing any issues. The task was able to resume, did not cause error.

    Please share how to resolve this.

    =========

    TASK_AA replication task encountered the following error:

    Stream component 'st_0_TASK_AA' terminated Stream component failed at subtask 0, component st_0_TASK_AA Error executing source loop Endpoint is disconnected Encountered an unexpeceted error.

    do_organize_fetched_row(...) failed in executing mssql_get_table_tlog_attributes(...)

    Failure in querying for compression setting for table 'dbo.MASTERTABLE'

    RetCode: SQL_ERROR  SqlState: HYT00 NativeError: 0 Message: [Microsoft][SQL Server Native Client 11.0]Query timeout expired Failed (retcode -1) to execute statement: '

    select p.data_compression from sys.partitions p,sys.objects o  where p.object_id = o.object_id

     and   schema_name(o.schema_id ) = N'dbo'

     and      o.name=N'MASTERTABLE'

    '.

    Show Less
X
Leaderboard

Customer Story

Accelerating Decision-Making with Qlik Insights

Qlik enhances decision-making with high-speed insights, as Mayborn Group integrates data from various functions across their global operations, gaining a competitive edge in the childcare industry.

Customer Story

Efficiency in Agriculture: Nortera's Qlik Triumph

Nortera leads agricultural manufacturing analytics and automation with Qlik, reducing short-shipment rates and annual savings in water consumption.

Customer Story

Revolutionizing aircraft production through Data Analytics

Qlik Data Integration transforms Airbus' aircraft production, leading to over 150 replication tasks and informing more efficient analysis.

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!