Skip to main content

Welcome to
Qlik Community!

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 243,561 members
  • 4,834 online
  • 2,026,784 posts
  • 152,493 Solutions
Announcements
The New Qlik Learning Experience is Here! GET STARTED

Welcome to Qlik Community

Recent Discussions

  • forum

    Connectivity & Data Prep

    Connecting Tables

    I may be overthinking this so any guidance is appreciated.  I have these tables - Planned $ by salesperson # and Product Group - Sales history which c... Show More

    I may be overthinking this so any guidance is appreciated. 

    I have these tables

    - Planned $ by salesperson # and Product Group

    - Sales history which contains Customer #s, Products, but NOT Product Group

    - Customer master which contains Customer #, and Salesperson #

    - Product Master which contains Product # and Product Group

    We have a Plan tab on the dashboard where they want to add "Product Group" to the selection group.

    notlohdahc_0-1739916586592.png

    We are using linked tables in the scripts behind the dashboard for current data connections.  I can't figure out how to get these tables linked to summarize Sales $ by Product Group.

     

    I know this probably not nearly enough information, but any help would be appreciated.

    Show Less
  • forum

    Visualization and Usability

    Email Subscription for Updated Sheets

    Our current development process is to duplicate a sheet and work off the duplicated sheet while maintaining the public sheet. This allows a version co... Show More

    Our current development process is to duplicate a sheet and work off the duplicated sheet while maintaining the public sheet. This allows a version control process that we can revert back to the original. We also have staff starting to use the subscription email functionality. We noticed that when we publish the updated duplicated sheet and archive their subscribed one the email subscription doesn't get updated. It'll error out because the sheet cannot be found. Is there any efficient way to manage either version control of sheets to maintain the subscription or quickly update subscriptions with the new sheet?

    Show Less
  • forum

    App Development

    QVD generator - Run SQL in parallel instead of consecutively

    Hey guys, I have a QVD generator that is running 3 separate SQL queries from various databases. I'm using Qlik to generate a superset QVD, combining a... Show More

    Hey guys, 

    I have a QVD generator that is running 3 separate SQL queries from various databases. 
    I'm using Qlik to generate a superset QVD, combining all three datasets. 
    This is working, currently, to build my main QVD for it's corresponding front-end app. 

    The downside that I'm trying to tackle now is that, due to the SQLs running consecutively in section order, the QVD generator is taking 3x longer than expected. I'm hoping someone has a solution for running these SQL queries in parallel such that the QVD generator does not take much longer than the longest query, instead of a SUM of each individual query run-time.  

    Thanks.

    **EDIT** Also trying to avoid 3 separate QVD generators. 😉

    Show Less
  • forum

    App Development

    Compare if the values in two date columns are the same using an IF statement

    Hi All, I am still new to Qlikview. I'm trying to compare two dates to display either a "Y" or "N" based on whether they are the same. I have formatte... Show More

    Hi All,

    I am still new to Qlikview.

    I'm trying to compare two dates to display either a "Y" or "N" based on whether they are the same. I have formatted both date fields, but I’m always getting "N" in the result.

    I tried the DATE and FLOOR function to remove the timestamp from both fields:

    DATE([RECORDED_TIME], 'MM/DD/YYYY') as Recorded_Date
    FLOOR([RECORDED_TIME]) as Recorded_Date_Floor

    DATE([SURGERY_DATE], 'MM/DD/YYYY') as Surgery_Date
    FLOOR([SURGERY_DATE]) as Surgery_Date_Floor

    Then, I applied the following calculation to compare the dates:
    IF(Recorded_Date = Surgery_Date, 'Y', 'N')
    IF(Recorded_Date_Floor = Surgery_Date_Floor, 'Y', 'N')

    However, this still doesn't work as expected. Could someone please guide me and let me know if I'm making any mistakes here? Is there a sample or best practice I could follow to compare dates correctly?

    Thanks in advance for your help.

    Show Less
  • forum

    Design and Development

    Generation and consumption of "V-Order enabled" Parquet files in MSFT Fabric... ...

    Greetings! I've been reading recently about the "V-Order write optimization" that apparently MSFT uses to expedite the reading of Parquet files in MSF... Show More

    Greetings!

    I've been reading recently about the "V-Order write optimization" that apparently MSFT uses to expedite the reading of Parquet files in MSFT PBI and other Fabric tools. MSFT claims that Parquet files following this optimizations are 100% Parquet standard, but I also have found statements indicating that only MSFT tools can write files in "V-Order". Furthermore, it seems that MSFT Fabric Direct Lake mode depends on "V-Order".

    So, can we generate "V-Ordered" Parquet files using Talend Data Fabric / Qlik Talend Cloud? Also, since QSE can also read Parquet files, I assume that Qlik Sense can read "V-Ordered" Parquet files without problems, but please confirm (I haven't seen any options for writing Parquet files using this option in the "store" command's help documentation).

    Please tag me @diagonjope, so that I receive a notification of your response.

    Thanks!

    ++José

    Show Less
  • forum

    App Development

    However to show in two lines

    Hi all,   I want to show the table chart col header to show however in two lines as example below Line1 service1+service2 Line 2 /overall service i tr... Show More

    Hi all,

     

    I want to show the table chart col header to show however in two lines as example below

    Line1 service1+service2

    Line 2 /overall service

    i tried with chr() function nothing helped pls provide your help n support on this 

    manoranjan_321988_0-1739881413337.png

     

     

     

     

    Show Less
  • forum

    App Development

    Can we use Qliksense buttons as a measures

    I am migrating Qlikview app to Qliksense, I have many table charts with same dimensions and different expression. Can i create one table chart and cre... Show More

    I am migrating Qlikview app to Qliksense, I have many table charts with same dimensions and different expression. Can i create one table chart and create multiple buttons with different expression measure so that the one table filter out each time we use different button. Is it possible in qliksense?

    Please help, thanks in advance. @qliksense Qlik Sense Business 

    Show Less
  • forum

    App Development

    Second Set Expression to add second filter

    I have one big tables with order related fields  in KPI i need to show sales by region  I am showing sum of product sold by region Master item  = sum... Show More

    I have one big tables with order related fields 

    in KPI i need to show sales by region 

    I am showing sum of product sold by region

    Master item  = sum({<region_name= { ‘Americas’}>} Dollar_value)

    I  displaying this in graph where X axis is ( YEAR &'-'& Month) 

    Y axis - Above master item , with 2 other master item 

    now I need to add set expression where it shows all the months data except current month

    i dont have full date but i do have columns(attributes) which gives me month and year separate


    my month filed name is “Month” and year field is called “Year “

    this is what i have tried but obviously it doesn’t work

    sum({<

    Month={MonthEnd('$(today()),-1')},

    region_name= { ‘Americas’}

    >} Dollar_value)

     

     

    Show Less
  • forum

    Visualization and Usability

    Problems with cumulation.

    Hello everyone, in the attached table I cumulate the sales per material class in column kum. So far, so good. It works. But when i add another dimensi... Show More

    Hello everyone, in the attached table I cumulate the sales per material class in column kum.

    So far, so good. It works. But when i add another dimension, the cumulation does not work any more.

    I use the following formulas for the key figures:

    dmbtr: sum(      {$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1])
     
    total mat class:   Sum(TOTAL <MARA.MATKL_Description> {$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1])
     
    in %: Sum({$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1]) / Sum(TOTAL <MARA.MATKL_Description> {$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1])
     
    kum:RangeSum( Above(  Sum({$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1])  /
    Sum(TOTAL <MARA.MATKL_Description> {$<EKBE.VGABE={2}, [EKBE.BEWTP]={'Q'}>} [EKBE.DMBTR1]        ),
            0, RowNo()  ) )
     
    I need help please 🙂

     

    Show Less
  • forum

    Visualization and Usability

    Problem with load script

    hey guys,  i am trying to figure out how to incremental load data to same qvd. I am loading this script: HAV_HATIVA_MAIN:LOAD *from [lib://עסקית/HATIV... Show More

    hey guys, 

    i am trying to figure out how to incremental load data to same qvd.


    I am loading this script:

    HAV_HATIVA_MAIN:
    LOAD *
    from [lib://עסקית/HATIVA_HAV/HAV_HATIVA.QVD](qvd);

     

    LIB CONNECT TO 'DC_DWH';

    HAV_HATIVA_NEW_DATA:

    SQL SELECT "LOGICAL_DATE",
    "SERVICE_ORDER_ID",
    "ORDER_NUM",
    "ORDER_SERIAL_NUM",
    "SERVICE_ORDER_SOURCE_DESC",
    "SERVICE_ORDER_TYPE_NAME",
    "SERVICE_ORDER_STATUS_NAME",
    "CUSTOMER_TYPE_NAME",
    "SHEM_CHATIVA_BO",
    "SERVICE_ORDER_CREATION_DATE",
    "CUSTOMER_ID",
    "DW_CUST_SUB_SEGMENT",
    "TEUR_SHERUT_BI",
    "MISSION_ID",
    "NEW_VALUE_DESC",
    "DATE_TECH",
    "SHEM_MACHLAKA_BO"
    FROM MAROUNSH."MS_PIPELINE_HAV_MAG";

    Concatenate(HAV_HATIVA_MAIN)
    LOAD *
    Resident HAV_HATIVA_NEW_DATA;

    drop table HAV_HATIVA_NEW_DATA;

    store HAV_HATIVA_MAIN into [lib://עסקית/HATIVA_HAV/HAV_HATIVA.QVD](qvd);

    I am getting this error:

    The following error occurred:
    Table 'HAV_HATIVA_NEW_DATA' not found
     
    The error occurred here:
    Concatenate(HAV_HATIVA_MAIN) LOAD * Resident HAV_HATIVA_NEW_DATA

    **
    1) HAV_HATIVA_MAIN table and the sql load has same column names.
    2) when i load the SQL by itself, it does return data
    **

    any ideas?
    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!