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.
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.
|15-07-2019||1.00 Am||Job Start:Turning|
|15-07-2019||2.00 Am||Task Start: Turning Componrnt 1 load tool|
|15-07-2019||2.30 Am||tool loaded|
|15-07-2019||3.00 Am||Task End: Turning Componrnt 1 load tool|
|15-07-2019||3.30 Am||Task Start: Turning Componrnt 2 load tool|
|15-07-2019||4.00 Am||tool loaded|
|15-07-2019||5.15 Am||Task End:Turning Componrnt 2 load tool|
|15-07-2019||5.55 Am||Job End: Turning|
|15-07-2019||6.12 Am||Job Start:Milling|
|15-07-2019||6.30 Am||Task Start: Milling Componrnt 1 load tool|
|15-07-2019||7.00 Am||tool loaded|
|15-07-2019||7.25 Am||Task End:Milling Componrnt 1 load tool|
|15-07-2019||7.40 Am||Task Start: Milling Componrnt 2 load tool|
|15-07-2019||7.50 Am||tool loaded|
|15-07-2019||8.15 Am||Task End: Milling Componrnt 2 load tool|
|15-07-2019||8.18 Am||Job End: Milling|
|15-07-2019||8.30 Am||Job Start :Cleaning|
|15-07-2019||8.35 AM||Task Start: CleaningComponrnt 2 load tool|
|15-07-2019||8.40 Am||tool loaded|
|15-07-2019||8.45 Am||Task End: CleaningComponrnt 2 load tool|
|15-07-2019||8.45 Am||Job End:Cleaning|
I need to get table similar so that i can filter in the front end by Job and Task
|date||time||Event||JOB||Start Time||End Time|
|15-07-2019||1.00 Am||Job Start:Turning||Turning||1.00 Am||5.55 Am|
|15-07-2019||2.00 Am||Task Start: Turning Componrnt 1 load tool||Turning||1.00 Am||5.55 Am|
|15-07-2019||2.30 Am||tool loaded||Turning||1.00 Am||5.55 Am|
|15-07-2019||2.40 Am||Machining||Turning||1.00 Am||5.55 Am|
|15-07-2019||3.00 Am||Task End: Turning Componrnt 1 load tool||Turning||1.00 Am||5.55 Am|
|15-07-2019||3.30 Am||Task Start: Turning Componrnt 2 load tool||Turning||1.00 Am||5.55 Am|
|15-07-2019||4.00 Am||tool loaded||Turning||1.00 Am||5.55 Am|
|15-07-2019||5.00 Am||Machining||Turning||1.00 Am||5.55 Am|
|15-07-2019||5.15 Am||Task End:Turning Componrnt 2 load tool||Turning||1.00 Am||5.55 Am|
|15-07-2019||5.55 Am||Job End: Turning||Turning||1.00 Am||5.55 Am|
|15-07-2019||6.12 Am||Job Start:Milling||Milling||6.12 Am||8.18 Am|
|15-07-2019||6.30 Am||Task Start: Milling Componrnt 1 load tool||Milling||6.12 Am||8.18 Am|
|15-07-2019||7.00 Am||tool loaded||Milling||6.12 Am||8.18 Am|
|15-07-2019||7.20 Am||Machining||Milling||6.12 Am||8.18 Am|
|15-07-2019||7.25 Am||Task End:Milling Componrnt 1 load tool||Milling||6.12 Am||8.18 Am|
|15-07-2019||7.40 Am||Task Start: Milling Componrnt 2 load tool||Milling||6.12 Am||8.18 Am|
|15-07-2019||7.50 Am||tool loaded||Milling||6.12 Am||8.18 Am|
|15-07-2019||8.05 Am||Machining||Milling||6.12 Am||8.18 Am|
|15-07-2019||8.15 Am||Task End: Milling Componrnt 2 load tool||Milling||6.12 Am||8.18 Am|
|15-07-2019||8.18 Am||Job End: Milling||Milling||6.12 Am||8.18 Am|
|15-07-2019||8.30 Am||Job Start :Cleaning||Cleaning||8.30 Am||8.45 Am|
|15-07-2019||8.35 AM||Task Start: CleaningComponrnt 2 load tool||Cleaning||8.30 Am||8.45 Am|
|15-07-2019||8.40 Am||tool loaded||Cleaning||8.30 Am||8.45 Am|
|15-07-2019||8.45 Am||Cleaning||Cleaning||8.30 Am||8.45 Am|
|15-07-2019||8.45 Am||Task End: CleaningComponrnt 2 load tool||Cleaning||8.30 Am||8.45 Am|
|15-07-2019||8.45 Am||Job End:Cleaning||Cleaning||8.30 Am||8.45 Am|
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.
Please help me the above issue.
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 ?
ur qlikview fri
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.
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?
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?
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 ?
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).
Join one of our Qlik Community groups related to an Industry, Location, Language, or Topic.