to follow, share, and participate in this community.
Hello Everyone, I have attached the document for the important Qlikview functions used in script as well as in UI. Please have a look and also feel free to update the document or comment in the session for th... Hi All, This document helps you in loading multiple excels and excel sheets with the name of the sheet and data. //to read each file from the specified folder FOR EACH file in FileList('filepath\*.xlsx... Generally, QVD's are one of the most important in any Qlikview deployment. A QVD (QlikView Data) file is a file containing a table of data exported from QlikView. QVD is a native QlikView format and can only b... Introduction
Pre Reading- The Extension Template: See below or on the blog here: PreReading- Qlikview Extension in a few easy steps and with an improved template – Qlik and Dirty
Step1- A bas... This document explains some issues identified in testing the REST connector with Pipedrive data using the Start & Limit parameters for paging the output results from the Pipedrive API. I have been using th... Hope the below macro scripts helps beginners Source : QlikView Macros – Useful collection | Lucian Cotea 1) Run external program: FUNCTION RunExe(cmd) CreateObject("WScript.Shell").Exec(cmd) END FUNCTION... Below script helps in generating the Master calendar. In this script I am getting the Minimum and Maximum dates in my Invoice table and generating the entries for each date in CalendarMaster table between minimu... (MENSAJE EN ESPAÑOL A CONTINUACIÓN) Last status - 15/07/2018 QVW apps and original files with player predictions attached (RAR file) ----------------------------------------------------------------... Hi All, Here is another document with screenshot for beginners. This is all about how to perform 'Forecasting' in qlikview with manual input. Please find the document attached. Your comments are welcome. R... Hello everyone! Higher management often requires specific data delivered to their mailbox every morning. They are not interested in interaction, using filters and “playing” with data. They just wan... Hi Community, I developed the Northwind application for table viewer table automatically generated and Export to Excel in Local drive ('C:\Northwind DataViewer Table) using Macro. Please check and let me know... How to reload Qlikview application on every Monday? ///$tab Main SET ThousandSep=','; SET DecimalSep='.'; SET MoneyThousandSep=','; SET MoneyDecimalSep='.'; SET MoneyFormat='$#,##0.00;($#,##0.00)'; SET TimeForm... This article was sparkled by this discussion thread on Qlik Community. The question was: how to calculate the difference between dates that are stored in consecutive rows of a table? Three answers to the question sugg... Variables are really useful for a lot of things because you could store many different things within them and this could be changed while runtime or on user-action. Therefore they will be called variables. Qli... Hey, I hope I can solve a lot of peoples headache with a better way of loading JSON data. This method works by loading the JSON data into an table with a single field, and then placing it into a variab... Hi everyone, this is a demo version of our JDBC Connector for QlikView. It will enable a lot of non-ODBC/OLEDB sources for loading data into QlikView. Also, it would give much more performance on QV 9 ... Below is a script that was developed to quickly pull the fields from a list of tables into QVDs and perform incremental loads on the QVDs going forward. This particulate script was created to pull data from Sale... Hi Qlikers, Update: Added a date formatting parameter to verify if the QVDs are in a certain format to the QVW. Added the QVW lineageinfo directly by loading the Discriminator field from the [DocumentSummary... The strict exclusion feature often causes confusion and misunderstanding. The main purpose is to protect user access, due to incorrectly setup section access reduction. A good start to understanding the feature ... Hi All, The script below loads the data into qlikview file for multiple sheets in a single load by using the Loop statements. LET vStartSheetNumber = 1; LET vEndSheetNumber = 50; LET vExcelFileName ...