topic Where and when to use which type of charts in QlikView

Where and when to use which type of charts

Anonymous — Wed, 24 Dec 2014 10:12:54 GMT

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

Re: Where and when to use which type of charts

Wed, 24 Dec 2014 10:15:11 GMT

s ur right

Re: Where and when to use which type of charts

francoiscave — Wed, 24 Dec 2014 10:19:22 GMT

Hi,

Good work, see the document below :

Chart suggestion - Good Chart for Good design.pdf

François

Re: Where and when to use which type of charts

krishnacbe — Wed, 24 Dec 2014 10:26:55 GMT

Good Post

Re: Where and when to use which type of charts

amit_saini — Wed, 24 Dec 2014 10:32:49 GMT

Hi,

Also check this attachment.

Thanks,
AS

Re: Where and when to use which type of charts

Anonymous — Wed, 24 Dec 2014 10:49:09 GMT

thank you amit.saini

Re: Where and when to use which type of charts

amit_saini — Wed, 24 Dec 2014 10:51:05 GMT

Your Welcome

Re: Where and when to use which type of charts

francoiscave — Wed, 24 Dec 2014 12:30:46 GMT

Hi rgv,

Please close this thread by making appropriate answer if you are satisfied...

François