topic Re: Bar chart in QlikView

Bar chart

Tue, 03 Dec 2013 06:56:09 GMT

i have so many employee names in bar chart but i want to show 10 prescribed names,please give me a expression and where to write

Re: Bar chart

Tue, 03 Dec 2013 07:34:04 GMT

10 prescribed names means top 10 or above 10 or below 10 or first 10 or last 10

please explain breifly

Re: Bar chart

Tue, 03 Dec 2013 07:37:04 GMT

Hi Narotham,

If your values depends on the limits(top 10, small, greater or so) then you can go to dimension limits and set the values or else you may create a variable and assign the values to that variables which can be used in your expressions.

Thanks,

Sai

Re: Re: Bar chart

Tue, 03 Dec 2013 07:53:42 GMT

Hi Narotham,

If u want show employees based on metric you can use dimension limit show only largest 10.

In other case you can sort the dimensions(descending) based on metric ,go to presentation tab Enable X-axis scrollbar and give 10 as when number of items exceeds.in this case you can show all values in sorting order.

Regards,

Vijay

Re: Bar chart

rustyfishbones — Tue, 03 Dec 2013 08:20:20 GMT

Hi,

try using a Calculated Dimension using IF and MATCH, I have added 4 names but you can add 10 by just adding a ,'next name'

IF(MATCH(EmployeeName,'John','George','Paul','Ringo'),EmployeeName)

Re: Bar chart

rustyfishbones — Tue, 03 Dec 2013 08:23:27 GMT

you can add the Calculated Dimension here

Re: Bar chart

Tue, 03 Dec 2013 08:40:39 GMT

Hi,

You can also write set analysis with your employee list.

=sum({<Employee={ 'John','George','Paul','Ringo'}>}Sales)

regards,

Vijay

Re: Bar chart

jagan — Tue, 03 Dec 2013 08:51:37 GMT

Hi,

If you want to show the 10 prescribed members only then try like this

=Sum({MemberDimensionName = {'Member1', 'Member2', ............'Member10'}>} MeasureName)

If the members list keeps on changing then put it in an excel file and load into dashboard and use below expression

=Sum({<NewMemberDimensionName ={'*'}>} MeasureName)

Hope this helps you.

Regards,

Jagan.