Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
2,339 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.

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

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

Information about additional Qlik opportunities and offerings.

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

Discussion Boards and Documents for Qlik Services.

View our Technical Blogs for updates and information.

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.

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.

Register for Qonnections


Register for Qonnections
Save $100


Follow your data to the biggest places imaginable. Join Qonnections in Dallas, Texas May 13-16. Get insights to help you and your team drive real transformation. Register by April 28 for your last chance to save $100.

Recent Discussions

  • QlikView App Development

    Scale up until 100% and value 0

    Hi guys,I need to show a chart with the scale correct, now I have a chart with the value equal 0 but the scale is going up until 100%, can I put this ... Show More

    Hi guys,

    I need to show a chart with the scale correct, now I have a chart with the value equal 0 but the scale is going up until 100%, can I put this scale dynamic? Why the scale is up until 100%?

    scale0.png

    Show Less
  • New to Qlik Sense

    Percentage calculation

    Hello,Here's the situation:I have a calculation: sum(colli) and sum(losseStuks) these to combined shows a total.Now I need to show how much percent of... Show More

    Hello,

    Here's the situation:

    I have a calculation: sum(colli) and sum(losseStuks) these to combined shows a total.

    Now I need to show how much percent of this total contains colli and how much contains losseStuks.

    So sum(colli) + sum(losseStuks) = 100%

    colli = ..% of this total

    losseStuks= ..% of this total

     

    this should all be in a pivot table.

    Where the dimension is a name and the measure is the percentages.

     

    any ideas?

    This is way to difficult for me.

    Thanks in advance

    DC

    Show Less
  • QlikView App Development

    Fetching data from SQL

    Hello Community,      I have a little problem here.I Have two table Referentiel(Code,Type,DateImg) and Client(Code,Name,CIN) ... Show More

    Hello Community, 

         I have a little problem here.

    I Have two table Referentiel(Code,Type,DateImg) and Client(Code,Name,CIN) .

    i want to get all those information which DateIMG = date(now()-1,'DDMMYYYY');

     

    The problem resident in clause Where, it's limited in 1000 rows.

    How Can I fetch more than 1000 rows in a time.

     

    Thank you for your Help

    Show Less
  • QlikView Layout & Visualizations

    Pie chart showing the share of null value and non-null value (in %)

    Hello all,Please could you help me to represent in a pie chart the share of null value and non-null value (in %) from a specific field.Thank you ... Show More

    Hello all,

    Please could you help me to represent in a pie chart the share of null value and non-null value (in %) from a specific field.

    Thank you in advance for your help.

     

    Show Less
  • Qlik Sense App Development

    Expression does not work after reload with section access

    Hi,Expression is Count({< Time= {"$(=Max(Time))"}>} DOC_ID)It works normally but after adding section access script and reload, this value ... Show More

    Hi,

    Expression is Count({< Time= {"$(=Max(Time))"}>} DOC_ID)

    It works normally but after adding section access script and reload, this value returns null.(0)

    Kindly help.

    Thanks

    Show Less
  • Qlik NPrinting Discussions

    Multi KPI in HTML Nprinting

    In Qlik Sense Feb 2019 I created some Multi KPI objects, when I embed them in Nprinting (February 2019 SR1) in an HTML doc only the titles are shown.D... Show More

    In Qlik Sense Feb 2019 I created some Multi KPI objects, when I embed them in Nprinting (February 2019 SR1) in an HTML doc only the titles are shown.

    Does anyone know if it is possible to use Multi KPI objects in Nprinting?

    Show Less
  • QlikView App Development

    Embedding Hyperlink to dimension labels in PDF reports

    I have an urgent executive requirement to incorporate links to various consoles/web pages in a PDF report. The link is meant to be incorporated into t... Show More

    I have an urgent executive requirement to incorporate links to various consoles/web pages in a PDF report. The link is meant to be incorporated into the label definition of chart type objects as attached in the sample. PDF X-Change is currently used to generate this report.

    Attached is a sample file being used to test how this can be achieved.

    How can this be achieved such that a link to dimension labels in reports can be made to work when a PDF file is generated?

    Please help with insights on how this can be achieved.

    Show Less
  • New to Qlik Sense

    hide 0 value from tables

    I would like to hide below high light row from the table as their values are 0.  Even i already uncheck "include zero value" but i'm still seeing... Show More

    I would like to hide below high light row from the table as their values are 0.  Even i already uncheck "include zero value" but i'm still seeing these row exist under the table.

    Given they are all measures and not dimesnions.

    4-25-2019 4-07-31 PM.jpg

    Show Less
  • New to Qlik Sense

    concatenate multiple odbc queries

    Hi all,Is it possible to concatenate multiple SQL queries? E.g.Query 1:Load CONT_ID,CONT_INV;SQL SELECT CONT_ID,CONT_INVFROM abc.cont_file Query ... Show More

    Hi all,

    Is it possible to concatenate multiple SQL queries? E.g.

    Query 1:

    Load CONT_ID,

    CONT_INV;

    SQL SELECT CONT_ID,

    CONT_INV

    FROM abc.cont_file

     

    Query 2:

    Load CONT_ID,

    ASSET_ID;

    SQL SELECT CONT_ID,

    ASSET_ID

    FROM abc.pos_file

     

    Query 3:

    Load ASSET_ID,

    ASSET_NAME;

    SQL SELECT

    ASSET_ID,

    ASSET_NAME

    FROM abc.asset_file

     

    Target is a Table with

    ASSET_ID,

    CONT_INV,

    ASSET_NAME

    Reason:

    I have a Table with

    Table_1:

    Name,

    CONT_INV,

    ASSET_ID,

    Value

    _________________________

    CONT_INV and ASSET_ID and Value are dependent = The value is releated to both (CONT_INV and ASSET_ID)

     

    Is it possible?

    Show Less
  • Qlik Sense App Development

    Build the Pivot Table. Incorrect Data

    Hi. I need you help. Situation: Client wants some the general report using pivot table for three differents customers and customers apps. So, I w... Show More

    Hi. I need you help. Situation: Client wants some the general report using pivot table for three differents customers and customers apps. 

    So, I wrote the SQL Stored procedure with all the data for three customers and categories. Data from SQL is correct.

    In Qlik Sense I download all the data into one table, after this for customers and customers app I download small table. Qlik builds synt key, which include four columns. When I download data for 1 customer - everything is ok. When I download for 2 customers - the same fields displays in pivot into others format(format in qlik is auto, I prepared and formatted data in SQL, in Qlik data transfers in format).

     

    Why is it happens? Or maybe you know the best idea how I can build it.

    Thanks.

     

    Show Less

Blogs

Qlik Community Blogs

Check out our community blogs to stay current on the latest and greatest information about Qlik products.

7 Blogs

Groups

Join a Group

Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.

28 Groups

Events

Events & Meetups

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