Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 214,364 members
  • 6,228 online
  • 1,989,645 posts
  • 149,030 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

    New to Qlik Analytics

    Actions in Vizlib button

    Hi All,I have two Vizlib Buttons as mentioned below in Qlik sense. when i click Kye Graphs Button it should be take into key graph sheet with selected... Show More

    Hi All,

    I have two Vizlib Buttons as mentioned below in Qlik sense. when i click Kye Graphs Button it should be take into key graph sheet with selected value field. But Selected value in field Action is not working .  please help me on this issue.

    clipboard_image_1.png

    clipboard_image_0.png

     

    Thanks,

    Show Less
  • forum

    New to Qlik Analytics

    Cumulative sum in line chart

    Hi,   I'd need to calculate a cumulative sum in the line chart, but this formula doesn't work: =RangeSum(Above(TOTAL Sum({$<[Type]={'$(vType)'},[Produ... Show More

    Hi,

     

    I'd need to calculate a cumulative sum in the line chart, but this formula doesn't work:

    =RangeSum(Above(TOTAL Sum({$<[Type]={'$(vType)'},[Product Line]={'Product 1'},[Account channel]={'Direct'}>} [Value]),1,RowNo(TOTAL)))

    I'll have 1 line for actual and 1 line for target in the same line graph and I'd like to cut the actual line - please see the example chart below:

    a5_1-1710848043144.png

    Any idea how to solve this? Thanks!

    Show Less
  • forum

    New to Qlik Analytics

    Aggregation in Edit Script different then GUI

    Hi Community, I have given below data set:   Date Periods Franchise Country Orders_Numbers 01.01.2022 1 Burger USA 101 01.01.2022 2 Burger Cana... Show More

    Hi Community,

    I have given below data set:

     

    Date Periods Franchise Country Orders_Numbers
    01.01.2022 1 Burger USA 101
    01.01.2022 2 Burger Canada 101
    01.01.2022 3 Burger Australia 101
    01.01.2022 4 Burger France 102
    01.01.2022 5 Burger Spain 102
    01.01.2022 6 Burger Italy 102

     

    If I write Expression in the GUI: Count(DISTINCT Orders_Numbers) then I'll get 1 for the Orders_Numbers = 101 whenver I'll select / deselect any dimension on the GUI. If I'll clear all the dimensions then I'll get 2. One for each Orders_Numbers due to Count(DISTINCT Order_Numbers).

    I want to achieve the same results using Edit Script. How to do it ? I don't want to remove any dimension Filter from the GUI.

    I tried this solutions to achieve the same results but the problem is I got 3 for the Orders_Numbers = 101. Becaue the %Key has a unique Periods in the %Key that makes it unique while I count on the GUI then it returns me the 3 not one due to the %Key. If I write DISTINCT in the Expression then I'll always get 1 for all the data set.

    Do I need to change the expression after the below load edit script or what is the right way to do it ?

     

    NoConcatenate
    Fact:
    LOAD 
    Date & Periods & Franchise & Country as %Key
    Date,
    Periods,
    Franchise,
    Country,
    Orders_Numbers
    FROM
    [Fact_Table.qvd] (qvd);
     
    NoConcatenate
    Fact_Aggregation:
    LOAD %Key,
         Count(DISTINCT Orders_Numbers) as Orders_Numbers_DISTINCT_Count
    Resident Fact
    Group By
    %Key
    ;
     
    Expression: Sum(Orders_Numbers_DISTINCT_Count)
    Show Less
  • forum

    New to Qlik Analytics

    After updating my Qlik Sense to the February 2024 Patch 01 version, my hub does ...

    I use Windows 11, 64-bit 23H2, with 16 GB of RAM. I was using Qlik Sense Desktop November 2033 Patch 2 and everything was working fine. Today, I upgra... Show More

    I use Windows 11, 64-bit 23H2, with 16 GB of RAM. I was using Qlik Sense Desktop November 2033 Patch 2 and everything was working fine. Today, I upgraded my version of Qlik Sense Desktop to the February 2024 Patch, and Qlik opens normally without any error codes or alert messages.

    However, when I maximize Qlik to my full HD resolution, the Qlik window fills the screen, but the hub where the applications are located doesn't fill the screen. It appears as a square aligned to the left. I will attach a screenshot for reference.

    Have you seen this issue before?


    Note: I have hidden the names of the applications and the company logo in the screenshot.

    Show Less
  • forum

    Qlik Application Automation

    Error - MS Excel Create Excel Table With Headers - 'the following fields are req...

    Hi all, I have an automation based on Solved: Re: Qlik Automation, Generate excel file based on ... - Qlik Community - 1944201 using the Scheduled Rep... Show More

    Hi all,

    I have an automation based on Solved: Re: Qlik Automation, Generate excel file based on ... - Qlik Community - 1944201 using the Scheduled Report (Dimension Cycle) JSON template.

    The automation works perfectly, by looping and adding all of the data from the Qlik report into an excel spreadsheet and saves to OneDrive just fine.

    I get an error saying that the drive_id and item_id are required for the excel block but these are mapped to the file created earlier in the automation.

    I have attached the JSON and some screenshots if anyone is kindly able to assist.

    Thanks,

    Lewis

     

    lewis255_2-1710165246315.png

    lewis255_3-1710165281337.png

     

    lewis255_1-1710165194286.png

     

    lewis255_0-1710165181536.png

     

    Show Less
  • forum

    Qlik Compose for Data Warehouses

    converting data type from string to data and time

    Hello everyone, in qlik sense I have a timestamp in a string format and I need to convert it into a date and time with e specific format. the idea is ... Show More

    Hello everyone,

    in qlik sense

    I have a timestamp in a string format and I need to convert it into a date and time with e specific format.

    the idea is to be able to create a calendar or extracts month.week...etc from that field, which is not possible when it's a string

     

    Show Less
  • forum

    Qlik Replicate

    We would like to send a notification (email) when we get bad data.

    We have created a ticket with this question, and they suggested asking this question in the Community. We would like to send a notification (email) wh... Show More

    We have created a ticket with this question, and they suggested asking this question in the Community.

    We would like to send a notification (email) when we get bad data.
    Source target Oracle, data type character.
    Endpoint target Confluent v7 Kafka Avro primitive.
    Background.
    We have an older app running that uses Oracle that has date columns defined as char(8). This means users can (and do) enter invalid dates. We transform the character to datetime, and can test using Sqlite for a valid date, but cannot send an email from Sqlite, or from Replicate. When the invalid date is sent to Kafka it shows up as 9999-12-31 23:59 so it's no longer valid. We haven't found an easy way in our data stream to capture the date. We have looked at the user defined function in the expression builder, but currently do not have a C programmer on in our group.
    Question
    Is there a way to send a notification (email) from Qlik on bad data?

     

    Show Less
  • forum

    New to Qlik Analytics

    Trying to add values to Null

    Hi,  I have many cases in my data where the question asked essentially is:  if value () doesnt appear // does appear in this table then 'Yes' else 'No... Show More

    Hi, 

    I have many cases in my data where the question asked essentially is: 

    if value () doesnt appear // does appear in this table then 'Yes' else 'No'

    this simple formula is proving very challenging to do without creating synthetic keys. 

    Is there an easy one line formula you are able to slot into the actual table in the load editor that would solve this. For example:

    Load

    *,

    If......'yes','no

    from File

     

    Please help 

    Show Less
  • forum

    New to Qlik Analytics

    Generate .meta and .shared

    Hi every one , i developped a qlikview file .qvw in the server  and i want to share  to be visible for users , it  how i can do it , Thanks    Show More

    Hi every one ,

    i developped a qlikview file .qvw in the server  and i want to share  to be visible for users , it  how i can do it ,

    Thanks 

     

    Show Less
  • forum

    Move to SaaS

    Saas readiness app without cloud tenant

    We have a client considering a move to saas, so I downloaded the qlik sense migration app. Unfortunatly you need a cloud tenant to to the check. Older... Show More

    We have a client considering a move to saas, so I downloaded the qlik sense migration app. Unfortunatly you need a cloud tenant to to the check. Older versions are without this connection to cloud.
    Does anyone have an older version of the cloud Readiness app? One without the connection to cloud?

    Kind regards,

    Isabelle

     

     

    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!