Skip to main content

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
  • 181,833 members
  • 11,663 online
  • 1,735,054 posts
  • 132,764 Solutions
Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST

Welcome to Qlik Community

FOR NEW MEMBERS

Everything you need to make your Qlik Community experience valuable.

SEARCH KNOWLEDGE BASE

Explore official Support and member created content.

QLIKWORLD 2023!

A live, in-person thrill-ride - full of insights, learning, and peer-to-peer connections.

Analytics

Forums for Qlik Analytic solutions. Ask questions, join discussions, find solutions, and access documentation and resources.

Data Integration

Forums for Qlik Data Integration solutions. Ask questions, join discussions, find solutions, and access documentation and resources

Qlik Gallery

Share your best Qlik apps and discuss impacts with peers! Show your work and get recognized for innovative uses of Qlik technologies.

Ideation

Participate in Qlik Technical Previews, submit ideas, and review documentation.

Support

Chat with us, search Knowledge, open a Case, read the latest Updates Blog, find Release Notes, and learn about our Programs.

Events

Learn about upcoming Qlik related events, webinars and local meetups.

Groups

Join a Group that is right for you and get more out of your collaborations. Some groups are closed. Closed Groups require approval to view and participate.

About Qlik Community

Get started on Qlik Community, find How-To documents, and join general non-product related discussions.

Blogs

Hear directly from Qlik employees in our ten unique blogs.

Qlik Resources

Direct links to other resources within the Qlik ecosystem. We suggest you bookmark this page.

Qlik Academic Program

Qlik gives qualified university students, educators, and researchers free Qlik software and resources to prepare students for the data-driven workplace.

Community Sitemap

Here you will find a list of all the Qlik Community forums.

Recent Discussions

  • forum

    App Development

    Daily archive of qliksense report

    Hello, I would like to know if there is a way to save down the entire qliksense report as daily copy? This is the need for our daily reporting process... Show More

    Hello,

    I would like to know if there is a way to save down the entire qliksense report as daily copy? This is the need for our daily reporting process that needs to keep a daily copy of the report.

    To be specific, the report includes several sheets, we need to save the entire report/app daily with a date stamp, not just one specific sheet or one specific table in the sheet.

    Thank you.

    Show Less
  • forum

    QlikView App Dev

    Export to Excel

    A table has 18 columns and many rows. I cannot export to excel, when I try I just get a grey cross across the table.  Even if I only select a single r... Show More

    A table has 18 columns and many rows.

    I cannot export to excel, when I try I just get a grey cross across the table. 

    Even if I only select a single row it does the same thing. 

    If I remove a random 4-5 columns it then works. 

    How do I fix it?

    Thanks!

    Show Less
  • forum

    App Development

    set analysis not working when multiple values selected

    hi all, my set analysis is working properly when one value is selected, but it does not work on the whole selection. to determine timetable_id i am ... Show More

    hi all,

    my set analysis is working properly when one value is selected, but it does not work on the whole selection.

    Simon4_0-1675179144727.png

    Simon4_1-1675179156236.png

    to determine timetable_id i am using:

    ONLY({1<STARTDATE = {'$(=$(vStartdate))'}>}timetable_id)

    where vStartdate = max(if(STARTDATE<(vPeildatum)+1,STARTDATE))

    this is my data load:

    LOAD
    "PK_R_EMPLOYEE" as Employee_id,
    CODE as Employee_code;

    SQL SELECT
    "PK_R_EMPLOYEE",
    CODE
    FROM ".dbo."V_R_EMPLOYEE";

    tbl_timetable:
    LOAD "FK_EMPLOYEE" as Employee_id,
    "FK_TIMETABLE" as timetable_id,
    date(STARTDATE) as STARTDATE;
    SQL SELECT "FK_EMPLOYEE",
    "FK_TIMETABLE",
    STARTDATE
    FROM "V_R_TIMETABLEOFFSET";

     

    left join tbl_timetable:
    LOAD "FK_TIMETABLE" as timetable_id,
    "FK_WORKDAY" AS WORKDAY_ID,
    SEQUENCENR,
    "PK_R_TIMETABLEWORKDAY";
    SQL SELECT "FK_TIMETABLE",
    "FK_WORKDAY",
    SEQUENCENR,
    "PK_R_TIMETABLEWORKDAY"
    FROM "V_R_TIMETABLEWORKDAY";

    left join tbl_timetable:
    LOAD CODE,
    DESCRIPTION,
    (DEFAULTHOURS/10000000)/(60*60) AS DEFAULTHOURS,
    "PK_R_WORKDAY" AS WORKDAY_ID;
    SQL SELECT CODE,
    DESCRIPTION,
    DEFAULTHOURS,
    "PK_R_WORKDAY"
    FROM "V_R_WORKDAY";

    how can i fix this?

     

    kind regards,

     

    Simon de Vrieze

     

     

     

    Show Less
  • forum

    New to Qlik Sense

    Where clause issue

    Hello, I have an issue with proper filtering data table. I have also asked chatGPT but he can't clear this. I need filtered this table:  1 I need only... Show More

    Hello,

    I have an issue with proper filtering data table.

    I have also asked chatGPT but he can't clear this.

    I need filtered this table:

     1 I need only December 2022 and later included

     2 I need exclude any row with "COR" contained in field H_DOCUMENT_NUMBER

    There is probably syntax error with stacking two where clauses but single try  with only excluding "COR" don't work as demand too.

    LOAD
    'SALES' as TABLE,
    H_DOCUMENT_NUMBER as DOCUMENT_NUMBER,
    CUSTOMER_ID,
    MATERIAL as "FG Code",
    //"Short model name" as "Short model",
    H_TO_NET_EUR as "TO NET",
    DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') as CAL_YYYY_MM,
    TO_REGION


    FROM [lib://QVD tabele:DataFiles/SCEP_ALL_AN_SALES.QVD]
    (qvd) WHERE DATE(MONTHSTART(DATE_UNLOADING), 'YYYY_MM') >= '2022_12'
    OR NOT H_DOCUMENT_NUMBER LIKE '%COR%';

    Show Less
  • forum

    QlikView Administration

    Qlikview Upgrade to May 2022 Version

    Hi Guys, We are planning to upgrade Qlikview to 12.70 version from 12.20 Version. Please let me know how to upgrade and complete steps for the upgrade... Show More

    Hi Guys,

    We are planning to upgrade Qlikview to 12.70 version from 12.20 Version.

    Please let me know how to upgrade and complete steps for the upgrade.

    Thanks.

    Show Less
  • forum

    New to Qlik Sense

    Only show one value in frontend

    Hello, i have a table, which contains multiple fields, but at the frontend, i only want to show one certain field.The source data looks like this: ... Show More

    Hello,

    i have a table, which contains multiple fields, but at the frontend, i only want to show one certain field.
    The source data looks like this:

    Header
    Amber
    Tom
    Peter

     

    at the frontend, i want it to look like this (only show Amber):

    Header
    Amber

     

    can you guys help me?

     

    Show Less
  • forum

    App Development

    Need field outside dimension from set analysis

    I have two problems. I need to grab a field with my set analysis from outside my dimension. I'm pretty sure I've done this before but I cannot seem to... Show More

    I have two problems. I need to grab a field with my set analysis from outside my dimension. I'm pretty sure I've done this before but I cannot seem to find the function that allows that anywhere, after about 3 days straight of scouring and reading documentation.

    The second issue I have is just a simple syntax problem on the value I'm trying to gather above. Here is a snippet of my formula from my table:

    =aggr(     // I don't know if this is necessary at all
    Concat({<    // I have also tried Only() here with no success
    [Transactions.Ref Number] = ExpressionVariablePlaceHolder,     

    Transactions.Memo={"*Sales Order*"}
    >}
    Transactions.Memo // This value is never displayed, if I remove the Aggr() encapsulation I get "error in calculated dimension
    ),''
    )

    I need to grab all lines under [Transactions.Ref Number] and extract the one that contains "Sales Order: XXXXX". Currently each line of Transaction shows up as a separate row and only one contains the "Sales Order: XXXXX" Transactions.Memo value, all other rows show it as blank which is why I have to grab it outside the dimension of each row.

    Any help would be greatly appreciated!

    Show Less
  • forum

    App Development

    Show clients with 0 sales in month but sales >0 in previous month

    Hello,  I need to create a table showing the clients that have not ordered this month.   This is in Qlikview April 2019 R3.   The table will show the ... Show More

    Hello, 

    I need to create a table showing the clients that have not ordered this month.  

    This is in Qlikview April 2019 R3.  

    The table will show the client then two measures : sales this month, sales previous month.

    My sales this month measure is as follows : 

    Sum( {$<TYPE_CALENDRIER={'N'},ORIGIN={'FACTURES'}>} [TONNAGE VENDU])

    My sales last month measure is this : 

    Sum( {<TYPE_CALENDRIER={'N'},ORIGIN={'FACTURES'}, MOIS_ANNEE={'$(vMoisPrecedent)'}, MOIS= >} [TONNAGE VENDU])

     

    The month field, MOIS, is the current month, and it is selected by default on opening.  The fiscal year, EXERCICEFIS, is also selected by default, and it is the current fiscal year.  The user can change month, fiscal year or eventually calendar year, ANNEE.  

    I have a variable, vMoisPrecedent, that sets the Previous month-year, based on these three fields.

    So my problem is showing only the clients with 0 sales in sales this month

    I tried this as a calculated dimension :

    =if(aggr(Sum( {$<TYPE_CALENDRIER={'N'},ORIGIN={'FACTURES'}>} [TONNAGE VENDU]) = 0,[CLIENT COMPLET]),[CLIENT COMPLET])

    But it is giving me a table with zero clients listed, and in my measure columns, the total of all sales for that month.  

    leenlart_0-1675091115743.png

     

    I would REALLY appreciate any help!  

    Thanks!!

    Show Less
  • forum

    App Development

    Celi and rounding

    Hi Experts, Need small help in rounding off the numbers as below. the percentage number fractional number less than 5 then it should be ceil else roun... Show More

    Hi Experts,

    Need small help in rounding off the numbers as below. the percentage number fractional number less than 5 then it should be ceil else round 

    % of profit  % of profit 
    91.03 91
    67.67 68
    79.45 79
    98.79 99
    Show Less
  • forum

    App Development

    Deny access to single app without section access

    Hi,I was asked if it is possible to deny the access to a single app without using section access?The user should see the stream, but should not see a ... Show More

    Hi,
    I was asked if it is possible to deny the access to a single app without using section access?
    The user should see the stream, but should not see a particular app inside the stream?
    Thanks in advance

    Show Less

Blogs

Community News

Hear from your Community team as they tell you about updates to the Qlik Community Platform and more!

Blogs

Qlik Academic Program Blog

Read the latest blog around the Qlik Academic Program.

Blogs

Qlik Product Innovation Blog

If you want to know what's new across all of the products in our growing Qlik product portfolio.

Blogs

Support Updates Blog

Get the latest Support information about end-of-product support, new service releases, and general support topics.

Blogs

Qlik Design Blog

Read all about Qlik solutions: scripting, data modeling, visual design, extensions, best practices and more.

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

Events and Webinars

QlikWorld 2023!

Get ready for QlikWorld: The Conference for Data Thrill-Seekers. From exciting innovations to spine-tingling keynote presentations and lots of peer networking, you'll discover how you and your data can help your business succeed.

Find your city

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming

Events and Webinars

Qlik and Qlik Community Hosted Events

Subscribe to our Events and Webinar page so you do not miss an event opportunity!

choose and register

Event

Welcome to Qlik

Join the "Welcome to Qlik" webinar and learn about the Qlik Ecosystem, such as Qlik Community, Learning, and Help.

On-Demand

Events

Upcoming Events and Webinars

There is more than one way to find upcoming events, look on the right side of any Qlik Community forum!

Upcoming