topic Re: suggestions for choosing right chart in QlikView

suggestions for choosing right chart

gauthamchilled — Fri, 20 Nov 2020 18:02:30 GMT

Hi,

I would like to create a chart to compare interst rates for different banks for different no of months. Which chart will be correct chart for this scenario? I want to show the values on data points, if i check the Auto, the symbols are crowded on the chart.

Can any one suggest?

Re: suggestions for choosing right chart

gauthamchilled — Fri, 19 Jun 2015 05:00:46 GMT

Any suggestions or idea or sample app?

Re: suggestions for choosing right chart

abhaysingh — Fri, 19 Jun 2015 05:22:13 GMT

Hi Gautham,

First i would suggest be clear with the requirement and than think which chart suits best. M giving few examples which suits best in scenarios.

1- Bar Chart - Comparisons, suppose you want to compare CY Sales vs PY Sales, Drill Down/Cyclic dimension Representations, Actual Vs Target than Bar Chart suits best.

2- Line Chart = Specially to show trends, Month on month, YoY Sales etc.

3- Combo Chart= Combination of bar and line Chart

4- Pie Chart = Contributions of percentage

5-Funnel Chart= Specially for Bucket analysis.

6- Radar Chart= for Hypothetical Surveys

7- Gauge Chart= Achievements, dimension less and specially for dashboard, for MTD/YTD analysis.

8- Scatter Chart= Shows Density

9-Mekko Chart= Shows Tree kind of Analysis as per Area... bigger area represent greater sales.

10-Block Chart= Block wise sales

hope it helps

Regards

Abhay

Re: suggestions for choosing right chart

aveeeeeee7en — Fri, 19 Jun 2015 05:26:18 GMT

See this Post:

QlikView Chart Types

Choose the Chart as per your requirement after reading this.

Regards

Av7eN

Re: suggestions for choosing right chart

Anonymous — Fri, 19 Jun 2015 05:29:13 GMT

Hi Gautham,

1. Bar Chart:

Comparison of similar measurements

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:

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:

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:

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

5. Gauge chart:

Ratio of measurements

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

b) Date vs last YTD. Avoid: actual amounts

6. Mekko chart:

Data using variable width bars

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

b) Market analysis.

7. Scatter Chart:

Measurement acts as dimensions (3D Chart)

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

b) Map chart- see sales on Geographical map

8. Grid Chart:

2 or 3 Dimensions with a measurement

a) Multi-cross dimensional measurements

b) amounts over- region and product and over time

9. Pie Chart:

Visual Distribution measurements

a) what contributes how to the whole- regional sales

b) yes/no analysis

10. Funnel chart:

Dimension that contain an expiration time line

A) how much is the most aging element

b) Sales opportunities

c) Product Inventory Expressions

11.Block chart:

Distribution measurements within multi dimensions

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

b) sales contribution per country

12. Straight Table:

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:

Multi dimensions with one or more measurements

a) Grouping of dimensions

b) Dimensions across the table and displaying sub totals First sorted value: It returns the first value of expression sorted by corresponding sort weight. Sort weight should be a numeric value.

Uses:

a) Get the latest field value based on time stamp

b) Bigger customer for each product category

c) Find the min/max values and extract related field

d) Compare highest and second value

e)look up min/max value within range.

Hope it will helpful

Re: suggestions for choosing right chart

aveeeeeee7en — Fri, 19 Jun 2015 05:30:40 GMT

Also, see this:

Re: Types of charts ? its Specification ?

Regards

Av7eN

Re: suggestions for choosing right chart

Anonymous — Fri, 19 Jun 2015 05:40:14 GMT

Gautham,

Check this " information dashboard design pdf" in google

Re: suggestions for choosing right chart

Anonymous — Fri, 19 Jun 2015 05:40:53 GMT

For clear explanation check this thread:

How many chart type in QlikView?

Re: suggestions for choosing right chart

jagan — Fri, 19 Jun 2015 05:54:28 GMT

Hi Gautham,

Go through the attached dashboard it helps you identifying which chart to use in which scenario.

Regards,

Jagan.

Re: suggestions for choosing right chart

jagan — Fri, 19 Jun 2015 05:55:05 GMT

also go through this attachment.

Regards,

jagan.

Re: suggestions for choosing right chart

Chanty4u — Fri, 19 Jun 2015 07:01:27 GMT

you can use blokchart if it is financial domain

in dat u can easyly dispaly all the intrest caluclations

thank you

Suresh.

Re: suggestions for choosing right chart

Anonymous — Mon, 10 Oct 2016 15:22:24 GMT

Thats great, good knowledge.

Re: suggestions for choosing right chart

Mon, 24 Oct 2016 12:56:44 GMT

Hi,

Does anyone know the maximum number of dimension for a Combo Chart?

Thanks!