Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 222,620 members
  • 5,142 online
  • 2,003,555 posts
  • 150,256 Solutions
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik Replicate

    Unable to Create a User Defined Function in Replicate

    Hello all, I have followed the documentation, read the README in the /addons folder, and compiled the sample UDF 'My Transformation' successfully. But... Show More

    Hello all, 

    I have followed the documentation, read the README in the /addons folder, and compiled the sample UDF 'My Transformation' successfully. But the Qlik service is unable to load, and I am thinking it is because there is an error either in the addons_def.json file or something within the .dll. I am unable to figure it out and would appreciate any help.

    Here is my addons_def.json:

    Machholz_0-1718636155824.png

     

    I have already tried using an absolute path as well, but that did not work. Any help is appreciated.

    Thanks 

    Qlik Replicate

    Show Less
  • forum

    Qlik Cloud Data Integration

    Spaces not showing on Qlik Cloud when selecting Movement Data Gateway

    Hi, I'm setting up a data gateway on my Qlik Cloud, I already downloaded and installed the rpm on the linux server and got the certificate key, but wh... Show More

    Hi, I'm setting up a data gateway on my Qlik Cloud, I already downloaded and installed the rpm on the linux server and got the certificate key, but when I try to register the Data Gateway on the Management Console (Management Console->Data gateways->Create) when I select "Data Movement" as my "Gateway Type" it doesn't show the Space that I want the gateway to be associated with (it doesn´t show any of the created spaces), when I select "Direct Access" it shows all my spaces. 

    I already checked the "Considerations when associating the data gateway with a space" and I own the Data Space, I have Professional entitlement on the users manager and I just need to associate the gateway with a single space.

    Could you please let me know if there might be any other reason for this to be happening and if there is a way to solve it?

    Show Less
  • forum

    New to Qlik Analytics

    QLIK Sense Excel-Add In

    Can we use the QLIK Excel Add-in if we use QLIK Sense Enterprise on Windows? I have looked up a few articles and it seems like it is only on the cloud... Show More

    Can we use the QLIK Excel Add-in if we use QLIK Sense Enterprise on Windows? I have looked up a few articles and it seems like it is only on the cloud.  Can someone confirm?

    Thank you!

    https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/excel-add-in-get-started.htm

    Show Less
  • forum

    New to Qlik Analytics

    enumeration case with powers of two and "bitwise &&" case

    Hello all, so there's this challenge this time. I was given this enumeration for the field "ChangeType", which stores 0,1, then powers of 2 like : 0,1... Show More

    Hello all, so there's this challenge this time.

    I was given this enumeration for the field "ChangeType", which stores 0,1, then powers of 2 like : 0,1, 2, 4, ,8, 16, 32, ... etc. The thing is the db table creator uses this enumeration like this- If they enter number 25 then there are three change types f & e & b  because 25=16+8+1, if they enter number 10 there are two changes e & c because 10=8+2.  So for example a person with change type 10 should be counted twice, once for reason 8 and once for reason 2. All I want is to count each person as many times as there are change types for them.

     

    MapChangeType:
    Mapping load * inline [
    ChangeType, ChangeType1
    0,'a'
    1,'b.'
    2,'c.'
    4,'d'
    8,'e'
    16,'f'
    32,'g'];

     

     

    I contacted the db guy and they told me they wrote an sql script with bitwise operator &  like 

    CREATE PROCEDURE [dbo].[sp_Updates]
    @Year INT,
    @UpdateSource INT
    AS
     
    BEGIN
    SET NOCOUNT ON;
     
    INSERT INTO UpdateTable
    SELECT @Year, @UpdateSource, 8, COUNT(*) AS e
    FROM  Table2
    WHERE PreviousYear < @Year
    AND Year = @Year
    AND (@UpdateSource IS NULL OR UpdateSource = @UpdateSource)
    AND ChangeType & 8 > 0

     

    END
     
     
     
    How could I do the equivalent for Qlik Sense?
    This is a much needed step for my further analysis and to be honest, I have no clue what to do so your help will be enormous.
     
    Thank you in advance
    Show Less
  • forum

    Qlik NPrinting

    Download Older Versions

    How get older versions of Nprinting?? Qlik NPrinting 
  • forum

    Deployment & Management

    Set Analysis, strictly less than a variable not working

    hi everyone,  I don't succeed to have a set analysis with a strictly less than a variable working.  My formula is as follow:  sum({<[Pack Sales Start ... Show More

    hi everyone, 

    I don't succeed to have a set analysis with a strictly less than a variable working. 

    My formula is as follow: 

    sum({<[Pack Sales Start Date]= {"<$(=$(vPeriod))"}>}[€ PUB])

    result is 0

    I tried this one: 

    sum({<[Pack Sales Start Date]= {"<=$(=$(vPeriod))"}>}[€ PUB])

    but that gives me a "less or equal than" which I don't want.

    I also tried this: 

    sum({<[Pack Sales Start Date]= {"<$(=vPeriod)"}>}[€ PUB])

    which still gives 0.

    vPeriod = max(Period)

     

    thanks a lot for your help !

    Show Less
  • forum

    Water Cooler

    Suzy's Tips - Why Subscribe to Boards?

    This short video will show you why you should subscribe to boards on the Qlik Community. Stay updated with the latest discussions and never miss out o... Show More

    This short video will show you why you should subscribe to boards on the Qlik Community. Stay updated with the latest discussions and never miss out on important posts. Click the like button if you find this video helpful!

    (Click the YouTube link for a transcript of the video. If you need closed captions, please let us know here!)

    Show Less
  • forum

    Connectivity & Data Prep

    Creating Qlik Cloud Connectors (KeySurvey)

    I'd like to use a connector for a product we have called KeySurvey.  I'm never set up a connector and feel like I am jumping into the deep end.  Is th... Show More

    I'd like to use a connector for a product we have called KeySurvey.  I'm never set up a connector and feel like I am jumping into the deep end.  Is there a step-by-step for this?  A white paper?  or has someone else done this?

    I am assuming there's a cost for each pull.  Our users want the data pulled every hour sometimes and I want to know how much that is, because the frequency tends to make our costs jump.  Does anyone have any costing tools or suggestions for that before going full-steam ahead on this project?

    I hate to say it, but for us it might be cheaper just to automate moving the csv files to where Qlik will pick them up rather than a direct connector.

    Show Less
  • forum

    New to Qlik Analytics

    How to filter data timpe stamp via select in sql?

    Hi All, I need to load part of date (for 24/03/01), but in Oracle Sql Base data form is timestamp. How can I succesffuly obtain it? How can I change d... Show More

    Hi All,

    I need to load part of date (for 24/03/01), but in Oracle Sql Base data form is timestamp.

    How can I succesffuly obtain it? How can I change date form after sql's 'where'?

    Show Less
  • forum

    QlikView App Dev

    Selection of month has to show previous month sales

    Hi, I'm looking for a set analysis expression where if we select an year and month from filter it has to show previous year month sales. Below example... Show More

    Hi,

    I'm looking for a set analysis expression where if we select an year and month from filter it has to show previous year month sales. Below example data.

    Date Market Sales
    2/1/2024 IND 200
    2/24/2024 NAM 100
    1/1/2024 IND 100
    1/21/2024 NAM 200
    1/16/2024 AUS 600
    12/15/2023 IND 300
    9/16/2023 NAM 400
    8/26/2023 AUS 500
    4/13/2022 AUS 600
    5/18/2022 IND 900
    6/10/2022 NAM 700

     

    Below example.

    If I select 2024 from year filter and Feb from month it has to show 2024 Jan values in text objects

    Feb 2024 Jan 2024
    300 900

     

    If I select 2024 from year filter and Jan from month it has to show 2023 Dec values.

    Jan 2024 Dec 2023
    900 300
    Show Less
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!