ERROR

Мы сожалеем - хотя мы сделали все возможное: произошла ошибка
Typedatabase
MessageYou have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near "AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categorie..." at line 5
QuerySELECT (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = 000) AS cat1, (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2, (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3, (SELECT categories_id FROM categories_description WHERE language_id = 8 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = 000) AS cat1name, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2name, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3name, (SELECT categories_name FROM categories_description WHERE language_id = 8 AND categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4name, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 000) AS cat1url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3url, (SELECT url_text FROM commerce_seo_url_without_language WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4url, (SELECT wod_count_products FROM categories WHERE categories_id = 000) AS cat1cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 00 AND SUBSTRING(categories_id,2,1) != "0") AS cat2cnt, (SELECT wod_count_products FROM categories WHERE categories_id = 0 AND SUBSTRING(categories_id,3,1) != "0") AS cat3cnt, (SELECT wod_count_products FROM categories WHERE categories_id = AND SUBSTRING(categories_id,4,1) != "0") AS cat4cnt

Karl Pover 
Mastering QlikView Data Visualization [EPUB ebook] 

समर्थन

Take your Qlik View skills to the next level and master the art of creating visual data analysis for real business needs

About This Book

  • Explore how to create your own Qlik View data laboratory and how to develop Qlik View applications using agile project methods

  • Implement advanced data visualization and analysis for common business requirements from the sales, finance, marketing, inventory, operations, and human resources departments

  • Learn from real-life experience shared in this book that will give you the upper hand in your next Qlik View project


Who This Book Is For

This book is intended for developers who want to go beyond their technical knowledge of Qlik View and understand how to create analysis and data visualizations that solve real business needs. You should have a basic understanding of advanced Qlik View functions.

What You Will Learn

  • Apply advanced Qlik View techniques such as set analysis and nested aggregation in order to deliver common business requirements

  • Understand real business requirements for sales, finance, marketing, and human resources departments

  • Discover when to apply more advanced data visualization such as frequency polygons, bullet graphs, and Xm R charts

  • Go beyond native Qlik View and include geographical analysis, planning, and sentiment analysis in your Qlik View application

  • Troubleshoot common errors we discover at the moment we visualize data in Qlik View

  • Develop a plan to master Qlik Sense data visualization


In Detail

Just because you know how to swing a hammer doesn’t mean you know how to build a house. Now that you’ve learned how to use Qlik View, it’s time to learn how to develop meaningful Qlik View applications that deliver what your business users need.

You will explore the requirements and the data from several business departments in order to deliver the most amazing analysis and data visualizations. In doing so, you will practice using advanced Qlik View functions, chart object property options, and extensions to solve real-world challenges.

Style and approach

This hands-on guide follows the story of a company implementing Qlik View as its enterprise data discovery solution. Each chapter starts with an understanding of the business requirements and the data model, and then helps you create insightful analysis and data visualizations. Each chapter expands on what was done in the previous chapter as we follow this continuously improving iterative process.

€43.19
भुगतान की विधि
यह ईबुक खरीदें और 1 और मुफ़्त पाएं!
भाषा अंग्रेज़ी ● स्वरूप EPUB ● पेज 294 ● ISBN 9781782173267 ● फाइल का आकार 12.8 MB ● प्रकाशक Packt Publishing ● शहर San Antonio ● देश US ● प्रकाशित 2016 ● डाउनलोड करने योग्य 24 महीने ● मुद्रा EUR ● आईडी 4891754 ● कॉपी सुरक्षा Adobe DRM
एक DRM सक्षम ईबुक रीडर की आवश्यकता है

एक ही लेखक से अधिक ईबुक / संपादक

75,634 इस श्रेणी में ईबुक