to follow, share, and participate in this community.
Hi All, Hope all are doing well . Few days back I have one requirement and do some R&D about that finally got the solution. So I want to share with you all. Hope this will helps you... Hi All, The below script helps you in loading the latest data from the given folder based on the filename. The below script helps you in loading the latest year automatically Example: File... Find the attachement to implement google maaps in qlikview. Documents with screenshots are avail. Attached the QVW file also for your reference. Regards. Siva Sankar k I've re-edited the document and fixed the&... 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... 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... The Qlikview Variables are quite cool and they can be used as little functions too. For example, the below variable declaration gives the flexibility to use any simple aggregation functions on any fields in the model ... Have you ever wonder how the examples from the Qlikview help may look like? Please see below and enjoy responsibly... Dual() Definition: Forced association of an arbitrary string representation s with a... Introduction In Business Intelligence and data science there has always been this debate about whether a star schema is better than a snowflake schema or vice versa. This post, is not about that argument. This ... The QlikView Management Console is a great tool for configuring your QlikView environment, but one thing it is not great at, ironically, is analysing your usage of licenses. In particular analysing your use allocation... You want to create a small qvw to explain a question? Or are you searching for sample data to do some testing? In attachment you can find all qvds from the following demo applications: Executive dashboard... Hi, I have prepared a script that will calculate the MTD, YTD, QTD, WTD without using complex set analysis using the As-Of table concept. Also from my script various types of calculations can be made like cur... Hi Recently I have seen some threads where people have been asking for Partial Sum's / Sub Totals in a straight table. Immediate first thought was Why Oh Why! we have a Pivot table to do just that! But there ... Hello, This example emphasize the extraordinary capabilities of representation of the "scatter analysis" which in my opinion is really great, especially when you analyze the single or both quadrant (see icon in the u... A common metric with a business is to compare current period with previous period a over same number of days. few fall into mistake of comparison of current period with the whole previous period. Take for... Attached the documentation , examples and learning material which i have collected over the years. It will help everyone in the community. Some of the files are from community itself. But re posting them so that every... Useful connectivity documentation from QlikView to Oracle Databases 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... Hi All, Hope the below script helps for those who are looking for a Fiscal Calendar for non standard dates. For example the month starts from 26 th of previous month to 25th of current month. Jan-2015: ... A really simple script I must_include at the beginning of all my scripts to load global variables, managed in a seperate place (an Excel file in the example below, could of course be just as well SQL. Any comm... Hi, Transforming below table into the desired output table in script using Generic load. Input data: ID Categories 1 Car 2 Car|Bike 3 Car|Bike|Boat 4 Car|Bike|Boat|Plane Desired Output: ID 1 2 ...