topic Re: Legend Properties?? in QlikView

Legend Properties??

Fri, 06 Jul 2012 16:25:53 GMT

How to change the properties of legend on a bar chart/scatter chart?

I am using a bar chart and I am representing two bars(each corresponding to a year : 2011, 2012). And under each bar I have two sections (one color for each). In the legend I get 4 options (2 green and 2 gray), but I just want 2 optionsin the legend (1 green and 1 gray).

How do I fix that?

Please find the attachment for the qvw file

Re: Legend Properties??

MayilVahanan — Fri, 06 Jul 2012 17:07:43 GMT

Hi,

In this you are using four expression , so the four legend will appear.. It can't be reduce..

You can use like this,

Change the script as

Load * if(line_no = 1 or line_no =2 , line_no) as line_no1 from filename;

and use

line_no1 and year_no as dimension and use sum(sales_2012) like that.

( or) attach your xls file also. And your requirement .

Hope it helps.

Re: Legend Properties??

Fri, 06 Jul 2012 17:18:56 GMT

Can you make the changes in the qvw ?

I have access to licensed version for sometime now??

Re: Legend Properties??

Fri, 06 Jul 2012 17:37:27 GMT

Here is a sample excel, I have changed it but the column names are the same. So you can use it

Re: Legend Properties??

Fri, 06 Jul 2012 18:03:02 GMT

Here is my requirement,

I have to represent the sales for the years 2011 and 2012.

So, tI have used year as the dimension.

And I have used sum(sales) as the expression.

Now for each year , I need to represent promoted slaes and non-promoted sales. So , that is why I have used two expressions. for each year: line_no = 1 represents sales on promotion

line_2 = non promoted sales

Is that clear?

Re: Legend Properties??

Fri, 06 Jul 2012 18:06:39 GMT

I have updated the xls ..it has rows with line_no = 1and line_no = 2.

I hope the requirement is clear. Please let me know if u need more info

Re: Legend Properties??

MayilVahanan — Fri, 06 Jul 2012 18:18:31 GMT

Hi,

For your requirement, you can use 2 dimension and 2 expression as above post.. or use urs or use below post by using cyclic . you can reduce into 2 expression and one dimension..May be it helps..Did you try it..Can i know it what the result?

Re: Legend Properties??

Fri, 06 Jul 2012 19:45:49 GMT

Thanks Mayil,

Though the solution you gave did not help me, your suggestion helped.

Re: Legend Properties??

MayilVahanan — Fri, 06 Jul 2012 19:49:54 GMT

Sorry uday shankar.. i don't know how to achieve this..When you achieve your requirement, can you post it..i will increase my knowledge..In my point of view, i tried my best..

Re: Legend Properties??

Fri, 06 Jul 2012 19:52:54 GMT

As you said, I changed the number of expressions. I used two instead of four expression. I think there was a problem with the data set, so I changed the query which fetched the data set .

In the data set i shared, I was grouping data two times, there was a year column and there was also sales 2011 and sales2012. I got rid of two columns and now I have one column sales and I have a column year(which is my dimnsion and takes care of sales 2011 and sales 2012).

I hope I was clear

Re: Legend Properties??

Fri, 06 Jul 2012 19:55:15 GMT

There is one thing I still did not get .

Number format on a text box. I tried using this function, but it is not getting reflected.

Can you help me on this?

I will delete this once I get ur reply.

this is to format the number and have thousand separator

num#((sales),'#.#','.',',')

Re: Legend Properties??

MayilVahanan — Fri, 06 Jul 2012 20:00:27 GMT

Hi,

Try this,

=Num(Sales,'#,##0')

For example

=Num(2468264,'#,##0') gives 2,468,264

Hope it helps

Re: Legend Properties??

Fri, 06 Jul 2012 20:03:12 GMT

Thanks it worked,

What is the difference between num and num#??

Re: Legend Properties??

MayilVahanan — Fri, 06 Jul 2012 20:10:09 GMT

Hi,

From tutorial :

num#(expression [ , format-code[ , decimal-sep [ , thousands-sep] ] ])

The num# function evaluates the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters.

- its used for text

-in your files data is in string format rather than number format like sales => '12345'

Ex:num#(sales,'#,##0') gives 12,345

For same example mentioned above, wen u give as

Num#(2468264,'#,##0') gives 2468264 only

num(expression [ , format-code [ , decimal-sep [ , thousands-sep ] ] ] )

The num function formats the expression numerically according to the string given as format-code. Decimal separator and thousands separator can be set as third and fourth parameters.

-its used for number

-in your files data is in number format like sales => 12345

Ex:num(sales,'#,##0') gives 12,345

For more details

Please see the referenue manual

Re: Legend Properties??

Fri, 06 Jul 2012 20:13:19 GMT

=Num(Sales,'#,##0')

For example

=Num(2468264,'#,##0') gives 2,468,264

This works. Now if we have to give space instead of ','...how do we include space inside that expression???

Re: Legend Properties??

MayilVahanan — Fri, 06 Jul 2012 20:17:45 GMT

Hi,

Try like this,

=Num(Sales,'# ##0','.',' ')

For example

=Num(2334242000,'# ##0','.',' ')

GIVES 2 334 242 000

Hope it helps

Re: Legend Properties??

Fri, 06 Jul 2012 20:21:56 GMT

Yes that worked!

Sorry again to post it here, I willdelete it as soon asyou answer this

Mayil,

Do you know how to fix the width of a each cell?

I do not want to drag and fix the size. I have to have every column of the same width. Do you know how to do that?

Re: Legend Properties??

MayilVahanan — Fri, 06 Jul 2012 20:27:08 GMT

Hi,

In Chart -> right click -> fit columns to data or Equal column width

Hope it helps..

Re: Legend Properties??

Fri, 06 Jul 2012 20:30:25 GMT

Hi,

thanks but this does not help because I do not want it that way, I want to manually fix the size.

Like under caption we have option to enter the number of pixels for the horizontal or vertical length of the chart, I want to know if there is a place where I can give the width of each cell in the chart

Re: Legend Properties??

Fri, 06 Jul 2012 20:37:37 GMT

I could not find either.

anyway thanks for the help