Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
6,986 online
Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Welcome to Qlik Community

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

Support

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

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.

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

  • No Boards Found
  • forum

    App Development

    Set Analysis and derived calendar fields integration

    Hello,  Has anybody used autocalendar derived fields in Set Analysis with Alternate State? The following senteces does not work and to me it is bizarr... Show More

    Hello, 

    Has anybody used autocalendar derived fields in Set Analysis with Alternate State?

    The following senteces does not work and to me it is bizarre it does not:

    Sum({<[OrderDate.autoCalendar.Year]=Stato_A::[OrderDate.autoCalendar.Year]>}Sales)

     

    Thanks, 

    Umbi

    Show Less
  • forum

    App Development

    How to get the bar chart variable factors changed by filter selection ( GetFie...

    I'm trying to create a bar chart that changes variable factors by filter selections. With ID of A, B, and C, I want to compare two selected factors' s... Show More

    I'm trying to create a bar chart that changes variable factors by filter selections.

    With ID of A, B, and C, I want to compare two selected factors' sum

    like  A&B sum by date,   A&C sum by date , or B&C sum by date as below.

    barchart.PNG 

    But the first issue I'm facing is sum({$<ID={'$(GetFieldSelections(ID))'}>} Unit) does not bring sum unit into the graph, even though KPI shows the selected factor. 

    barchart2.PNG

     

    Then the second issue is that how can I apply two selections into that one bar chart? barchart3.PNG

     

    data is as below.

    original:
    load * inline [ Date, Week, ID, Unit
    9/1/2021, 1, A, 1
    9/1/2021, 1, A, 2
    9/2/2021, 1, A, 1
    9/2/2021, 1, A, 2
    9/2/2021, 1, C, 2
    9/3/2021, 1, A, 1
    9/4/2021, 1, A, 2
    9/5/2021, 1, A, 2
    9/6/2021, 1, A, 2
    9/7/2021, 2, A, 3
    9/9/2021, 2, A, 3
    9/9/2021, 2, A, 3
    9/9/2021, 2, C, 3
    9/3/2021, 1, B, 1
    9/4/2021, 1, B, 2
    9/5/2021, 1, B, 2
    9/6/2021, 1, B, 2
    9/7/2021, 2, B, 3
    9/7/2021, 2, B, 5
    9/7/2021, 2, C, 5
    9/9/2021, 2, B, 3
    9/10/2021, 2, A, 3
    9/14/2021, 3, A, 2
    9/10/2021, 2, B, 3
    9/11/2021, 3, B, 2
    9/12/2021, 3, B, 2
    9/13/2021, 3, B, 2
    9/13/2021, 3, B, 4
    9/14/2021, 3, B, 2
    9/27/2021, 5, A, 2
    9/28/2021, 5, A, 5
    9/15/2021, 3, B, 2
    9/15/2021, 3, B, 3
    9/16/2021, 3, B, 2
    ];

    Show Less
  • forum

    App Development

    Max Month Sales and Budget

    Hi Community, I have two tables, Revenue and Budget, I have to calculate MTD for both Revenue and Budget My Revenue max month November and the budget ... Show More

    Hi Community,

    I have two tables, Revenue and Budget, I have to calculate MTD for both Revenue and Budget

    My Revenue max month November and the budget month is December,
    But what is the maximum month in Revenue, the maximum month should show the same even in the budget.

    (if it is oct in Revenue, Budget should be OCT value)

    Revenue   Budget
    MonthYear Sales   Budget MY Sales
    Jan-21 200   Jan-21 100
    Feb-21 300   Feb-21 320
    Mar-21 400   Mar-21 540
    Apr-21 500   Apr-21 760
    May-21 600   May-21 980
    Jun-21 700   Jun-21 1200
    Jul-21 800   Jul-21 1420
    Aug-21 789   Aug-21 1640
    Sep-21 235   Sep-21 1860
    Oct-21 234   Oct-21 2080
    Nov-21 790   Nov-21 2300
          Dec-21 2520

     

    Based on user selection value should be change..

    and YTD also should be same..

     

    Thanks in Advance!

    Show Less
  • forum

    New to Qlik Sense

    Nprinting -Levels

    whenever i add levels based on the year ,why the year is displaying for first row and not for entire rows ...any solutions??? This problem is for both... Show More

    whenever i add levels based on the year ,why the year is displaying for first row and not for entire rows ...any solutions???

    This problem is for both excel and HTML reports

    I attached the sample image for your reference

    Show Less
  • forum

    QlikView App Dev

    Scatter Chart with Multiple X-Axis values

    I have 2 sets of data that I need to chart using scatter chart. The only problem is the X-Axis values are different for the 2 sets of data. How can I ... Show More

    I have 2 sets of data that I need to chart using scatter chart. The only problem is the X-Axis values are different for the 2 sets of data. How can I specify different X-Axis for each Y-Axis data? I appreciate your help. Thanks

    mredissi_0-1638721942537.png

     

    Show Less
  • forum

    New to Qlik Sense

    "For each " loop with variable that contained several values

    Hi all. I have an issue with a loop.      Set vList = '41528142','41591529','41593262';     I created a variable Then I want to use each value from ... Show More

    Hi all. 

    I have an issue with a loop. 

     

     

    Set  vList =  '41528142','41591529','41593262';

     

     


    I created a variable

    Then I want to use each value from the vList in loop

     

     

    For each ID  in $('vList ')
    
         Call Extract ('$(ID)', 'False');
    
    Next ID

     

    But for some reason this idea doesn't works. All values from variable are applied as one, not one after another. Can you please help to fix this issue?

    Show Less
  • forum

    New to Qlik Sense

    Doubtful of unmatched data

    Hi Team, I have created a straight table where it shows the expression for all but the dimensions are invisible. What does it mean, are they unmatched... Show More

    Hi Team,

    I have created a straight table where it shows the expression for all but the dimensions are invisible.

    What does it mean, are they unmatched data?? Or I am i going wrong somewhere. 

    please reply me ASAP..

    Show Less
  • forum

    App Development

    Line break in text box?

    I want to add a line break in a text box in Qlik Sense.  Any ideas how to do that?  The text box doesn't seem to respect html or ascii.  It just shows... Show More

    I want to add a line break in a text box in Qlik Sense.  Any ideas how to do that?  The text box doesn't seem to respect html or ascii.  It just shows that code as text.

    Show Less
  • forum

    New to Qlik Sense

    Using Coalesce

    Hi, I want to calculate time difference in hours and try to convert an SQL Logic to use in Qlik Sense SQL: DATEDIFF(minute,convert(datetime,RECEIVEDON... Show More

    Hi, I want to calculate time difference in hours and try to convert an SQL Logic to use in Qlik Sense

    SQL:

    DATEDIFF(minute,convert(datetime,RECEIVEDON,104),COALESCE(CONVERT(datetime,SUpdatedOn,104),CONVERT(datetime,SDATE,104)))/60

    My statement in QlikSense:

    (Coalesce(Date(SUpdatedOn),Date([SDATE]))-(Date([RECEIVEDON])))/60 as Time_Taken

    On doing: Date([SDATE]))-(Date([RECEIVEDON]))/60 as Time_Taken, I am getting value same as in manual calculation

    I am getting different values than manual calculation on using this, If I don't use coalesce value is same. Let me know how can I correct it or some other way to achieve this.

    @Suraj @mvpacker @lebronjames23 

    Show Less
  • forum

    App Development

    Different types of filter selection in Qlik sense

    Hi Experts, I am new to the Qlik sense I want to use to measure slicer selection filters and calendar type of filter, how can we create in qlik sense ... Show More

    Hi Experts,

    I am new to the Qlik sense I want to use to measure slicer selection filters and calendar type of filter, how can we create in qlik sense those like below is an example ones. is it possible to do in Qlik sense if yes , please provide detail examples or any video or file give me. 

    kanth_0-1638507854309.png

    kanth_1-1638507961150.png

     

    also what different kind of selection filter were there in qlik sense. 

     

    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