Qlik Community

Welcome to Qlik Community

cancel
Showing results for 
Search instead for 
Did you mean: 
978 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

  • New to Qlik Sense

    Creating start and end time from changing dimension

    HI Can someone please help me with below requirement Logic and function to be used .I need to filter by JOB and Task with start and end time for ... Show More

    HI 

    Can someone please help me with below requirement Logic and function to be used .

    I need to filter by JOB and Task with start and end time for JO B and event respectively.

    Log Table:

    datetimeEvent
    15-07-20191.00 AmJob Start:Turning
    15-07-20192.00 AmTask Start: Turning Componrnt 1 load tool
    15-07-20192.30 Amtool loaded
    15-07-20192.40 AmMachining
    15-07-20193.00 AmTask End: Turning Componrnt 1 load tool
    15-07-20193.30 AmTask Start: Turning Componrnt 2 load tool
    15-07-20194.00 Amtool loaded
    15-07-20195.00 AmMachining
    15-07-20195.15 AmTask End:Turning Componrnt 2 load tool
    15-07-20195.55 AmJob End: Turning
    15-07-20196.12 AmJob Start:Milling
    15-07-20196.30 AmTask Start: Milling Componrnt 1 load tool
    15-07-20197.00 Amtool loaded
    15-07-20197.20 AmMachining
    15-07-20197.25 AmTask End:Milling Componrnt 1 load tool
    15-07-20197.40 AmTask Start: Milling Componrnt 2 load tool
    15-07-20197.50 Amtool loaded
    15-07-20198.05 AmMachining
    15-07-20198.15 AmTask End: Milling Componrnt 2 load tool
    15-07-20198.18 AmJob End: Milling
    15-07-20198.30 AmJob Start :Cleaning
    15-07-20198.35 AMTask Start: CleaningComponrnt 2 load tool
    15-07-20198.40 Amtool loaded
    15-07-20198.45 AmCleaning
    15-07-20198.45 AmTask End: CleaningComponrnt 2 load tool
    15-07-20198.45 AmJob End:Cleaning

     

    I need to get table similar so that i can filter in the front end by Job and Task

    datetimeEventJOBStart TimeEnd Time
    15-07-20191.00 AmJob Start:TurningTurning1.00 Am5.55 Am
    15-07-20192.00 AmTask Start: Turning Componrnt 1 load toolTurning1.00 Am5.55 Am
    15-07-20192.30 Amtool loadedTurning1.00 Am5.55 Am
    15-07-20192.40 AmMachiningTurning1.00 Am5.55 Am
    15-07-20193.00 AmTask End: Turning Componrnt 1 load toolTurning1.00 Am5.55 Am
    15-07-20193.30 AmTask Start: Turning Componrnt 2 load toolTurning1.00 Am5.55 Am
    15-07-20194.00 Amtool loadedTurning1.00 Am5.55 Am
    15-07-20195.00 AmMachiningTurning1.00 Am5.55 Am
    15-07-20195.15 AmTask End:Turning Componrnt 2 load toolTurning1.00 Am5.55 Am
    15-07-20195.55 AmJob End: TurningTurning1.00 Am5.55 Am
    15-07-20196.12 AmJob Start:MillingMilling6.12 Am8.18 Am
    15-07-20196.30 AmTask Start: Milling Componrnt 1 load toolMilling6.12 Am8.18 Am
    15-07-20197.00 Amtool loadedMilling6.12 Am8.18 Am
    15-07-20197.20 AmMachiningMilling6.12 Am8.18 Am
    15-07-20197.25 AmTask End:Milling Componrnt 1 load toolMilling6.12 Am8.18 Am
    15-07-20197.40 AmTask Start: Milling Componrnt 2 load toolMilling6.12 Am8.18 Am
    15-07-20197.50 Amtool loadedMilling6.12 Am8.18 Am
    15-07-20198.05 AmMachiningMilling6.12 Am8.18 Am
    15-07-20198.15 AmTask End: Milling Componrnt 2 load toolMilling6.12 Am8.18 Am
    15-07-20198.18 AmJob End: MillingMilling6.12 Am8.18 Am
    15-07-20198.30 AmJob Start :CleaningCleaning8.30 Am8.45 Am
    15-07-20198.35 AMTask Start: CleaningComponrnt 2 load toolCleaning8.30 Am8.45 Am
    15-07-20198.40 Amtool loadedCleaning8.30 Am8.45 Am
    15-07-20198.45 AmCleaningCleaning8.30 Am8.45 Am
    15-07-20198.45 AmTask End: CleaningComponrnt 2 load toolCleaning8.30 Am8.45 Am
    15-07-20198.45 AmJob End:CleaningCleaning8.30 Am8.45 Am

     

    Show Less
  • Community Corner

    Data loading

    Hello Guys,I have two fields (Date_of_Approval) and CHANGENR.I want to load CHANGENR asc then everyday of first record in my application ple... Show More

    Hello Guys,

    I have two fields (Date_of_Approval) and CHANGENR.

    I want to load CHANGENR asc then everyday of first record in my application please check the below example and required output.

    Data:

    Date_of_Approval[PR No]CHANGENR
    4/30/201911010404810043087912
    5/9/201911010405020043088215
    5/29/201911010405140043097780
    5/29/201911010405140043097789
    6/12/201911010405210043101344
    6/20/201911010405300043101731
    6/20/201911010405300043101740
    7/17/201911010405110043104002
    7/17/201911010405160043104004
    7/17/201911040039050043104005
    7/18/201911010405410043104403

     

     

    Required Output:

    Date_of_Approval[PR No]CHANGENR
    4/30/201911010404810043087912
    5/9/201911010405020043088215
    5/29/201911010405140043097780
    6/12/201911010405210043101344
    6/20/201911010405300043101731
    7/17/201911010405110043104002
    7/18/201911010405410043104403

     

    Please help me the above issue.

     

    Thank you

    Show Less
  • QlikView Layout & Visualizations

    Wrap text in presentation tab in Chart Properties for dimension label is gone i...

    Hi Qlikview fris, It seems wrap text in presentation tab in chart properties in qlikview 12 is gone as attached? I remember previous some ve... Show More

    Hi Qlikview fris, 

    It seems wrap text in presentation tab in chart properties in qlikview 12 is gone as attached? 

    I remember previous some version , it can be found wrap text in presentation tab in chart properties to wrap text from 1 line into 2 lines if it is too long text?

    May I ask if it is possible still to wrap text from chart properties in qlikview 12 for the screenshot below(Qvw attached)? or any alternative easy way to achieve this ?

     

     

     

    screenshot wrap text.PNG

    Thanks 

    ur qlikview fri

     

     

    Show Less
  • New to QlikView

    Qv app Reload Time Doubled up out of nowhere (QMC showing double reload time)

    Out of Nowhere, our QV apps (Qlikview 12) doubled up the reload time. we have looked but so far no luck finding the Root Cause.  
  • Qlik Sense App Development

    Pivot table export in merged format in QlikSense

    Hello Friends,Appreciate your time.  I am using a Pivot table for one of my chart , but is it possible to export the same in a merged format as l... Show More

    Hello Friends,

    Appreciate your time.  I am using a Pivot table for one of my chart , but is it possible to export the same in a merged format as like a straight table  data while exporting alone anything using native QlikSense or Vizlib is ok.

     

    Thank you,

    Kiruthiga

    Show Less
  • New to Qlik Sense

    Improving performance of expression

    Hi all,In my Qlik Sense app I have codes with start and close timestamps, and a calendar dimension (link_date_time_15min) that consist of timestmaps w... Show More

    Hi all,

    In my Qlik Sense app I have codes with start and close timestamps, and a calendar dimension (link_date_time_15min) that consist of timestmaps with 15 minute intervals.

    On a table I'm using a master dimension defined as:

    =if('$(=close_timestamp)'>=link_date_time_15min AND '$(=start_timestamp)'<=link_date_time_15min, timestamp(link_date_time_15min,'hh:mm'))

    When I pick a code, I'm seeing on the table the list of link_date_time_15min between close and start timestamp, which is what I was looking for, but while calculating the result the CPU and memory go to 100% and sometimes my app becomes unresponsive.

    Do you know of any other method to achieve the same results but with better performance?

    Thanks!

    Juan

    Show Less
  • Qlik Sense Integration, Extensions, & APIs

    Custom extension in a published app used by different users

    I developed an custom extension and has been published within an app. The single app is being used by different users. For every user, does Qlik Sense... Show More

    I developed an custom extension and has been published within an app. The single app is being used by different users. For every user, does Qlik Sense creates a new session and how does it works?

    We are noticing some issue with the extension when used by multiple users.  Is it possible that data within an extension can be updated by multiple users instead of one?

     

    Show Less
  • New to Qlik Sense

    How to embed a button from Qliksense into a web page

    In QlikSense, I have a chart and a button. When I click the button it triggers few filters and it is working fine.So I started to embed this chart int... Show More

    In QlikSense, I have a chart and a button. When I click the button it triggers few filters and it is working fine.

    So I started to embed this chart into HTML page (using IFrame) and it is working fine. When I embedded the button to HTML page, I can see the button but when I click on the button it doesn't execute the filters. Can we embed the buttons into web page ? If not is there any other way that I can do this ?

     

    Thanks

     

    Show Less
  • New to QlikView

    Hide/Show button depending on the selected object

    Dear all,       I have a container (CT01) with two bar charts, Month (CH01) and Year(CH02), and a button 'Test' (BU01).  &nbs... Show More

    Dear all,

           I have a container (CT01) with two bar charts, Month (CH01) and Year(CH02), and a button 'Test' (BU01).
           I'd like to set a conditional to button that it will only appear if the Month  is selected (displayed / activated). And off course the button hide when Year is selected (displayed / activated).

    Regards!

    Show Less
  • New to QlikView

    Map with personal edition

    I want to create a map in qlik personal edition but it desn't work , I have no map Can you help me please ?   

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.