Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 225,858 members
  • 5,696 online
  • 2,007,816 posts
  • 150,633 Solutions
Announcements
NEW Customer Portal: Initial launch will improve how you submit Support Cases. FIND OUT MORE

Welcome to Qlik Community

Recent Discussions

  • forum

    New to Qlik Analytics

    replace null to zero in table chart

    Hi There, I have a table where Plant_no groups WORK_ORDER_KPI, HOT_JOINT_KPI, and K1VA_AGE_KPI, and summing them in the pivot table to replace null to... Show More

    Hi There, I have a table where Plant_no groups WORK_ORDER_KPI, HOT_JOINT_KPI, and K1VA_AGE_KPI, and summing them in the pivot table to replace null to zero does not give the correct values. All I want is to replace null with 0. Note: all the columns comes from diffrent table/ model.

    Any hacks will be much appreciated. I have attached the data and screenshot of a table view to this post.

    Show Less
  • forum

    Qlik Replicate

    [POC] Used ODBC to connect the Exasol DB as target.

    Hi Sirs, Would you has meet this situation ever? User use the ODBC to connect exasol DB as target and perform the full load & cdc, when full load user... Show More

    Hi Sirs,

    Would you has meet this situation ever?

    User use the ODBC to connect exasol DB as target and perform the full load & cdc, when full load user got the error code as below Failed (retcode -1) to execute statement: 'CREATE TABLE "attrep_apply_exceptions" and RetCode: SQL_ERROR SqlState: 42000 NativeError: -6811776 Message: [Exasol][Exasol Driver]no schema specified or opened or current schema has been dropped.

    How should we to solve this error?

    Thanks.
    Aaron 2024-7-22

    Show Less
  • forum

    Qlik Cloud Data Integration

    get data from a materialized view from google big query

    Hi is it possible to load data from a materialized view from google big query, or can only tables be loaded here? We are already using the big query c... Show More

    Hi

    is it possible to load data from a materialized view from google big query, or can only tables be loaded here?

    We are already using the big query connector and can also load data from tables, but the materialized views are not visible in the "select data to load" window. Any ideas?

    thx and best regards

    Julian

    Show Less
  • forum

    Integration, Extension & APIs

    What connection can I make?

    Hello, I need to connect with Qlik Sense, a new program. Do you have any recommendations? No Chatgpt.
  • forum

    App Development

    How to freeze the title of a sheet

    Hi, How to freeze the title of a sheet, so that it remains visible even when the user scrolls down an extended sheet ?Thanks . Eric
  • forum

    New to Qlik Analytics

    Replace '-' or null value with 0 in Pivot table Qlik sense

    Hi All,    I have a pivot table in Qliksense which has data like below:  Now the user doesn't want to see - for null he wants to see 0 in column F an... Show More

    Hi All,

       I have a pivot table in Qliksense which has data like below: 

    Neha121_0-1721703709645.png

    Now the user doesn't want to see - for null he wants to see 0 in column F and G and 'Yes' in Column H like below

    Neha121_2-1721703812512.png

    How can we do it in formula? or do I have to do some coding at the backend?

     

    Show Less
  • forum

    New to Qlik Analytics

    set expression or smart way to identify inactive customers in time A but not tim...

    I try to build a table to show the count of those customers are no longer active in Q2. (see the demo table) That is to say, those customer should hav... Show More

    I try to build a table to show the count of those customers are no longer active in Q2. (see the demo table)

    That is to say, those customer should have larger than 0 sales in Q1; that gives A B C D G H

    since E and F 's Q1 sales is 0. 

    Then , among the rest of customers, we rule out any customers who have sales larger than 0 in Q2

    and the final list is C D H 

    blow is a simple demo table. dimension filed is Cus, Month, measurement filed is sales

    would you pls help me create a count formula ? or aggr to show the customer C D H

     

    Much appreciated it

     

    Cus Dec-23 Jan-2024 Feb-2024 Mar-2024 Apr-2024 May-2024 Jun-2024
    A 90 1,550 1,300 1,280   0  
    B 100 1,490 1,000 1,270 (500) 500  
    C 70 950 820 930 720 660 1,180
    D 90 950 850 830 740 760 670
    E 90 0 780 -780 1,360 980 1,170
    F 0 0 0 0 2,260 770 720
    G 0 0 0 -690 1,010 620 690
    H 100 500 670 720 750 580 350
    Show Less
  • forum

    New to Qlik Analytics

    Set Analysis Count of Counts

    Hi,   I have a table of client purchases. Each client gets a classification according to the purchases. ClientID StoreID Classification_group10 1 A20 ... Show More

    Hi,

     

    I have a table of client purchases. Each client gets a classification according to the purchases.

    ClientID StoreID Classification_group
    10 1 A
    20 2 A
    30 3 B
    40 4 C
    50 3 C
    60 2 C
    70 1 B
    80 1 C
    90 3 A
    100 4 A
    110 1 C
    120 1 C
    130 3 B
    140 2 C

     

    I want to count the number of StoreIDs that have a count of a specific group C that is 2 and above.

    Basically if there is a storeID that the count of group C is 2 or more then Count these stores.

    My Set Analysis only counts group C per Store but I cant do the counting of the stores afterwards:

    count({$<StoreID = {'=count(Classification_group)>=2'},Classification_group={'C'}>}StoreID)

     

    What am I missing? Thank you for your help 🙂

     

     

    Show Less
  • forum

    QlikView App Dev

    Straight Table Question

    Hi Guyz,I am new to QlikView and completely stuck at a point.I have a straight table and around 3 list boxes. Normally Table gets updated as soon as w... Show More

    Hi Guyz,

    I am new to QlikView and completely stuck at a point.

    I have a straight table and around 3 list boxes. Normally Table gets updated as soon as we select a item in list box, But my requirement is Table should not get updated till we select all the filters. It should be updated only after selecting all the filters and upon clicking on "Go" button. Till then straight table should not display any data.

    How can I do this?

    Show Less
  • forum

    App Development

    Rank / Max with Set Analysis to Highlight best/ worst in column?

    I've been asked why there's not an option like excel for conditional formatting columns, rows etc. and I don't have a good answer when it comes to set... Show More

    I've been asked why there's not an option like excel for conditional formatting columns, rows etc. and I don't have a good answer when it comes to set analysis.

    Because Rank () won't work where set analysis is used, I'm stumped.


    Assuming the below is my data-set

    Name Food Week Amount
    Bob Fish 1 2
    Bob Cheese 1 3
    Bob Bread 1 4
    Bert Fish 1 5
    Bert Cheese 1 1
    Bert Bread 1 8
    Bob Fish 53 9
    Bob Cheese 53 2
    Bob Bread 53 8
    Bert Fish 53 7
    Bert Cheese 53 1
    Bert Bread 53 2


    If I added a rule per column  to pick the top 1 values and highlight - I'd get something like this ( created with Excel conditional formatting for top 1 ) 

    110_0-1721661859848.png

     

    I'm using set analysis , so to do the same is to compare the aggregate, but it returns true for both rows 

    110_1-1721662010069.png

    Using 

     

    if(
    Sum( {<Food={"Fish"},[Week]={53}>}Amount)=

    max(aggr(Sum(total <Name> {<Food={"Fish"},[Week]={53}>}Amount),Name)),
    red(),green()
    )

    Are there plans to introduce something simple into table formatting to allow for simpler solutions to this issue?

    Like allowing highlighting of top 1, 10, 20 etc, and gradients etc.  would be simple to do at a hypercube level , but is a dark art trying to figure out with set analysis.


     

    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!