Kategorie
Ebooki
-
Biznes i ekonomia
- Bitcoin
- Bizneswoman
- Coaching
- Controlling
- E-biznes
- Ekonomia
- Finanse
- Giełda i inwestycje
- Kompetencje osobiste
- Komputer w biurze
- Komunikacja i negocjacje
- Mała firma
- Marketing
- Motywacja
- Multimedialne szkolenia
- Nieruchomości
- Perswazja i NLP
- Podatki
- Polityka społeczna
- Poradniki
- Prezentacje
- Przywództwo
- Public Relation
- Raporty, analizy
- Sekret
- Social Media
- Sprzedaż
- Start-up
- Twoja kariera
- Zarządzanie
- Zarządzanie projektami
- Zasoby ludzkie (HR)
-
Dla dzieci
-
Dla młodzieży
-
Edukacja
-
Encyklopedie, słowniki
-
E-prasa
- Architektura i wnętrza
- Biznes i Ekonomia
- Dom i ogród
- E-Biznes
- Finanse
- Finanse osobiste
- Firma
- Fotografia
- Informatyka
- Kadry i płace
- Komputery, Excel
- Księgowość
- Kultura i literatura
- Naukowe i akademickie
- Ochrona środowiska
- Opiniotwórcze
- Oświata
- Podatki
- Podróże
- Psychologia
- Religia
- Rolnictwo
- Rynek książki i prasy
- Transport i Spedycja
- Zdrowie i uroda
-
Historia
-
Informatyka
- Aplikacje biurowe
- Bazy danych
- Bioinformatyka
- Biznes IT
- CAD/CAM
- Digital Lifestyle
- DTP
- Elektronika
- Fotografia cyfrowa
- Grafika komputerowa
- Gry
- Hacking
- Hardware
- IT w ekonomii
- Pakiety naukowe
- Podręczniki szkolne
- Podstawy komputera
- Programowanie
- Programowanie mobilne
- Serwery internetowe
- Sieci komputerowe
- Start-up
- Systemy operacyjne
- Sztuczna inteligencja
- Technologia dla dzieci
- Webmasterstwo
-
Inne
-
Języki obce
-
Kultura i sztuka
-
Lektury szkolne
-
Literatura
- Antologie
- Ballada
- Biografie i autobiografie
- Dla dorosłych
- Dramat
- Dzienniki, pamiętniki, listy
- Epos, epopeja
- Esej
- Fantastyka i science-fiction
- Felietony
- Fikcja
- Humor, satyra
- Inne
- Klasyczna
- Kryminał
- Literatura faktu
- Literatura piękna
- Mity i legendy
- Nobliści
- Nowele
- Obyczajowa
- Okultyzm i magia
- Opowiadania
- Pamiętniki
- Podróże
- Poemat
- Poezja
- Polityka
- Popularnonaukowa
- Powieść
- Powieść historyczna
- Proza
- Przygodowa
- Publicystyka
- Reportaż
- Romans i literatura obyczajowa
- Sensacja
- Thriller, Horror
- Wywiady i wspomnienia
-
Nauki przyrodnicze
-
Nauki społeczne
-
Podręczniki szkolne
-
Popularnonaukowe i akademickie
- Archeologia
- Bibliotekoznawstwo
- Filmoznawstwo
- Filologia
- Filologia polska
- Filozofia
- Finanse i bankowość
- Geografia
- Gospodarka
- Handel. Gospodarka światowa
- Historia i archeologia
- Historia sztuki i architektury
- Kulturoznawstwo
- Lingwistyka
- Literaturoznawstwo
- Logistyka
- Matematyka
- Medycyna
- Nauki humanistyczne
- Pedagogika
- Pomoce naukowe
- Popularnonaukowa
- Pozostałe
- Psychologia
- Socjologia
- Teatrologia
- Teologia
- Teorie i nauki ekonomiczne
- Transport i spedycja
- Wychowanie fizyczne
- Zarządzanie i marketing
-
Poradniki
-
Poradniki do gier
-
Poradniki zawodowe i specjalistyczne
-
Prawo
- BHP
- Historia
- Kodeks drogowy. Prawo jazdy
- Nauki prawne
- Ochrona zdrowia
- Ogólne, kompendium wiedzy
- Podręczniki akademickie
- Pozostałe
- Prawo budowlane i lokalowe
- Prawo cywilne
- Prawo finansowe
- Prawo gospodarcze
- Prawo gospodarcze i handlowe
- Prawo karne
- Prawo karne. Przestępstwa karne. Kryminologia
- Prawo międzynarodowe
- Prawo międzynarodowe i zagraniczne
- Prawo ochrony zdrowia
- Prawo oświatowe
- Prawo podatkowe
- Prawo pracy i ubezpieczeń społecznych
- Prawo publiczne, konstytucyjne i administracyjne
- Prawo rodzinne i opiekuńcze
- Prawo rolne
- Prawo socjalne, prawo pracy
- Prawo Unii Europejskiej
- Przemysł
- Rolne i ochrona środowiska
- Słowniki i encyklopedie
- Zamówienia publiczne
- Zarządzanie
-
Przewodniki i podróże
- Afryka
- Albumy
- Ameryka Południowa
- Ameryka Środkowa i Północna
- Australia, Nowa Zelandia, Oceania
- Austria
- Azja
- Bałkany
- Bliski Wschód
- Bułgaria
- Chiny
- Chorwacja
- Czechy
- Dania
- Egipt
- Estonia
- Europa
- Francja
- Góry
- Grecja
- Hiszpania
- Holandia
- Islandia
- Litwa
- Łotwa
- Mapy, Plany miast, Atlasy
- Miniprzewodniki
- Niemcy
- Norwegia
- Podróże aktywne
- Polska
- Portugalia
- Pozostałe
- Rosja
- Rumunia
- Słowacja
- Słowenia
- Szwajcaria
- Szwecja
- Świat
- Turcja
- Ukraina
- Węgry
- Wielka Brytania
- Włochy
-
Psychologia
- Filozofie życiowe
- Kompetencje psychospołeczne
- Komunikacja międzyludzka
- Mindfulness
- Ogólne
- Perswazja i NLP
- Psychologia akademicka
- Psychologia duszy i umysłu
- Psychologia pracy
- Relacje i związki
- Rodzicielstwo i psychologia dziecka
- Rozwiązywanie problemów
- Rozwój intelektualny
- Sekret
- Seksualność
- Uwodzenie
- Wygląd i wizerunek
- Życiowe filozofie
-
Religia
-
Sport, fitness, diety
-
Technika i mechanika
Audiobooki
-
Biznes i ekonomia
- Bitcoin
- Bizneswoman
- Coaching
- Controlling
- E-biznes
- Ekonomia
- Finanse
- Giełda i inwestycje
- Kompetencje osobiste
- Komunikacja i negocjacje
- Mała firma
- Marketing
- Motywacja
- Nieruchomości
- Perswazja i NLP
- Podatki
- Poradniki
- Prezentacje
- Przywództwo
- Public Relation
- Sekret
- Social Media
- Sprzedaż
- Start-up
- Twoja kariera
- Zarządzanie
- Zarządzanie projektami
- Zasoby ludzkie (HR)
-
Dla dzieci
-
Dla młodzieży
-
Edukacja
-
Encyklopedie, słowniki
-
Historia
-
Informatyka
-
Inne
-
Języki obce
-
Kultura i sztuka
-
Lektury szkolne
-
Literatura
- Antologie
- Ballada
- Biografie i autobiografie
- Dla dorosłych
- Dramat
- Dzienniki, pamiętniki, listy
- Epos, epopeja
- Esej
- Fantastyka i science-fiction
- Felietony
- Fikcja
- Humor, satyra
- Inne
- Klasyczna
- Kryminał
- Literatura faktu
- Literatura piękna
- Mity i legendy
- Nobliści
- Nowele
- Obyczajowa
- Okultyzm i magia
- Opowiadania
- Pamiętniki
- Podróże
- Poezja
- Polityka
- Popularnonaukowa
- Powieść
- Powieść historyczna
- Proza
- Przygodowa
- Publicystyka
- Reportaż
- Romans i literatura obyczajowa
- Sensacja
- Thriller, Horror
- Wywiady i wspomnienia
-
Nauki przyrodnicze
-
Nauki społeczne
-
Popularnonaukowe i akademickie
-
Poradniki
-
Poradniki zawodowe i specjalistyczne
-
Prawo
-
Przewodniki i podróże
-
Psychologia
- Filozofie życiowe
- Komunikacja międzyludzka
- Mindfulness
- Ogólne
- Perswazja i NLP
- Psychologia akademicka
- Psychologia duszy i umysłu
- Psychologia pracy
- Relacje i związki
- Rodzicielstwo i psychologia dziecka
- Rozwiązywanie problemów
- Rozwój intelektualny
- Sekret
- Seksualność
- Uwodzenie
- Wygląd i wizerunek
- Życiowe filozofie
-
Religia
-
Sport, fitness, diety
-
Technika i mechanika
Kursy video
-
Bazy danych
-
Big Data
-
Biznes, ekonomia i marketing
-
Cyberbezpieczeństwo
-
Data Science
-
DevOps
-
Dla dzieci
-
Elektronika
-
Grafika/Wideo/CAX
-
Gry
-
Microsoft Office
-
Narzędzia programistyczne
-
Programowanie
-
Rozwój osobisty
-
Sieci komputerowe
-
Systemy operacyjne
-
Testowanie oprogramowania
-
Urządzenia mobilne
-
UX/UI
-
Web development
-
Zarządzanie
Podcasty
- Ebooki
- Big data
- Analiza danych
- QlikView for Developers Cookbook. Take your QlikView training to the next level with this brilliant book that's packed with recipes which progress from intermediate to advanced. The step-by step-approach makes learning easy and enjoyable
Szczegóły ebooka
Zaloguj się, jeśli jesteś zainteresowany treścią pozycji.
QlikView for Developers Cookbook. Take your QlikView training to the next level with this brilliant book that's packed with recipes which progress from intermediate to advanced. The step-by step-approach makes learning easy and enjoyable
Ebook
QlikView 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.
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.
- QlikView for Developers Cookbook
- Table of Contents
- QlikView for Developers Cookbook
- Credits
- Foreword
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers and more
- Why Subscribe?
- Free Access for Packt account holders
- Instant Updates on New Packt Books
- Support files, eBooks, discount offers and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Errata
- Piracy
- Questions
- 1. Charts
- Introduction
- Creating custom pop-up labels on a bar chart
- Getting ready
- How to do it
- How it works
- Theres more
- Creating a box plot chart for a simple data set
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Using the wizard to create a box plot chart
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating a "Stephen Few" bullet chart
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating a modified bullet chart in a straight table
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating a bar chart in a straight table
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating a Redmond Aged Debt Profile chart
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating a waterfall chart
- Getting ready
- How to do it
- How it works
- There's more
- Replacing the legend in a line chart with labels on each line
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating a secondary dimension in a bar chart
- Getting ready
- How to do it
- How it works
- There's more
- Creating a line chart with variable width lines
- Getting ready
- How to do it
- How it works
- There's more
- Brushing parallel coordinates
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Using redundant encoding with a scatter chart
- Getting ready
- How to do it
- How it works
- There's more
- Staggering labels in a pie chart
- Getting ready
- How to do it
- How it works
- There's more
- Creating dynamic ad hoc analysis in QlikView
- Getting ready
- How to do it
- How it works
- There's more
- 2. Layout
- Introduction
- Changing the default object layout options
- Getting ready
- How to do it
- How it works
- See also
- Changing the default selection color scheme
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Modifying the green, white, and gray selection color schemes
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Modifying the green, white, and gray selection color schemes in QlikView Server
- Getting ready
- How to do it
- How it works
- See also
- Using containers as an alternative to multiboxes
- Getting ready
- How to do it
- How it works
- Using the design menus to custom format a cell
- Getting ready
- How to do it
- How it works
- There's more
- 3. Set Analysis
- Introduction
- Using dollar expansion in Set Analysis to enable from-date and to-date selection
- Getting ready
- How to do it...
- How it works...
- Using alternate states with Set Analysis
- Getting ready
- How to do it...
- How it works...
- There's more...
- See Also
- Using Set operators to exclude values from results
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using Set Analysis with a Date Island
- Getting ready
- How to do it...
- How it works...
- There's more...
- See Also
- Using Sets to avoid key tables
- Getting ready
- How to do it...
- How it works...
- There's more...
- 4. Advanced Aggregations
- Introduction
- Using TOTAL to calculate the percentage of total and subtotal
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using AGGR to calculate the percentage of the maximum value
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using AGGR to resolve a "Sum of Rows" issue
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Creating a dynamic AGGR expression for a Group dimension using Dollar Expansion
- Getting ready
- How to do it...
- How it works...
- See also
- Using RangeMax to return only positive numbers
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Creating a dynamic Part-to-Whole pie chart
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Creating a colored treemap using colormix
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using RangeSum to calculate a rolling total in a multidimension table
- Getting ready
- How to do it...
- How it works...
- There's more...
- Showing only the top 3 values in a pivot table
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating a Statistical Control Chart using Standard Deviation
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Creating a Moving Range chart
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Creating a control chart using Moving Range
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 5. Advanced Coding
- Introduction
- Extracting QlikView data to a Word report
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Printing reports to PDF using PDFCreator
- Getting ready
- How to do it
- How it works
- See also
- Creating a chart using a macro
- Getting ready
- How to do it
- How it works
- There's more
- Using VBS functions in charts
- Getting ready
- How to do it
- How it works
- There's more
- 6. Data Modeling
- Introduction
- Concatenation of fact tables to avoid loops and synthetic keys
- Getting ready
- How to do it
- How it works...
- There's more...
- See also
- Creating a Key/Link table in QlikView
- Getting ready
- How to do it
- How it works...
- There's more...
- See also
- 7. Extensions
- Introduction
- Creating a simple HTML extension
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating a simple HTML table
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating an interactive extension
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Using external libraries with extensions
- Getting ready
- How to do it
- How it works
- There's more
- See also
- 8. Useful Functions
- Introduction
- Handling null in numeric fields or calculations
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Using Dual to handle period name sorting
- How to do it
- How it works
- There's more
- See also
- Parsing text to numbers and dates
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Calculating Year To Date dynamically
- Getting ready
- How to do it
- How it works
- There's more
- Labeling a pie chart to replace the legend
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Calculating the lowest or highest value in a range
- Getting ready
- How to do it
- How it works
- There's more
- Consolidating a date-time value into quarter hourly segments
- Getting ready
- How to do it
- How it works
- There's more
- Dynamically filtering by From/To dates
- Getting ready
- How to do it
- How it works
- There's more
- 9. Script
- Introduction
- Creating flags in the script
- Getting ready
- How to do it...
- How it works...
- There's more...
- Replacing IsNull
- Getting ready
- How to do it...
- How it works...
- There's more...
- Storing and dropping using a subroutine
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Keeping a trace on things
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using the AND mode in listboxes
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using Exists and Keep to limit the data load
- Getting ready
- How to do it...
- How it works...
- There's more...
- Setting the default display format
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Setting the default sort order
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Matching financial periods to dates
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Handling partial reload in the script
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using Peek and Previous to calculate against loaded records
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating a simple Gantt for a dashboard using Interval Match
- Getting ready
- How to do it...
- How it works...
- See also
- Reading users from Active Directory
- Getting ready
- How to do it...
- How it works...
- Getting a sub-URL using the Table wizard
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using parameters in Dollar Sign Expansion
- Getting ready
- How to do it...
- How it works...
- Removing fields with a wildcard
- Getting ready
- How to do it...
- How it works...
- There's more...
- Handling multiple subfolders in a script
- Getting ready
- How to do it...
- How it works...
- 10. Improving Performance
- Introduction
- Reducing the number of distinct values
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating counter fields to avoid Count Distinct
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Creating flag fields to avoid Sum of If and other inefficient expressions
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Denormalizing for performance
- Getting ready
- How to do it
- How it works
- There's more
- See also
- 11. Security
- Introduction
- Section Access gotchas
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Blocking user access to a field using OMIT
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Making all values available to Admins and Managers
- Getting ready
- How to do it
- How it works
- There's more
- See also
- Index
- Tytuł: QlikView for Developers Cookbook. Take your QlikView training to the next level with this brilliant book that's packed with recipes which progress from intermediate to advanced. The step-by step-approach makes learning easy and enjoyable
- Autor: Stephen Redmond
- Tytuł oryginału: QlikView for Developers Cookbook. Take your QlikView training to the next level with this brilliant book that's packed with recipes which progress from intermediate to advanced. The step-by step-approach makes learning easy and enjoyable.
- ISBN: 9781782179740, 9781782179740
- Data wydania: 2013-06-24
- Format: Ebook
- Identyfikator pozycji: e_3czx
- Wydawca: Packt Publishing