Books
Stephen Redmond

QlikView for Developers Cookbook

In DetailQlikView has been around since 1993, but has only really taken off in recent years as a leader in the in-memory BI space and, more recently, in the data discovery area. QlikView features the ability to consolidate relevant data from multiple sources into a single application, as well as an associative data model to allow you to explore the data to a way your brain works, state-of-the-art visualizations, dashboard, analysis and reports, and mobile data access.
QlikView for Developers Cookbook builds on your initial training and experiences with QlikView to help you become a better developer. This book features plenty of hands-on examples of many challenging functions.
Assuming a basic understanding of QlikView development, this book provides a range of step-by-step exercises to teach you different subjects to help build your QlikView developer expertise.
From advanced charting and layout to set analysis; from advanced aggregations through to scripting, performance, and security, this book will cover all the areas that you need to know about.
The recipes in this book will give you a lot of the information that you need to become an excellent QlikView developer.
ApproachThe recipes in this Cookbook provide a concise yet practical guide on how to become an excellent QlikView developer. The book begins with intermediate level recipes and then moves on to more complex recipes in an incremental manner.
Who this book is forThis book is for anyone who has either attended QlikView Developer training or has taught themselves QlikView from books or online sources. You might be working for a QlikView customer, partner, or even QlikView themselves (or want to!) and want to improve your QlikView skills.
345 printed pages
Publication year
2013
Have you already read it? How did you like it?
👍👎

Quotes

  • Eddie Wagthas quoted7 years ago
    Let i = 1;
    Do While i <= NoOfFields('MyTable')
    Trace Getting Field $(i) From MyTable;

    Let FieldName = FieldName($(i), 'MyTable');

    Trace FieldName = $(FieldName);

    If '$(FieldName)' Like 'F*' Then
    Let Command = 'Drop Field [$(FieldName)];';
    $(Command)
    Trace Command = $(Command);
    Else
    Let Command = '';
    Let i=i+1;
    End If

    Loop
  • Eddie Wagthas quoted7 years ago
    How to do it...
    Follow these steps to create a subroutine to store QVD then drop a table:
    Before the load statement for Table1, add the following script:
    Sub StoreAndDrop(vTableName)
    Store [$(vTableName)] into [$(vTableName).qvd];
    Drop Table [$(vTableName)];
    End Sub
    After the Table1 load and before the Table2 load, add the following line of script:
    Call StoreAndDrop('Table1');
    After the Table2 load, add the following line of script:
    Call StoreAndDrop('Table2');
    Reload the script. There should be no data in the document and two QVD files should have been created in the same folder as the QVW file.

On the bookshelves

  • Galina Ershova
    QLIK
    • 15
    • 2
  • Eddie Wagt
    Qlikview
    • 13
    • 1
  • Christina Braüner Christensen
    Rasmus
    • 15
  • Татьяна Барышева
    QlikView
    • 7
  • epudovkina31498
    Qlikview
    • 3
fb2epub
Drag & drop your files (not more than 5 at once)