Hi

Sat, 21 Feb 2015 10:00:25 GMT

HI, Can anyone briefly explain about charts?

Re: Hi

andy_smith2005 — Sat, 21 Feb 2015 10:27:21 GMT

Graphs are graphical or textual representation of numbers - you need to be more specific with your question!

Re: Hi

MK_QSL — Sat, 21 Feb 2015 11:12:50 GMT

Check enclosed file... You can see almost all basic charts being created in QlikView.

Re: Hi

Anonymous — Sat, 21 Feb 2015 11:16:38 GMT

Wikipedia has an entry Charts.

Re: Hi

engishfaque — Sat, 21 Feb 2015 16:48:08 GMT

Dear Ramana,

Kindly find attached document.

Kind regards,

Ishfaque Ahmed

Re: Hi

Anonymous — Sat, 21 Feb 2015 18:06:18 GMT

Hi Ramana,

Qlikview has below 13 chart types:

1. Bar Chart:

Comparison of similar measurements

This is the most basic chart type. Each x-axis value corresponds to a bar. The bar height corresponds to its numerical y-axis value.

Ex. a) Actual vs. budget- money to money. Quarter to Quarter

b) Time to Time

c) Top N- categorized values (sales reps, customers etc) avoid: comparisons with

different units ($ and Qty)

2. Line chart:

The line chart is essentially defined in the same way as the bar chart. Instead of using bars the data can be presented as lines between value points, as value points only or as both lines and value points.

Measurements to follow its moments or comparisons among items

Ex. a) Performance trends- amount of moment over time

b) Two Dimension comparisons- Annual comparisons over month

3. Combo Charts:

The combo chart allows the combination of the features of the bar chart with those of the line chart. One expression will be displayed by lines and/or symbols, the other as bars.

Comparisons for multi measurements

Ex. Two measurements- currency amount and quantity or amount percentage two axis- different measurements on left and right axis two or more axis: split axis horizontally

4. Radar chart:

Radar chart – The radar chart is a variant of the line chart where the x-axis is plotted in a circle around the chart, resulting in a projection reminiscent of a radar screen or a spider’s web.

Comparisons of high level groups one or two measurements- sales and profit avoid- a dimension with many values

5. Gauge chart:

Gauge charts are used to display the value of a single expression, lacking dimensions.

Ratio of measurements

Ex. a)Percentages- margin, quota achieved, year-tot

b) Date vs last YTD. Avoid: actual amounts

6. Mekko chart:

Mekko charts present data using variable width bars. They can display up to three levels of data in a two-dimensional chart. Mekko charts are useful in such areas as market analysis.

Data using variable width bars

Ex. a) 3D measurement chart- Amount, Quantity and no. of customers

b) Market analysis.

7. Scatter Chart:

The scatter chart plots data points representing combinations of expressions, iterated over one or several dimensions. Both axes are continuous, representing one expression each.

Measurement acts as dimensions (3D Chart)

Ex. a) 3D measurement chart- Amount, Quantity and no. of customers

b) Map chart- see sales on Geographical map

8. Grid Chart:

The grid chart is a variant of the scatter chart that plots dimension values on the axes and uses an expression to determine the plot symbol. It can also show a third dimension in the form of small pie charts as plot symbols.

2 or 3 Dimensions with a measurement

Ex. a) Multi-cross dimensional measurements

b) amounts over- region and product and over time

9. Pie Chart:

Shows the relation between a single (primary dimension) and a single expression. A variant chart type is drawn when a secondary dimension is introduced. If more expressions than one are enabled in the Chart properties: Expressions page, the first in the expression list will be displayed. To switch expression use the Promote/Demote buttons in the Expressions property page.

Visual Distribution measurements

Ex. a) what contributes how to the whole- regional sales

b) yes/no analysis

10. Funnel chart:

The funnel chart is typically used for showing data in flows and processes. From a display standpoint it is related to the pie chart. The chart may be shown with either segment height/width or segment area proportional to data. It is also possible to draw the chart with equal segment heights/widths without regards to data points.

Dimension that contain an expiration time line

Ex. a) How much is the most aging element

b) Sales opportunities

c) Product Inventory Expressions

11. Block chart:

The block chart shows the relation between expression values as blocks of varying area. It uses a single expression and up to three dimensions, with each dimension block further divided into sub-blocks. The total area of the block chart always equals 100% of the possible expression values.

Distribution measurements within multi dimensions

Ex. a) what contributes how to whole and within each segments

b) Sales contribution per country

"Treemap" is the most common name in English for this chart type. The reason it is called this way is that it originally was used to show hierarchies; tree structures.

When this chart was introduced for Qlikview version 7, Qlik considered calling it "Treemap", but chose to call it "Block chart" instead. Partly because "Treemap" is poor name (from a descriptive point), partly because the chart often is used for structures that are not tree-like.

Qlik have chosen to call it "Treemap" for Qlik Sense, since this is the accepted name in English, and Qlik wanted to be conform with the standard terminology.

12. Straight Table:

The straight table differs from the pivot table in that it cannot display subtotals and that the grouping of dimensions is shown in record form so that each row of the table contains field and expression values.

One dimension with multiple measurements

Ex. a) KPI overview- cyclic group dimensions with sales Qty , margin

b) Sort in any no. of columns (no grouping)

13. Pivot table:

The pivot table presents dimensions and expressions in table form. There is no formal limit to the number of dimensions or expressions possible. A pivot table can be defined without expressions, generating a tree view for navigating the dimension levels.

Multi dimensions with one or more measurements

Ex. a) Grouping of dimensions

b) Dimensions across the table and displaying sub totals

Chart’s limitations:

There are two limitations:

First limitation is number of Dimensions and

Second limitation is the memory aspect.

The First limitation - number of dimensions depends on which chart.

For example: A bar chart can have 3 Dimensions and 1 Expression (or 2 Dim and several Expression).

A pie chart can have 2 Dimensions and 1 expression.

A grid chart can have2 or 3 Dimensions with a measurement

A pivot table can have any number of dimensions and any number of expressions.

The memory aspect is worse. A chart is a cube, which means that the memory usage increases with conjunction with the number of dimensions used.

Number of dimensions used depends on how many distinct values they have. Performance wise try to use 4 or less dimensions.

Ref here:

http://community.qlik.com/docs/DOC-7652 For chart types.

Regards

Neetha

topic Re: Hi in QlikView

Hi

Re: Hi

Re: Hi

Re: Hi

Re: Hi

Re: Hi

1. Bar Chart:

2. Line chart:

3. Combo Charts:

4. Radar chart:

5. Gauge chart:

6. Mekko chart:

7. Scatter Chart:

8. Grid Chart:

9. Pie Chart:

10. Funnel chart:

11. Block chart:

12. Straight Table:

13. Pivot table: