Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

...

The latest QlikView for Jiwa BI Operations model is Jiwa7 BI Operations – with Budgets for Qlik_v12 2022_12_16.qvw  (See below for below for model and update history)

...

Scroll down to download the latest modelsQlikView#JiwaBIModelandupdatehistory .

Create a Sub-Folder called BI Templates and place a copy of the QlikView for Jiwa BI Operations model in here for safekeeping. 

...

You may experience an error like the following:

 OR 

Before applying a QlikView Desktop license through LEF file, make sure that you have a valid license key, control number and LEF file available. Also confirm with your QlikView license administrator that the license is indicates for a QlikView Desktop client, and not a QlikView server. 

The licensed client will connect to the license server annually to re-validate the valid license, unless a new license number has been applied.

How to manually apply a Qlik license with License Enabler File (LEF):

The LEF file contains elements as exemplified below. Confirm that your LEF file has the correct license number, correct product level and that date supports your product installation. The LEF file productlevel 3 indicates a QlikView Desktop client license, the values 1 or 2 might also be vaild for older licenses. The date must be the date of the major version or later in order to be able to upgrade to a new major release of the product. The LEF file also contains a checksum which validates the details of the LEF file. 

1324567891234567                -> License key number
PRODUCTLEVEL; 3;; 2013-01-01    -> Product level, Product value, Product date
BBX2-QWD3-34XS-VSF1-WSF12       -> CheckSum 

  1. You can request License Enabler (LEF) files for your licenses from this link: http://lef1.qliktech.com/manuallef/default.aspx.  

  2. Connection to license server is indicated

  3. Select "Enter my License Information manually (LEF)" to apply license through LEF file. Click Next.

    User-added imageImage Modified
  4. Copy and paste the LEF information into the text box. 

    User-added imageImage Modified
  5. Click Next to apply the license. NOTE: Invalid LEF details disables the Next option.

  6. Successful license validation is indicated  

    User-added imageImage Modified
  7. Click Continue to close the license dialog. 

  8. Click OK to close the User Preferences

  9. Close and reopen the QlikView Desktop Client for the license to apply.

Further support can be obtained from the Support Portal (login required) by following this article How to request a control number and LEF. If you are unable to login, click "Contact Support" on this page.


Automate ReLoad of the QlikView JiwaBI model

QlikView for Jiwa BI Model and update history

Operations Model

What's New

Published Date

Model Download

Fix the Budgets reports so that budget years are correctly mapped

DEV-9710

 

View file
nameJiwa7 BI Operations - with Budgets for Qlik_v12 2022_12_16.qvw

Minor bug fix in Top 10 report

7/06/2022


Minor bug fix in O/S Sales reports so Forward Orders are Ex GST (not Inc GST)

11/05/2022


Performance improvements on re-load

6/07/2021


Minor bug fix in PO Reports 1 & 2 for quantities reported on new partnos with backorders

13/1/2020


New Trend Analysis report '3 - Rolling Days' for daily sales, rolling 7 days forward

New Sales Analysis report '11 - Contact List' lists contacts and contact email addresses associated with a customer, ready for export to Excel / Mailchimp etc

10/6/2020


Added NOLOCK to the reload scripts to avoid collisions when retrieving data

3/3/2020


Inventory report '9 - Inventory Items where SOH Insufficient' refers to multiple forward POs when calculating date out of stock

20/9/2019


General Ledger Model

What's New

Published Date

Model Download

A new setting on the Admin tab limits the number of years in the drop-down reports "Minimum Fiscal Year".

(Our ref JIWA-9777)

2/8/2023

View file
nameJiwa BI General Ledger v10.2 for Jiwa 7 Aug 2023.qvw

Original model

2014