Qlik Community

Ask a Question
Welcome to Qlik Community
cancel
Showing results for 
Search instead for 
Did you mean: 
3,655 online

Data Analytics

Forums for Qlik Data Analytics 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 Academic Program

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

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.

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

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.

Support

Access Support programs, Knowledge Base, Updates blog, and Release Notes.

Community Sitemap

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

Recent Discussions

  • No Boards Found
  • forum

    New to Qlik Sense

    How to get field Data using REST API using Postman

    I want to extract field data through REST API.  But I am unable to find the best Url to get it. 
  • forum

    App Development

    Num Format Issue in Qlik

    Hello Techies,I want Number format If positive +7,3 else  -7.3 Please find below final format  
  • forum

    New to Qlik Sense

    How to handle data model if four tables having same common field name

    Hi All,I have four tables and four tables having same common field name.How to handle data model.See below example for reference.for example Student d... Show More

    Hi All,

    I have four tables and four tables having same common field name.

    How to handle data model.

    See below example for reference.

    for example 

    Student details table:

    Student ID, Student Name, Student address

    Student Course Details table:

    Student ID, Course, Category

    Student Marks:

    Student ID, Marks

    Student Status:

    Student ID, Status, Grade

    Above four tables having Student id is common.

     

    Can you please suggest me how to handle data model.

     

    Thanks & Regards,

    Lakshman

    Show Less
  • forum

    Japan

    ピボットテーブルの日付軸との関連付けについて

    お世話になっております。 ロードスクリプトで、以下2つのテーブルを読み、「受講可能月」が軸のピボットテーブルを作成しました。ーーtable1: ID、受講可能月、月間受講回数table2: ID、契約日、解約日ーー受講可能月は、契約日から解約日までの月をすべて含んでいます。ここで、軸の「受講可能月」... Show More

    お世話になっております。

     

    ロードスクリプトで、以下2つのテーブルを読み、「受講可能月」が軸のピボットテーブルを作成しました。

    ーー

    table1: ID、受講可能月、月間受講回数

    table2: ID、契約日、解約日

    ーー

    受講可能月は、契約日から解約日までの月をすべて含んでいます。

    ここで、軸の「受講可能月」と「契約月(Yearmonth)」が同じ人で、当月受講した人(つまり、契約した月に受講した人の数)をカウントしたく、どのように作成すればよろしいでしょうか。

    また、同様に、軸の当月契約当月受講した人が、その月に何回受講したか(月間受講回数)も同ピボに表示させたいと考えています。

     

    よろしくお願いいたします。

    Show Less
  • forum

    App Development

    Dynamic colour for bars in bar chart

    I want to create a bar chart with one dimension - Product and two measures - Target Vs Actual, where the color for Target bar is Grey (i.e.fixed ), bu... Show More

    I want to create a bar chart with one dimension - Product and two measures - Target Vs Actual, where the color for Target bar is Grey (i.e.fixed ), but the color of Actuals must be red if actuals > target , else it has to be blue as shown in the  screenshot here. Does anyone have any idea to achieve this in Qlik sense bar chart ?  Thanks!

    sankar_ganesh_0-1627867312112.png

    Regards,

    Sankar

    Show Less
  • forum

    App Development

    Headcount measure

    Hello,I am new to Qlik Sense.  I'd appreciate it if anyone could let me know how to write a dynamic headcount measure in Qlik Sense.  I was able to do... Show More

    Hello,

    I am new to Qlik Sense.  I'd appreciate it if anyone could let me know how to write a dynamic headcount measure in Qlik Sense.  I was able to do it using the employee database with the information of hiring date and leaving date and was able to obtain the headcount at any point in time with the disconnected table using Power BI; and I tried to recreate the same headcount measure in Qlik Sense, but I have been unsuccessful so far.  I'd appreciate it if anyone could share with me a standard headcount measure which is able to produce dynamic calculation at any point in time from the calendar table.  (I am not interested in inflexible one where I have to indicate in the loaded data if the person is employed at one point in time which I sometimes see in an headcount dashboard example, as this will not be able to generate dynamic result based on the selected point in time).  Thanks a lot for your help.  

    Show Less
  • forum

    New to Qlik Sense

    How to cross table multiple files in qliksense

    Hello everyone,I am new to Qliksense and need to develop a cross table for almost 18 output files.I could create for 1 file but unable to do so for al... Show More

    Hello everyone,

    I am new to Qliksense and need to develop a cross table for almost 18 output files.

    I could create for 1 file but unable to do so for all the files.

    Can someone please tell me how to do that?

    I need the Date, cellname and cellvalue as the cross table columns.

    I have attached a sample output file for reference.

    How can i create a cross table for multiple such files.

    Any help would be greatly appreciated.

    Thank you

    Regards,

    Pankhudri

    Show Less
  • forum

    New to Qlik Sense

    Cannot write Percentage (%) for measures in Line Chart

    hi guys,I have created a  line chart in qliksense. but I'm not getting how to write the  percentages of measures marked just like below: for me it's c... Show More

    hi guys,

    I have created a  line chart in qliksense. but I'm not getting how to write the  percentages of measures marked just like below:

    vasundhra_0-1627801579041.png

     

    for me it's coming something like this

    vasundhra_1-1627801579049.png

     

    Can someone please guide me with this?

    Thanks

    Show Less
  • forum

    Connectivity & Data Prep

    Loading Data from a website

    Hello Everyone I am trying to Load Data from https://www.baaa-acro.com/crash-archives but i keep getting an unkown error.  With this code i got only 2... Show More

    Hello Everyone 

    I am trying to Load Data from https://www.baaa-acro.com/crash-archives but i keep getting an unkown error.  With this code i got only 260 lines fetched 

    for i=1 to 1375

    let vPage= 'https://www.baaa-acro.com/crash-archives' & if($(i)>1,$(i),'') & '.htm';


    LOAD
    //Image,
    "Date",
    Operator,
    "A/C Type",
    Location,
    Fatalities,
    Registration
    //F8
    FROM [lib://Aviation-Crashes]
    (html, utf8, embedded labels, table is @1; //filters(


    next

    BN_0-1627751492354.png

    I then tried this code and only got to 1305 lines. 

    FOR vsCounter = 1 TO 1375

    LET vsPage = If($(vsCounter) = 1, 20, 27488 + $(vsCounter) - 1);

    LET vsURL = 'https://www.baaa-acro.com/crash-archives' & '$(vsPage)' & '.htm';


    SET ErrorMode = 0;


    LOAD

    @2 AS [Date],

    @3 AS [Operator],

    @4 AS ["A/C Type"],

    @5 AS [Location],

    @6 AS [Fatalities],

    @7 AS Registration

     

    FROM [lib://Aviation-Crashes]
    (html, utf8, no labels, table is @1);

    // WHERE Recno() > 4;


    SET ErrorMode = 1;

    NEXT

     I am not sure what the error is, if someone, anyone can help me please.

    Show Less
  • forum

    New to Qlik Sense

    Incorrect translation on reload message after reloading with data manager (pt-br...

    After reloading the app from Data Manager, the splash screen says in Portuguese "Your data loading resulted in errors" but when reloading same app on ... Show More

    After reloading the app from Data Manager, the splash screen says in Portuguese "Your data loading resulted in errors" but when reloading same app on English interface it says "Your data was successfully loaded"

    I think there is a translation error on the screen so I always have to say to my clients to ignore it.

    I found this issue on version Feb/2021 for Client Managed and Cloud version as well.

    Client Managed (pt-br)

    pablolabbe_0-1625771089711.png

    Cloud (pt-br)

    pablolabbe_2-1625776473733.png

     

    Client Managed (English)

    pablolabbe_1-1625771358759.png

    Cloud (English)

    pablolabbe_3-1625776597113.png

     

    Hope this could be fixed soon !

    Pablo 

     

    Show Less

Get Started On Community

Start Here Get Started On Community

Top Participants

Blogs

Product Innovation Blog

Learn about what's new across all of the products in our growing Qlik product portfolio.

Blogs

Qlik Community Manager Blog

Hear from the Qlik Community team about the latest platform enhancements and other topics.

Blogs

Support Updates Blog

Important and useful support information about end-of-product support, new service releases, and general support topics.

German Group

Deutsche User Group

German speaking - This group makes it easier to collaborate in your local language.

Request to join

Brazil Group

Brazil

This group for Brazil users. All discussions are in Portuguese.

open to all

Industry Group

Public Sector Group

This is a open Group for the Public Sector

All are welcome

Events

Espresso Webinars - From Data Integration to Analytics in Action

These webinars get straight to the point, they are strong, short, and with immediate effect – like an espresso.

Upcoming and On-Demand

Events

Talk to Experts Tuesday

You’ve got questions? We’ve got answers! Talk to Experts is a live Q&A Webinar series! Join and ask your questions about Qlik Sense Enterprise, Client Managed.

June 29, 2021 10AM EST

Events

Cloud Data and Analytics Tour

Ready to steer your business towards data-informed growth? Our Cloud Data & Analytics Tour is the perfect place to start your journey.

Choose your Region