Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 238,194 members
  • 5,904 online
  • 2,020,626 posts
  • 151,935 Solutions
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    Set expression with dynamic time frame used in aggr functon not working.

    We have created a solution to follow up sales. In the solution we chose a year and one or more months (master dimension). We monitor new customers, lo... Show More

    We have created a solution to follow up sales. In the solution we chose a year and one or more months (master dimension). We monitor new customers, lost customers, customers with sales up and customers with sales down between the chosen period and the same period previous year.

    All is working except "Lost customers" where we don't have sales (transactions) this year, only pervious year.

    In the solution we have created master measures for the calculations with dynamic timeframes, but we struggle with the lost customers. The master measures is used in aggr functions for incorporation three dimensions.

    We belive the problem is with the set expressions in the master measures we have crated. We have attached the qvf file which hopefully explains everything.

    To all you experts - is there a solution for this?

     

     

    EspenH_0-1733409562916.png

     

     

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Network drive map to Qlik cloud

    Hello, I'm looking for solution to add source from Network drive in Qlik Cloud. how we can achieve this? also how we can add Teradata as a source in q... Show More

    Hello,

    I'm looking for solution to add source from Network drive in Qlik Cloud. how we can achieve this? also how we can add Teradata as a source in qlik cloud as I'm getting error 'The Teradata server can't currently be reached over this network'.

     

    Show Less
  • forum

    Qlik Replicate

    Kafka Connector, retries and DLQ

    I'm researching if QLIK replicate can be configured to send messages to another topic called "DLQ" once maximum number of retries has been reached. Ca... Show More

    I'm researching if QLIK replicate can be configured to send messages to another topic called "DLQ" once maximum number of retries has been reached. Can you help me to reply this? 

    If not, what happen when maximum number of retries has been reached?

    Thanks

    Show Less
  • forum

    Security & Governance

    Reloading an External program task in a particular scheduler node

    Hi Everyone, We have two scheduler nodes (S.Node 1 and S.Node2). Due to security reasons, we are trying to trigger couple of batch files in command pr... Show More

    Hi Everyone,

    We have two scheduler nodes (S.Node 1 and S.Node2). Due to security reasons, we are trying to trigger couple of batch files in command prompt in S.Node1 only.  But Qlik sometimes assign the S.Node2 directly due to which the batch files are failing. Currently we are simply trying to pass local path of the batch file in the "Path Section".

    It would be great if you can tell how we can acheive load balancing in this case? Or do we have to tweak the parameters in the External Program tasks. 

    Regards,

    Show Less
  • forum

    Qlik Replicate

    Unable to add UDF to qlik

    Hi team , I had complied a UDF and generated dll and .so file . when I followed the steps from Document , i couldn’t  see my UDF in qlik under express... Show More

    Hi team , 

    I had complied a UDF and generated dll and .so file . when I followed the steps from Document , i couldn’t  see my UDF in qlik under expression builder>>functions>>UDF .

    need some help on this . please let me know if additional details needed 

    followed this . 
    https://help.qlik.com/en-US/replicate/November2023/Content/Global_Common/Content/SharedEMReplicate/Customize%20Tasks/user_defined_transformations.htm#:~:text=the%20Expression%20Builder-,User%2Ddefined%20transformations,%3CINSTALL_DIR%3E%5Caddons%5Csamples%5CMyTransformation,-Information%20note

    Show Less
  • forum

    Qlik Replicate

    different schemas with the same table's names in the one replication task

    I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_... Show More

    I have this situation that I have few schemas with the same table names in every schemas and when I am adding these tables names are changed to table_name_1 and it is replicating with the same name with "_1" which is different name like in the source. I would like to handle it somehow. In old qlik every table was represanted like schema.table_name and it was not any issue when few schemas had the same table names.

    Show Less
  • forum

    Move to SaaS

    Qlik SaaS & Oracle cloud connection

    Hi, we are moving to Qlik SaaS and want to connect to a third party oracle (cloud) Database. Is it required to do this via the direct access gateway c... Show More

    Hi,

    we are moving to Qlik SaaS and want to connect to a third party oracle (cloud) Database.

    Is it required to do this via the direct access gateway connector? Or if the 'oracle' connector can be used, does it need to be an Public IP adress?

    All feedback is appreciated . 

    Show Less
  • forum

    New to Qlik Analytics

    Getting 2nd and 3rd values

    Hi All,I have data like below       I want get maximum month, previous maximum month and previous to previous month example like belowFor name HGI, m... Show More

    Hi All,
    I have data like below

    Saritha077_2-1733380560163.png

     

     

     

    I want get maximum month, previous maximum month and previous to previous month example like below
    For name HGI, months like below
    maximum month = Jun 2023, previous maximum month = 6/8/2022, previous to previous month = 5/29/1999

    I am creating a table with Name, reporting month as Aggr(Max(reporting month), Name) and expressions like below are 
    1st expression :  

    (Sum({<reporting_month={"$(vMaxmonth)"}>}Amount) - Sum({<reporting_month={"$(vPrevMonth)"}>}Amount)) /

    Sum({<reporting_month={"$(vPrevMonth)"}>}Amount)

    2nd expression : 

    (Sum({<reporting_month={"$(vPrevMonth)"}>}Amount) - Sum({<reporting_month={"$(vPrev3rdvalue)"}>}Amount)) /

    Sum({<reporting_month={"$(vPrev3rdvalue)"}>}Amount)

    Saritha077_3-1733380890191.png

     

    Variable are like below 
     

    Saritha077_4-1733380920940.png

     

    See below able

    Saritha077_0-1733381559190.png

    For HGI it is showing 840369, same way in 2nd expression it is suppose to show 8051165775.05686 but is showing empty. seems have an issue with expression while fetching 2nd previous record.

     

    But it is not  working as expected , please help me someone to achieve this
    thanks in advance

    Regards,

    Saritha

    Show Less
  • forum

    App Development

    Qlik reporting sending blank reports

    Qlik reporting tool in qlik cloud is sending blank reports . Data is not coming in reports , what to do ?  
  • forum

    Connectivity & Data Prep

    Store .QVD files in AWS S3 buckets

    Hi, I am using Qlik sense Enterprise on windows of qlik sense server 14.129.6(May 2023). I need to store the QVD files in S3 bucket. but i am getting ... Show More

    Hi,

    I am using Qlik sense Enterprise on windows of qlik sense server 14.129.6(May 2023).

    I need to store the QVD files in S3 bucket. but i am getting error as can't open file...

    while making connection to S3, i am not getting option of SSE header(which i get to know while searching the error).

    so is the issue related to qlik sense version or what would be the reason?

    Thank you!

    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!