Qlik Community

Welcome to Qlik Community

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

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.


WEBINAR SERIES: THE DX FILES

When disruption is nonstop, how do you compete – and thrive? Digital Transformation is a must, and data is at the heart of it. To pull ahead of the pack, stay in front of the trends, and keep pushing innovation further, you have to consistently reinvent your business – fast – with a modern approach to data. When it comes to Digital Transformation, the truth isn’t out there – it’s in here. Join us July 30 – August 28, 2019, for 5 tracks of insight-packed webinars.

Recent Discussions

  • Qlik Sense Advanced Authoring

    Count number of days for available rooms

    I'm building a dashboard for hotel purpose and I have this data set I having a problem here to come up with a formula how to calculate available ... Show More

    I'm building a dashboard for hotel purpose and I have this data set 

    as.PNG

    I having a problem here to come up with a formula how to calculate available room on the given date since there are many different people check out on a different date.

    I tried Googling it and I found a solution where COUNTIFS is being used in excel. Anybody know how can I solve this in qlik sense measure ?

    Show Less
  • Qlik NPrinting Discussions

    Excel reports - Embedded HTML - NP17 missing feature

    Dear all,Am I the only one to request this feasture in NPrinting 17 ?  I successfuly  used the feature with Nprinting 16 . In my case  ... Show More

    Dear all,

    Am I the only one to request this feasture in NPrinting 17 ?  I successfuly  used the feature with Nprinting 16 . In my case  it was  to manage  "merge cells".   I added some "merge cells" just above my headers to group with a nice banner my measures.

    I'll to do this report in HTML but honestly with I'm going to spend more time on it

    "The possibility to embed Excel reports in the e-mail body is not present in the NPrinting 17 and higher release and it is not in the road map so far. Only HTML reports and QlikView entity reports can be embedded."

    are there other people in the same case as me?  

    Show Less
  • New to Qlik Sense

    QlikSense Stacked Barchart with grey bar

    Hello everyone,I have a problem that I'am not understanding the reason.I've been working with QlikSense (2019 June's version) and I created the follow... Show More

    Hello everyone,

    I have a problem that I'am not understanding the reason.

    I've been working with QlikSense (2019 June's version) and I created the following bar chart and it is perfect:

    V1.jpg

     

    On X-axis I customized the range [Min/Max] and the values are between 0 and a variable that is the sum of both expressions of the chart.

    Yesterday I updated QlikSense to the last version (2019 July) and the same bar chart is now looking like this:

    V2.jpg

     

    Why is that grey bar appearing?

    I tried to limit the dimensions and it didn't work.

    I tried to customize the X-axis only with Min = 0 and IT WORKED BUT I'am losing a behavior that I want.

    I tried the same app in the previous QlikSense version and it looks perfect again.

    Is this a bug in the new version?

    @Gysbert_Wassenaar 

    @sunny_talwar 

    @swuehl 

    Thanks in advance by your help and availability.

    Best regards,

    V.Castro

     

     

    Show Less
  • QlikView App Development

    Pareto Count with 2 Dimensions?

    Hi all,I have a pivot table as shown below:In this, I'm trying to calculate 80% Potential savings for each Supplier and the number of dimension values... Show More

    Hi all,

    I have a pivot table as shown below:

    Sc1.PNG

    In this, I'm trying to calculate 80% Potential savings for each Supplier and the number of dimension values(controlled by the panel on the left, 'Levels') that make up this 80% savings. I have written a formula for this as follows:

    =Count(Distinct

    Aggr(

    If(

    Rangesum(Above(

    Sum(Price_Red)/Sum( total Price_Red)

    ,1,RowNo()

    ))<=0.8,$(vDim1)),

    ($(vDim1),(=Sum(Price_Red),Desc))

    )

    )

    where 'Price_Red' is the savings value and $(vDim1) is the variable controlling the dimension values that are needed to be counted.

    But the thing is, I want to display this count by each Supplier in the table and right now, this only happens if I select each supplier individually from the table.

    I tried looking into Sunny's answer here and modified my formula but still doesnt give the required output. Please help me include the Supplier dimension in this calculation.

    Attaching the qvf for your ref. Thanks in advance! @sunny_talwar @tresesco 

    Show Less
  • New to QlikView

    How to Link two table with mutliple fields

    Good Day,Please help the best approach in linking two tables (using left join) with multiple fields, please see below sample querytable1:LOADcust_id,a... Show More

    Good Day,

    Please help the best approach in linking two tables (using left join) with multiple fields, please see below sample query

    table1:

    LOAD

    cust_id,

    app_id,

    account_number

    FROMsource....;

    LEFT JOIN(table1)

    LOAD

    cust_id,

    app_id,

    reasons

    RESIDENT (table2);

     

    I need to link table1 and table2 using cust_id and app_id fields with OR operator

     

    Thank you

     

     

    Show Less
  • QlikView App Development

    Calculating time in script

    Hi All, I'm having a problem with calculating time.In our planning-tooldatabase I have 2 time fields. (Planned time and the time spend)Those are ... Show More

    Hi All,

     

    I'm having a problem with calculating time.

    In our planning-tooldatabase I have 2 time fields. (Planned time and the time spend)

    Those are numeric for example if you get 16 hours in the database we zee 1600, if you get 2h and a half you se 230 in the database.

    I can create a timefield in the script by using those 2 

    Interval((left(num(PlannedTime,'0000'),2) * 60 + Mid(num(PlannedTime,'0000'),3,2))/24/60,'hh:mm') as PlannedTimehhmm,
    Time((left(num(PlannedTime,'0000'),2) * 60 + Mid(num(PlannedTime,'0000'),3,2))/24/60,'hh:mm') as PlannedTimeTijdhhmmTime

    And the same for the SpendTime.

    But how can I subtract those fields so I get the time that is available for this order?

    Regards,

    Kris

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    How to use Qlik's native search feature in my extension

    Hello,I would like to use existing search feature in my own extension.How can I programmatically invoke such window when user clicks on a search icon ... Show More

    Hello,

    I would like to use existing search feature in my own extension.

    ui_ListSearch

    How can I programmatically invoke such window when user clicks on a search icon in my extension? I can't find source code of native table so I can't check how it's done. The same search window appears when clicking on filter pane element, but again, I can't find the source code.

    Both native table and Vizlib table use the same search feature so I believe it must be somehow accessible. This widget is very similar to the widget provided by Selection API (when you click and select) which is available for programmers, but I can't find a way to enable this standard search functionality in my extension.

    Show Less
  • Qlik Sense Deployment & Management

    Error when reload License Monitor

    HiI received below error message when reload License Monitor. Our default virtual proxy has window as authentication.Where else I should check?Best re... Show More

    Hi

    I received below error message when reload License Monitor. Our default virtual proxy has window as authentication.

    Where else I should check?

    Best regards,

    susan

     

    LIcenceMonitor_reloadError.PNG

    Show Less
  • New to Qlik Sense

    Expression Not Calculating

    Can anyone tell me what is wrong with the following expression:=Count({<$(vNumber)={'Strongly agree'}>}$(vNumber)/Count({<$(vNumber)={'Strong... Show More

    Can anyone tell me what is wrong with the following expression:

    =Count({<$(vNumber)={'Strongly agree'}>}$(vNumber)
    /
    Count({<$(vNumber)={'Strongly agree','Agree','Disagree','Strongly disagree'}>}$(vNumber)

     

    i am trying to work out the percentage of strongly agree answers out of total responses. 

    I am trying to create a variable so i can flick between the questions however the above formula is not calculating

    Show Less
  • New to Qlik Sense

    Bar & area chart 100% stacked bar - remove negative values from Y - axis - june ...

    Hi!the last release of June 2019 includes the following improvement:Improved tooltip for stacked bars now displays positive and negative totals.I have... Show More

    Hi!

    the last release of June 2019 includes the following improvement:

    • Improved tooltip for stacked bars now displays positive and negative totals.

    I have carried out the update from Qlik Sense April 2019 to Qlik Sense June 2019 because of the bug: "When trying to show or hide chart objects with the Show/Hide Container extension, depending on the defined variable value, changing to another sheet and back does not seem to refresh the view."

    The thing is:

    First: the bug continues existing…

    Second: now the bar & area visualization display negatives values in the y-axis even when there’s no negative value in the measure.

    ¿How can I remove negative y-axis values when they are not necessary? I’ve tried to look for each option that the object allows to parametrize but I haven’t found the way. I just need to show from 0% to 100% (grid height relative to max bar is = 1 already)

    Thank you in advance!

    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.