Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 220,683 members
  • 3,122 online
  • 2,000,344 posts
  • 149,981 Solutions
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Welcome to Qlik Community

Recent Discussions

  • forum

    Qlik NPrinting

    Nprinting not reload well after migration to new serer and QlikNPrinting Messagi...

    Hi,  I working with Nptinting version May2021 with Qlik Sense, We copied the entire Nprinting server to another machine, copying as it is, the compute... Show More

    Hi, 

    I working with Nptinting version May2021 with Qlik Sense, We copied the entire Nprinting server to another machine, copying as it is, the computer name and the IP remain the same.

    Currently I can log in but the page seems to be stuck on loading... 

    All services are working except QlikNPrinting Messaging Service that falls after a few seconds.

    I followed this guide - But got errors 
    https://help.qlik.com/en-US/nprinting/February2024/Content/NPrinting/Troubleshooting/Qlik-NPrinting-Messaging-Service-startup-connection-problems.htm

    How do I continue from here?
    Is it possible to make a migration \ copy using this method and success to run Nprinting?

    Thanks 

    Qlik NPrinting 

    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 Replicate

    is there any option like : repctl exportrepository all, so all tasks exported in...

    is there any option like : repctl exportrepository all, so all tasks exported in separate json files I understood,  repctl -d <"...Attunity\Replicate\... Show More

    is there any option like : repctl exportrepository all, so all tasks exported in separate json files

    I understood, 

    repctl -d <"...Attunity\Replicate\data"> exportrepository <------ This will export all tasks in single json file

    repctl -d <"...\data"> exportrepository exportrepository task=<"taskname"> <--- will export a single task in a single json

    Is there any option like:

    repctl -d <"...\data"> exportrepository all  <<<<<< something like this, which will export all tasks but in separate individual json files?

    Kindly advise

    with regards,

    Selvakumar S

    Show Less
  • forum

    Qlik Replicate

    Task is in recoverable state

    Hi Team, We are getting below error  02234508688: 2024-05-25T22:07:06 [SORTER_STORAGE  ]E:  The Transaction sorter. Cannot get buffer for self committ... Show More

    Hi Team,

    We are getting below error 

    02234508688: 2024-05-25T22:07:06 [SORTER_STORAGE  ]E:  The Transaction sorter. Cannot get buffer for self committed transaction.  [1022101]  (transaction_storage.c:1065)

    Source SAP

    target: Azure sql

    full load + cdc task

    Request your help on this.

    Thanks.

     

     

    Show Less
  • forum

    New to Qlik Analytics

    Convert Zero to Nulls in UI measure

    Hi all, Is it possible to convert zeros into Nulls as a calculation result of a measure? For example,The second measure (in purple) get 0 in 2024-01 t... Show More

    Hi all,

    Is it possible to convert zeros into Nulls as a calculation result of a measure?

    For example,
    The second measure (in purple) get 0 in 2024-01 to 2024-03, so the first value should be in April.
    I made it with If function but it's less convenient in complex measures.
    It didn't work if I just uncheck 'Include Zero Values'.
    I'm looking for a function like Alt that can convert the Nulls to Zero.

    Thanks!

    Amit_B_1-1716735734091.png

    Show Less
  • forum

    Stitch

    ETL Engine: not an Ad... this is open source, free for download... libre and gra...

    no money requested...  open source... a vibrant natural  rain forest makes a product strong. https://tseeq.net        
  • forum

    Catalog and Lineage

    Tableau to Qlik

    Was wondering if anyone can share their experience transitioning from Tableau to Qlik. I have over 3 years experience using Tableau and a new prospect... Show More

    Was wondering if anyone can share their experience transitioning from Tableau to Qlik. I have over 3 years experience using Tableau and a new prospective employer solely uses Qlik instead. I don’t have any issues learning new software but I want to know how big the learning curve is moving from one to the other.

    Show Less
  • forum

    Qlik Cloud Data Integration

    Error when install the Data Movement Gateway

    Hi there. I'm following this document about to install the Data Movement Gateway: Setting up the Data Movement gateway  Before init install, I checked... Show More

    Hi there.

    I'm following this document about to install the Data Movement Gateway: Setting up the Data Movement gateway 

    Before init install, I checked the prerequisites about SO, as like write on document, the version 9 of Red Hat is compatible, so I install the CentOS Stream 9:

    edulcouto_0-1716238272591.png

     

    When I runned the command:

    QLIK_CUSTOMER_AGREEMENT_ACCEPT=yes rpm -ivh qlik-data-gateway-data-movement.rpm

     

    I received the error bellow:

    edulcouto_1-1716238362063.png

    Could someone help me about this error occurs?

    Show Less
  • forum

    Deployment & Management

    Is it possible to disable the option of Uploading QVW via Qlik Sense Dev Hub for...

    Hi Team, Is it possible to disable the option of Uploading QVW via Qlik Sense Dev Hub for end-users (analyzer) ? Regarding access rights to Dev Hub, i... Show More

    Hi Team,

    Is it possible to disable the option of Uploading QVW via Qlik Sense Dev Hub for end-users (analyzer) ?

    Regarding access rights to Dev Hub, its seems that analyzer user has the option for upload qlikview (QVW)Documents in Dev Hub, although he have only read rights . (based on Qlik Documents enclosed)

    https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/Dev-Hub/Content/Sense_Dev-Hub/dev-hub-access-rights.htm

    This is a secured valuation for high secured customers like a BANK,  

    we're looking for a way to achieve this restrict,  due to the constraint of not possible to disable the Qlik Sense Dev Hub for end users.

    https://community.qlik.com/t5/Official-Support-Articles/Not-possible-to-disable-Qlik-Dev-Hub-for-normal-users/ta-p/1714552

    eyalnir_qlik_0-1716723909243.png

    Many thanks for any feedback

    #3143

    Show Less
  • forum

    New to Qlik Analytics

    Qlik to PBI migration

    Hello All,I Have below qlik logic which I need to show in Power BI custom Columnif(len([Alternate  Flag])=0 and len([Alternate SD Flag])=0,'N',if(len(... Show More

    Hello All,

    I Have below qlik logic which I need to show in Power BI custom Column

    if(len([Alternate  Flag])=0 and len([Alternate SD Flag])=0,'N',
    if(len([Alternate  Flag])=0 and [Alternate  SD Flag]='Y','Y-USA',
    [Alternate  Flag]) as Flag_Check

    I have only record 'Y' in both Alternate Flag and Alternate SD Flag that is 'Y'

    but in output it's showing all three value N, Y, Y-USA in Qlik

    How it could be possible?

    and please help me in converting this to PBI

    Thanks!

    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!