Creating different kinds of charts and representating data

[#1]

Hi All

I want  to create different types of charts especially as below for best representation.

can we build charts as below

showing in the below way

        top2                                      
jan   apple 20
        mango 30

          top2

feb    apple 40

        mango 20

..............................
        

    top2
dec grape 12

I have data as below

load * inline[

fruits, items, month

apple, 20, jan

apple,30, jan

apple, 40, feb

apple, 50, mar

apple, 60, apr

mango, 10, jan

mango, 20, feb

mango, 35, mar

mango, 5, feb

grape, 7, mar

grape, 50, apr

grape, 12, dec ];

[marcus_sommer]

Gauges are quite seldom the best choice to visualize data. To get more insights regarding to visualizations I suggest the book:

Creating Stunning Dashboards with QlikView (October 2015)

Julian Villafuerte

ASIN: B017YC72MU

and also the books from Karl Pover are really helpful to this topic: Books and literature.

- Marcus

[#3]

Is there anyway that we can represent top 2 values top 3 values in the above charts

[marcus_sommer]

The most chart-types support the restriction on the top/flop of various things (within the document properties in tab limitations) but not the pivot or gauges - for them you will need to calculate the top with some kind of aggr-function like this one: Re: Aggr.....................#$£%@!!! or Using Aggr Function Top N.

- Marcus

[beck_bakytbek]

Hi John,

within QlikView you have a variety of Dashboards, what Kind of Dashboard you want to use, depends on your Business Environment.

Within QlikView: Startpage > Below: Ressources: View more examples of Dashboards

i hope that helps

beck

[#6]

Hi Beck i went thorough the docs and i'm unable to find the best chart for my business i mean

i have to choose between charts

my client want the below kind of charts

     

i have a simple percentage value

ie %ge of items in a particular month

can i build a testtube with that

i what exact cases can i use these gauge charts

[beck_bakytbek]

Ah ok,

check this:

QlikView | Charts | Gauge Chart - YouTube

Gauges you can use to Show any Ratio in financial Area, for instance like : Investment-Ratio, Working Capital - Ration, equity-Ratio

i hope that helps

beck

[#8]

Hi Beck

I have data like this in a straight table

it is the best representation to go for gauge chart'

[beck_bakytbek]

Hi John,

as i see, if you have such data, you can surely use the gauge

beck