topic Re: Top Customer charts in QlikView

Top Customer charts

manojkulkarni — Tue, 04 Mar 2014 03:21:45 GMT

Good morning everybody,

We have one requirement, in which we need to show top 10 customers in one chart & second chart should show top next 20 customers (i.e 11 to 30).

First chart i.e top 10, i would manage by using dimension limit. But how to achieve the second chart which should show customers 11-30 ?

Anonymous — Tue, 04 Mar 2014 04:49:40 GMT

PFA

manojkulkarni — Tue, 04 Mar 2014 04:55:43 GMT

Thanks for you solution. Is there a way to create charts without using calculated dimensions.

sunilkumarqv — Tue, 04 Mar 2014 05:09:15 GMT

You can achive these in Dimesion limits

go chart properties, Dimesion limits tab check the Restrict which values are display using the first exp ,show only

based on first , largest ,smallest make values

for example for top 10

show only

largest 10 values

and for second 11-30

change value to smallest 20 values

Anonymous — Tue, 04 Mar 2014 05:33:59 GMT

Then you have to calculate them at script level,

you can assign values at script only.

manojkulkarni — Tue, 04 Mar 2014 05:43:05 GMT

script level cann't be calculated. Bcz this will change on the basis of selection.

manojkulkarni — Tue, 04 Mar 2014 05:43:37 GMT

not working..

Anonymous — Tue, 04 Mar 2014 05:44:39 GMT

PFA new file with SCRIPT LEVEL calculation

sunilkumarqv — Tue, 04 Mar 2014 05:49:21 GMT

As of the Manoj reqiurment for him need without calculated dimensions.

not reqiured to calculate in script we can make in use of experssion

Anonymous — Tue, 04 Mar 2014 05:59:32 GMT

PFA

ALSO ADDED AT EXPRESSION LEVEL..