topic Dimension visualization in chart in QlikView

Dimension visualization in chart

Tue, 22 Sep 2015 15:36:45 GMT

I have a table like this:

ProductID, Color, Value

1, Red, 10

2, Red, 20

3, Blue, 30

4, Green, 20

ecc.

I need to visualize top x Product by Value, but instead of ProductId description, I need to visualize the Color.

Example of top 3:

Blue, 30

Green, 20

Red, 20

Thanks in advance

Andrea

Re: Dimension visualization in chart

cjohnson — Tue, 22 Sep 2015 17:30:34 GMT

Caletti,

There are a few ways I can think of to do this. Here are a couple ways:

1. Max Number:

You can set the max number of a straight table (if that is your desired visualization) with the Max Number box checked. As long as you have the table sorted accordingly it should show you the top color's.

Expression for the above chart is MAX(Value).

2. Dimension Limits

You can use dimension limits to also achieve the same results. This can be used in multiple chart types:

3. Using the rank function:

You can also use the rank function and an if statement in your expression. Please see Qlikview help for the rank function:

rank( [total] expression [, mode [, format]] )

Evaluates expression, compares the result with the result on the

other rows within the current column segment and returns the ranking

of the current row within the segment. For image charts the current

column segment is defined as it appears in the chart's straight

table equivalent.

Is "x" a static number or can this value change? If it changes - then you will instead need to introduce a variable that sets these limits.

Thanks,

Camile

Re: Dimension visualization in chart

sinanozdemir — Tue, 22 Sep 2015 17:34:42 GMT

Hi Caletti,

You can use Rank() with Aggr():

Hope this helps.

Thanks

Re: Dimension visualization in chart

Tue, 22 Sep 2015 17:39:52 GMT

the easiest and most simple is to use dimension limits

Re: Dimension visualization in chart

maxgro — Tue, 22 Sep 2015 19:01:38 GMT

dimension limit is one of the ways

for other, see

Show Top Performers | Qlik Community

Re: Dimension visualization in chart

MarcoWedel — Tue, 22 Sep 2015 22:31:40 GMT

Hi,

another solution could be:

hope this helps

regards

Marco

Re: Dimension visualization in chart

Wed, 23 Sep 2015 08:06:24 GMT

Hi Marco,

thanks for the useful advices.

I think this is the simpler and faster solution to implement for my case.

Andrea

Re: Dimension visualization in chart

sunilkumarqv — Wed, 23 Sep 2015 08:41:02 GMT

Straight table:

Dimension: Color

Measure: Aggr(Max(value),Color)