Qlik Community

Welcome to Qlik Community

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


Introducing Qlik Gallery

Announcing the newest addition to the Qlik Community, Qlik Gallery!

Qlik Gallery is all about sharing – apps, outcomes, and ideas. This is your space to learn from each other as Qlik users, fans, thought leaders and data enthusiasts

Recent Discussions

  • QlikView Scripting

    Loop through files in folder and load into same table

    Hi allI'm struggling with a for each loop that should loop through a all subfolders in a given folder path and load content of excel files into the sa... Show More

    Hi all

    I'm struggling with a for each loop that should loop through a all subfolders in a given folder path and load content of excel files into the same table.

    The problem is that everytime it iterates to a new file and starts the load it increments the tablename.

    My code looks like this:

     

    set vRoot = 'C:\QlikView Storage\Group88\Data\NewFileFomats\*';

    for Each dir in DirList(vRoot)

    for Each file in Filelist('$(dir)\*.xlsx')

    tmp:
    load
    *
    from
    [$(file)\*.xlsx](ooxml, embedded labels, table is 'Import QW');

    next;

    Loadresult:
    load * Resident tmp;

    drop table tmp;

    next;

    As is there are 3 subfolders in the path C:\QlikView Storage\Group88\Data\NewFileFomats\* and it iterates through them all and loads the files but at the end I'm left with "temp-1" table, no Loadresult-table  and it only has data from one file.

     

    I know it is possible to load all files from a folder into the same table using something like 

    Tmp:

    Load * from 

    [C:\QlikView Storage\Group88\Data\NewFileFomats\Loewe\*.xlsx]
    (ooxml, embedded labels, table is Import QW);

    But how do implement this behaviour in the loop?

    Thanks in advance for the help.

    Best regards

     

     

     

     

     

     

     

     

    Show Less
  • New to QlikView

    Export to excel

    Hi,My code for export is:sub Export_CrtneKode Timestamp = Year(Date())&"-"&Month(Date())&"-"&Day(Date()) 'Create the Excel spreadsheet Set excelF... Show More

    Hi,

    My code for export is:

    sub Export_CrtneKode
    	  Timestamp = Year(Date())&"-"&Month(Date())&"-"&Day(Date())
    	'Create the Excel spreadsheet
    	Set excelFile = CreateObject("Excel.Application")
    	excelFile.Visible = false 'or false to run in background
      
        'Create the WorkBook
        Set curWorkBook = excelFile.WorkBooks.Add
        'Create the Sheet
        'first chart object
        Set curSheet = curWorkBook.WorkSheets(1)
    
    	'paste the object
    	Set i = ActiveDocument.GetSheetObject("CH02")
        i.CopyTableToClipboard true
    	curSheet.Cells(1, 1).Select
    	curSheet.Paste
    	
    	'to clear the clipboard
    	curSheet.Cells(1, 100).Copy
    	
    	
    	'define all cells format	
    	curSheet.Columns("A").EntireColumn.NumberFormat = "0"
    	curSheet.Columns(2).ColumnWidth = 50
    	curSheet.Columns("B").EntireColumn.NumberFormat = "@"
    	curSheet.Columns("C").EntireColumn.NumberFormat = "@"
    	curSheet.Columns("D").EntireColumn.NumberFormat = "0"
    	curSheet.Columns(5).ColumnWidth = 20
    	curSheet.Columns("E").EntireColumn.NumberFormat = "@"
    	curSheet.Columns("F").EntireColumn.NumberFormat = "@"
    	curSheet.Columns("G").EntireColumn.NumberFormat = "@"
    	curSheet.Columns("H").EntireColumn.NumberFormat = "@"
    			
    	excelFile.Visible = true
    	'Save the file and quit excel
    	excelFile.DisplayAlerts = False
    	curWorkBook.SaveAs "S:\Porocanje QlikView\Izdelki Farmadent\ČRTNE KODE FD"&" "&timestamp&".xlsx"
    	excelFile.DisplayAlerts = True
        curWorkBook.Close
        excelFile.Quit
        'Cleanup
        Set curWorkBook = nothing
        Set excelFile = nothing    
    
    end sub

     Column E is EAN code formatted as text.  After export the cell is displayed e.g. 6,94952E+12 instead of 6949517000018.

    Any idea how can I solve this?

    TIA, Igor

      

    Show Less
  • New to Qlik Sense

    date format issue?

    HiI have date field with time stamp.mydate:29/03/2018 22:38:1029/03/2018 22:42:1929/03/2018 22:44:1008/04/2018 09:32:1408/04/2018 10:38:1908/04/2018 1... Show More

    Hi

    I have date field with time stamp.

    mydate:

    29/03/2018 22:38:10

    29/03/2018 22:42:19

    29/03/2018 22:44:10

    08/04/2018 09:32:14

    08/04/2018 10:38:19

    08/04/2018 12:39:07

    14/05/2018  08:55:18

    14/05/2018  10:56:16 like that.

    my requirement is first i need to create the month field.above date it is available 3 months and each month having multiple date because time stamp.so i need to create only one date instead of 3 dates.like below

    Month:

    MAR-2018

    APR-2018

    MAY-2018

    JUN-2018  like that,how to achieve this.

    I am writing the exp in script level for month field like

    date(floor(date(mydate,'DD/MM/YYYY hh:mm:ss'),'MMM-YYYY') as month

    after derive the month field i want to create the line chart with rolling 12 months.if i have 4 months how to write the expression.

    Thanks

    Show Less
  • Qlik Sense App Development

    Rolling 12 months for sum and count

    Hi everyone,I want to have rolling 12 months on Sum and Count measure.I have seen many post related to this, but nothing worked well with my scenario-... Show More

    Hi everyone,

    I want to have rolling 12 months on Sum and Count measure.

    I have seen many post related to this, but nothing worked well with my scenario-

    here is my scenario -

    I have field as =

    This is my Datefield =Period("MMM-YYYY") 

    Sum(sales)

    Count({<Sale= {'External'} >} ExternalSale)

    So now i need to have rolling 12 months(From this October 2019 to October 2018)  in the above sum and Count measure.

    what is the best way ?

     

    Thanks in advance! 

     

     

     

     

     

    Show Less
  • Qlik Sense App Development

    QlikSense Conditional Code

    I have below qvd files in my library location. I only want to load data from 2018_05 to rest all. How to transform my existing code(Given below)?AUXFI... Show More

    I have below qvd files in my library location. I only want to load data from 2018_05 to rest all. How to transform my existing code(Given below)?

    AUXFILE_2018_03.qvd
    AUXFILE_2018_04.qvd
    AUXFILE_2018_05.qvd
    AUXFILE_2018_06.qvd
    AUXFILE_2018_07.qvd
    AUXFILE_2018_08.qvd
    AUXFILE_2018_09.qvd
    AUXFILE_2018_10.qvd
    AUXFILE_2018_11.qvd
    AUXFILE_2018_12.qvd
    AUXFILE_2019_01.qvd
    AUXFILE_2019_02.qvd
    AUXFILE_2019_03.qvd
    AUXFILE_2019_04.qvd
    AUXFILE_2019_05.qvd
    AUXFILE_2019_06.qvd

    ****My Code****

    Set vStartYear = 2018;
    Let vCurrentYear= year(now());
    For vYear = $(vStartYear) to $(vCurrentYear)

    DTA:

    LOAD
    ID,
    Region,
    Country

    FROM [lib://CID/AUXFILE_$(vYear)*.qvd]
    (qvd);

    store DTA into [lib://STR/DTA_$(vYear).qvd));

    next vYear

    Show Less
  • QlikView App Development

    variable in set analysis for dynamic change

    Hi,I need to find a formula where variable 'VERSION' changes dynamically in relation to given month.In my case names of VERSIONS are corresponding to ... Show More

    Hi,

    I need to find a formula where variable 'VERSION' changes dynamically in relation to given month.

    In my case names of VERSIONS are corresponding to MONTH names (formated as data)

     
     

     

     

     

     

     

     

    My formula is not working:

    sum({<VERSION = {'=Month'}>} VAL)

    As a result I want the formula to take value for EACH MONTH from different VERSION

    Show Less
  • QlikView Scripting

    Recargar Excel

    Buenas tardes,Tengo una app conectada a una base de datos y tambien a un archivo de Excel. Necesito saber si hay posibilidad de recargar solamente el ... Show More

    Buenas tardes,

    Tengo una app conectada a una base de datos y tambien a un archivo de Excel. 

    Necesito saber si hay posibilidad de recargar solamente el Excel y no toda la aplicacion. Es viable?

     

    Gracias

    Saludos

    Show Less
  • QlikView Publisher

    Access Point No Preview Available

    We have  a handful of QV apps on the access point that say "No Preview Available". QV 12.4 SR1They have not been saved in web view.We have made the sy... Show More

    We have  a handful of QV apps on the access point that say "No Preview Available". QV 12.4 SR1

    They have not been saved in web view.

    We have made the system.ini entry: QvThumbnailCacheUpdateInterval=1

    We have cleared the browser cache.

    If we change the Document Thumbnail to Opening Sheet, it works as expected. Setting it back to Image, returns the "No Preview Available" message.

    Any ideas?

    Show Less
  • QlikView App Development

    Just reload whitout Publisher

    Hi, i have a QlikView with Macro to export images (exportImages). I want to use this on a simple Windows 10 client. Can i use som batchfile to reload ... Show More

    Hi, i have a QlikView with Macro to export images (exportImages). 

    I want to use this on a simple Windows 10 client. 

    Can i use som batchfile to reload this file with type AutoMize?

    Is that possible?

     

    Br

    Show Less
  • Qlik Support Techspert Thursdays

    STT - Exploring Qlik Sense Enterprise on Kubernetes

    This session will address the following:- Look at new features- What to do first- Live demonstration- Gotchas to avoid     For more information: http... Show More

    This session will address the following:
    - Look at new features
    - What to do first
    - Live demonstration
    - Gotchas to avoid

     

     

    For more information:

    https://support.qlik.com/articles/000085749

    Resource links:
    App Administration - Administer Qlik Sense Enterprise on Kubernetes
    Kubectl - Kubectl Cheat Sheet
    Helm - Helm Chart Best Practices Guide 
    Logging - Qlik Sense Enterrpise on Kubernetes Monitor Metrics 
    Git Ops - Highly Effective Kubernetes Deployments with GitOps 
    Scaling –Assigning Pods- Assign Pod Node 
    Template Values Yaml - QSEoK Support Templates 
    Minimum Prereqs - Minimum Qlik Sense Enterprise Pre-Requisites 
    MongoDB – Stateful Sets - Running MongoDB on Kubernetes with Stateful Sets 
    Setup instructions of demo environment  
    Video demonstrating setup of Qlik Sense Enterprise on Azure AKS 

    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

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