Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
1,392 online

Here you will find Qlik Sense resources, partake in interesting discussions, solve problems and foster relationships with Qlik experts from around the globe.

Thank you for joining us in the QlikView Forum, your home for QlikView answers. Discover insights within your data that can transform your business.

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

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

Join one of our Qlik Community Groups. Anyone can view content in Open Groups, but you must join to participate. Closed Groups require joining in order to view content and participate.

Hear directly from Qlik employees in our eight unique blogs. Check out the new Architecture Deep Dive Blog!

Find a forum to ask a question or start a discussion.

Discussion Boards and Documents for Qlik Services.

Qlik partners with leading technology companies to develop integrations, extensions, and connectors to the Qlik platform.

Discussion board and documents related to Qlik Associative Big Data Index.

Learn about the Qlik Community. Explore 'How-To' documentation, ask questions, and engage in discussion around the community platform. This will also be the place where, from time to time, we will do some fun things.


Challenge the status quo

See why Qlik (Attunity) is recognized in the 2019 Gartner Magic Quadrant for Data Integration Tools.

Recent Discussions

  • New to QlikView

    limit access without reduction

    HiIs there any way to limit users to see just their related data without reducing data to too many file?We are using qlikview dashboards, but as a pre... Show More

    Hi

    Is there any way to limit users to see just their related data without reducing data to too many file?

    We are using qlikview dashboards, but as a presentation tool we have another web app which have some links that redirect user to qlikview dashboard.

    The problem is :

    We have 40 branches and we want any user just be able to see just him/her branch's data, so we established publisher and reduce any dashboard based on its branch.so for any dashboard we will have 41 published ones.

    If I want to create links in Total app for any individual dashboard I have to create 41 links (we have 41 branches).I'm looking for a solution which limits access to data without reduction.

    Could anybody help me in this case?

    Show Less
  • Qlik Sense Deployment & Management

    can we turn off authentication for QS healthcheck API endpoint? How?

    HiWe learned in Qonnection the QlikSense API Endpoints. For example: GET:443/engine/healthcheck, GET:443/qps/user.We plan to create script that polls ... Show More

    Hi

    We learned in Qonnection the QlikSense API Endpoints. For example: GET:443/engine/healthcheck, GET:443/qps/user.

    We plan to create script that polls the endpoints and reports into datadog. So that we can get easly alerts.

    But current we cannot do this because endpoints need authentication. 

    Questions are:

    1. What is Qlik's recommendation in using API endpoints?

    2. How to turn off the endpoints' authentication?

     

    Best regards,

    Susan

    Show Less
  • New to Qlik Sense

    Question on Qliksense filter

    Hi All,I have one table as below:ID      Name1        A1       B1        C2... Show More

    Hi All,

    I have one table as below:

    ID      Name

    1        A

    1       B

    1        C

    2         D

    2          E

    3          F

    3          G

    and I want to show 3 different filter panes for Name based on the ID e.g. filter pane 1 will have data as A B C, 2 will have D  E and 3 will have F G. And I want that these filter conditions should not imapct on each other. Hence I am writing below expressions:

    Filter 1: =aggr( Only({1< id={1}>}name),name)

    Filter 2: =aggr( Only({1< id={2}>}name),name)

    Filter 3: =aggr( Only({1< id={3}>}name),name)

    which is showing correct output but when I select filter 1 then fillter 2 values are gray out as in the backend data gets filtered out for ID=1 so there are no records for Id 2 and 3 even though I have  written 1 in expression.

    Please note we have older versions on server and Alternate states are not yet available there so any way to resolve this issue.

    Thanks in Advance!!

    Show Less
  • QlikView Scripting

    not changing value in text box after choose any date field

    Hi Guys, I'm working on a sales report on qlikview dashboard. I calculate average sales value upto previous month. it's working. But I want to fixed t... Show More

    Hi Guys, I'm working on a sales report on qlikview dashboard. I calculate average sales value upto previous month. it's working. But I want to fixed the value in the text box but that's not working. When I choose date or month from the field the average value is changed but I don't want any effect for the average value in the text box. I use a set analysis in the equation. Here is the equation:

    =num((Sum({<Month-=,Mday-=,Month-={"$(=vCurrentMonth)"},Year={"$(=vCurrentYear)"}>}Gross_Value)/
    (count(distinct {<Month-=,Mday-=>} Month)-1))/1000000,'###0.0')

    where, vCurrentMonth=2019

    Please help me ASAP, Thanks.

    Show Less
  • New to Qlik Sense

    Previous month using set analysis in qliksense

    Hello people I have created date field using this expression,Date( MakeDate( left(acc_period,4) , right(acc_period,2) ) , 'YYYY-MM' )I have a requirem... Show More

    Hello people

    I have created date field using this expression,

    Date( MakeDate( left(acc_period,4) , right(acc_period,2) ) , 'YYYY-MM' )

    I have a requirement to display previous month sales based on the selected Date. I used the below exp for previous month sales,

    =Sum({$<Date={"$(=Max(Date)-1)"}>}sales)

    But it is not working. Please help me to solve this issue.

    Date format - YYYY-MM (2018-12)

    Show Less
  • New to QlikView

    Junk value populated in derived fields

    Hi Team,We are facing a issue of junk value getting populated in derived fields. But if reload the same data model multiple times this issue gets rect... Show More

    Hi Team,

    We are facing a issue of junk value getting populated in derived fields. But if reload the same data model multiple times this issue gets rectify. Kindly any one suggest the remedy.

     

    Regards,

    GR

    Show Less
  • New to QlikView

    Dynamically load and fill variables from a table (through a loop)

    Hello,I made this dashboard that helps me find certain combinations (text and numbers) from large pieces of text (Table: 'DATA''). This is just a... Show More

    Hello,

    I made this dashboard that helps me find certain combinations (text and numbers) from large pieces of text (Table: 'DATA''). This is just an example. In this case I'm always looking for a combination of two characters with variable amount of numbers.

    This works fine. However, I have a lot of these combinations (see TABLE1, this is just a small selection) and I do not want to copy the same code every time. Like I do right now, by each time: filling it with other characters and another amount of  digits. It would be nice, that I just have to alter TABLE1 or can  reload a Excel file.

    It would be nice that the 'RETRIEVAL' code goes through a loop and that the two characters and the amount of characters total presented are loaded dynamically from the TABLE1-table (TABLE1).

    I hope my explanation is clear, otherwise please let me know.
    Can anyone please help me achieve this?

    Kind regards,

    Eelco

     

     

     

    //Code:

    DATA:
    LOAD * INLINE [
    ID, TEXT
    1, 904OIE4Q09AKJN3QLKNMFWH9846DJKJWL45
    2, djalkkj489uquirfhe43hjkDE412657djwe
    3, lokjerjAQkoiKLDSp34ojWE5787884565456218iuafjklohasfdkjWH9845djkw456
    4, lkjslkjkjlwe89iQF845698752sdfjkle
    5, jlkkjl0923jkkllkdjfjkljkl545654ads
    ];


    TABLE1:
    LOAD * INLINE [
    CODE, LENGTH
    DE, 8
    WH, 6
    QF, 9
    WE, 10
    ];

    RETRIEVAL:
    LOAD
    ID, mid([TEXT],Index([TEXT],'DE')+0,8) AS RESULT
    Resident DATA;

    LOAD
    ID, mid([TEXT],Index([TEXT],'WH')+0,6) AS RESULT
    Resident DATA;


    LOAD
    ID, mid([TEXT],Index([TEXT],'QF')+0,9) AS RESULT
    Resident DATA;


    LOAD
    ID, mid([TEXT],Index([TEXT],'WE')+0,10) AS RESULT
    Resident DATA;

    Show Less
  • New to QlikView

    Showing all values on line chart

    Hi, I've been working with Qlik View for two weeks. I will like to show all the values of a line chart, like show all the series (Excel) or ... Show More

    Hi, 

    I've been working with Qlik View for two weeks. 

    I will like to show all the values of a line chart, like show all the series (Excel) or series group (SQL Report Builder), not the sum of all of them.

    The image shows two list box, the one of the left shows the values related to the list box of the right. The Line chart shows the sum of the values of the list box of the left, It doesn't show each value individually (two lines on this example). How can I do that? 

    Thanks in advance for your help.

    Best regards, 

    FranciscoQuestionQlikView.png

     

    Show Less
  • New to QlikView

    Filtering a table based on a list box value

    Hi,I have a list box which contains dates.My requirement is to create a filter on my table which will show the value for max(Date) (by default).I can'... Show More

    Hi,

    I have a list box which contains dates.

    My requirement is to create a filter on my table which will show the value for max(Date) (by default).

    I can't use "Select In Field" at Document level, as I need this filter only for this table. I have other tables in my page as well which shows All days data.

     

     

    Can you please help.

    Show Less
  • New to Qlik Sense

    Bar Chart - Trimester and Months together, is it possible?

    Hey guys, Its possible to create a combined bar/line chart like this? Dec/17 =  2017 accumulatedDec/18 =  2018 accumulated1T19 = F... Show More

    Hey guys,

     

    Its possible to create a combined bar/line chart like this?

    Imagem1.jpg

     

    Dec/17 =  2017 accumulated

    Dec/18 =  2018 accumulated

    1T19 = First 2019 trimester accumulated

    and next months.

     

    Tks guys!!!

    Show Less

Blogs

Qlik Community Manager Blogs

Hear from the Qlik Community team about the latest platform enhancements, announcements, and more.

Blogs

Qlik Education Blog

Check out the latest Education Blog written by Kevin Hanegan,Qlik Chief Learning Officer.

Blogs

Blogs

Hear directly from Qlik employees and stay current on the latest and greatest information about Qlik products. We have 8 blog types for you to choose from.

Groups

Join a Group

Join one of our Qlik Community user groups around an Industry, Location & Language, or Topic.

Groups

Qlik Deployment Framework

This group hosts information related to the Qlik Deployment Framework (QDF).

2700+ Members

Groups

Qlik Healthcare

This group is for healthcare organizations, partners, and Qlik healthcare staff to collaborate and share insights.

750+ Members
Sue_Stage : List Private Messages : Sign out : Switch user COMMUNITY Qlik Community Settings for: Community Qlik Community ChooseGo to Community ADMIN STUDIO TOOLBOX DISCUSSION STYLES FEATURES SYSTEM DISPLAY CONTENT USERS MOD TOOLS METRICS COMMUNITY STRUCTURE Search for settings Announcements Custom Content Custom Pages ActiveCast Featured Threads Promoted Search Select Custom Content Setting Event Card event-card Custom Content 7 Text

Events

Qlik Insider Webinar Series

What's New in 2019. Register for the Qlik Insider Webinar Series to stay connected on our latest releases

Available On Demand Webinar

Events

Events & Meetups

Participate in an upcoming Qlik related event, webinar, or local meetup.

Events

Welcome to Qlik

Join the “Welcome to Qlik” webinar and learn about the Qlik Ecosystem

Tuesday, August 27, 2019 Webinar
Show help for this page