Qlikview Developer

Learn to manage QlikView sheets by adding, copying, and deleting, then configure sheet properties via the layout and design toolbar. Master options for general, background, filters, objects, security, and triggers.

Explore how list boxes filter dashboards, including horizontal and vertical layouts, create list boxes from fields with titles, and apply properties like read-only and hide excluded to drive updates.

Explore how to enhance QlikView listbox usability by enabling advanced and fuzzy search, caption alignment, exporting values to Excel, minimizing the listbox, and using expressions to display country-specific values.

Create and customize a statistics box in QlikView by selecting a field like budget amount, choosing display functions (total, average, min, max, missing), and adjusting formatting, caption, and visibility.

Learn how to use the multi-box graphical element in QlikView to consolidate list boxes, save dashboard space, and apply filters while fine-tuning properties like order, applicability, grid view, and visibility.

Create a simple QlikView table box, select fields such as customer, customer type, and address, and use properties like calculation condition and load order to tailor the display.

Explore how input boxes in Qlikview use variables to control charts and filters, showing only the first three months or hiding and revealing objects based on user input.

Create and manage the current selection box in Qlikview to track and adjust your document selections using drop-downs, erase options, and column labels.

Create and configure a Qlikview button object to clear selections, open external links, and launch applications, while using enable conditions and conditional visibility.

Learn to create and customize a line and arrow object in QlikView, including orientation, style, color, transparency, and actions, and use it as a divider between dashboard charts.

Discover how the slider object captures input for dashboards, enabling what-if analysis with variables, discrete or continuous ranges, and configurable properties, while introducing the calendar object in the same series.

Learn to create and configure a search object in Qlikview, perform wildcard and fuzzy searches, manage selections and current selections, and drive dashboards with flexible, field-specific searches.

Copy QlikView charts to PowerPoint or Excel using copy to clipboard options, such as image or object, to present dashboard data in slides and keep interactivity.

Learn to transform cross tabular data into a flat table using cross table transformation, mapping country name, country code, year, and population for effective import in qlikview.

Discover creating a bar chart in QlikView with the chart wizard, using country dimensions and population sums, and apply dynamic titles, orientation, and formatting options.

Explore creating and customizing a line chart in QlikView to visualize population trends over time, using dimensions and expressions, formatting, symbols, and trend lines like average and R-squared.

Create a QlikView combo chart combining a bar for expenses and a line for savings, with country name on the x-axis and axis adjustments for clarity.

Discover how to use a radar chart to visualize cyclic data, like monthly sales, identify spikes and trends, and format for clear interpretation.

Create and interpret block charts in QlikView to perform comparative analysis across years and regions using sales percentages. Learn formatting, labeling, and orientation to prepare block charts for production reporting.

Learn to create a pie chart in QlikView using region as dimension, sum sales with an expression, convert values to percentages, and explore donut and 3D options with data-point labels.

Learn to create a step line chart in QlikView and compare it with a traditional line chart to reveal exact movement between stock prices from 2000 to 2013.

Learn to build a scatter and bubble chart in QlikView that maps total companies and export amounts by country, with bubble size driven by government spending.

Explore how to build and customize funnel charts in QlikView to visualize sales pipelines, gender and age group data, with sorting, orientation, and drill-down capabilities.

Create mini charts in QlikView to transform numbers into visual trends, using charts like bar, gauge, and traffic light to reveal sales by reps and incentives.

Visualize performance metrics with a gauge chart that compares achievement against target, using red, yellow, green segments, and customize labels, colors, and segments in QlikView.

Learn how a straight table in QlikView uses a dimension and expressions (sums) to display export, government spend on companies, and total companies, with sorting, totals, and column visibility options.

Explore creating pivot tables in QlikView, using cross-table structures with sales rep, year, and quarter, and learn to sum sales, customize formatting, and control expansion and subtotals.

See how the waterfall chart reveals the cumulative effect of sequential positive and negative values, from revenue to net income, using offset bars in QlikView.

Construct a candlestick chart in QlikView using stock open, high, low, and close data, and configure the box plot and candlestick visualizations with color rules and whiskers.

Create a trellis bar chart in QlikView by repeating bars across sales reps and years, using a sum of sales expression, and format values with currency symbols.

Group expressions to reuse a single chart for multiple expressions, switch between them with the group option to create dynamic dashboards for business users.

Learn how to create cyclical groups of dimensions in a Qlikview chart, add year and quarter dimensions, and switch expressions on the fly to build a flexible analytical view.

Explore how to use the drill down option in qlikview to reveal age-group categorizations within gender data across multiple drill-down levels.

Learn the basics of QlikView scripting to restrict data for dashboards, create data subsets, and perform data massaging, including concatenating names, filtering by conditions, and extracting fields.

Explore how to use the if statement in qlikview scripting to rename the city Las Vegas to LV and create hard coded columns for medical, industrial, and sports customers.

Learn how to define and use variables in QlikView, comparing set and let, applying dollar-sign expansion, and using script or settings to drive dynamic metrics.

Explore advanced variable operations in QlikView, including declaring variables, using them in currency calculations, understanding runtime versus pre-evaluation with equals signs, and applying formatting in the front end.

Discover how to use partial reload in QlikView scripting to add new data to an existing dataset or replace it with a new set, conserving system resources.

Use resident load in QlikView to perform aggregation on an already loaded table without altering the base data. Create a resident table with group by to compute expense-to-sales ratios.

Learn how to use the inline load feature in QlikView to decode country codes into country names, create an inline table, and join tables automatically when column names match.

Learn how to concatenate two tables in QlikView to merge datasets, include new columns like email addresses, and apply data modeling principles for building a single, updated customer list.

Explore how to combine data with inner, outer, left, and right joins in qlikview, compare join and concatenate, and apply join syntax to merge datasets based on common fields.

Learn how the aggr function aggregates order totals by customer name and employee, using max and firstsortedvalue to identify the maximum order and the corresponding customer.

Explore how the aggr function works in QlikView to create calculated dimensions that return order count and total order value by employee, enabling value selling analysis on charts.

Learn to create bucketed order value ranges in QlikView using the class function and calculated dimensions, then refine with dual sorting, replace formatting, and suppress nulls.

Learn how the keep function in qlikview scripting applies left or right join properties to two tables while keeping them separate, avoiding a single merged table and enabling selective records.

Learn to conditionally enable and disable dimensions in a QlikView pivot table, creating a country–city hierarchy that updates dynamically as you select a country.

Master the set reference feature in charts to perform quick comparative analysis by marking a reference and comparing country sales (India, UK, US) against the overall trend.

Learn the basics of set analysis in QlikView, writing set expressions to filter metrics by status and customer name. Apply thresholds, such as shipping fees, and suppress zero values.

Explore set analysis in QlikView using p() and e() to manage possible and excluded value lists, enabling dynamic time-based comparisons with max(month) logic.

Learn to use the alternate states feature to perform comparative analysis across charts, enabling two-state comparisons and bar charts for month-by-month performance.

Explore quick view triggers across sheet, document, field, and variable levels, and how on open, on select, on change, and on leave events fire actions like bookmark or external actions.

Explore triggers in QlikView, including select in field triggers at sheet and document levels; learn to configure actions, search strings, and wildcards to preselect values like country, India, and UK.

Explore how to use triggers in Qlikview to lock and clear fields, assign on activate or deactivate events, and apply variables for dynamic behavior in selection and analysis.

Learn how to configure bookmark triggers in qlikview by creating and replacing bookmarks, assigning meaningful names, and enabling predefined selections for end users.