Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Using the right chart based on the requirement///

vinay_bangari
Valued Contributor III

Using the right chart based on the requirement///

Using the right charts:

When to use a bar chart

Comparisons for similar measurements

Actual vs. Budget   money to money, qty to qty

Amount over time   time to time

Top N   category values (e.g. sales reps)

Line Charts

Measurement to follow its movements

Comparisons among items

Performance Trends   Amount movements over time

Compare 2 dimensions   Annual Comparisons over months

Combo Chart

Comparisons for multi-measurements

Two measures   Currency amount and quantity

  Amount and percentage

Two axis   Left-axis and right axis for measurements

Two or more axis   Split axis horizontally

Radar Chart

Comparisons of high level groups

One or Two measurements   Sales and Profit

(Avoid a dimension with many values)

Gauge Charts

Ratio of measurements

Percentages   Margin, Quota Achieved, YTD vs. Last YTD

(Avoid actual amounts)

Scatter Chart

Measurements act as dimensions (3D chart)

3D measurement chart   Amounts, quantity and # of customers

Map chart   Sales on geographical map

Grid Chart

2 or 3 dimensions with a measurement

Multi-cross dim measures  Amount over region and product

over time

Pie Chart

Visual distribution measurements

What contributes how to the whole   Regional Sales

Yes / No analysis

Block Chart

One dimension with multiple measurements

KPI Overview  Cycle group dimension with Sales, Qty, Margin

Sort in any columns (No grouping)

Pivot Table

Multi-dimensions with one or more measurements

Grouping of dimensions  Product sales by item

Dimension across table  Annual sales by months

Variance calculation using before( )

No repetition of the same values (grouped)

No end-user sort by double-click

Labels (2)
Comments
qlikviewnovice
Valued Contributor II

Good One Vinay!!

If you provide with example it would be very effective

vinay_bangari
Valued Contributor III

i will try to update with example

ecolomer
Honored Contributor II

Great post

Thank's for sharing

Saludos,

Enrique Colomer

Version history
Revision #:
1 of 1
Last update:
‎08-13-2015 09:29 AM
Updated by: