topic Need help with expression in QlikView

Need help with expression

Sun, 28 Apr 2013 06:40:17 GMT

Hi guys, please find the above screen shot. I have question regarding the expression. What does '##.#%' in the expression indicate?

Also , when to enter = sign before expression and when not to?

Re: Need help with expression and gauge

Anonymous — Sun, 28 Apr 2013 09:50:15 GMT

Prasad

The QlikView Help is often a good source of basic information on QlikView Functions.

The bit I have pasted in below should answer your question:

What does '##.#%' in the expression indicate?

Num

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. If the parameters 2-4 are omitted, the number format set in the operating system is used.

Example:

The examples below assume the two following operating system settings:

	Default setting 1	Default setting 2
Number format	# ##0,#	#,##0.#

num( A, '0.0' ) where A=35648.375 returns:

	Setting 1	Setting 2
String	35 648 375	35648.375
Number	35648375	35648.375

num( A, '#,##0.##', '.' , ',' ) where A=35648 returns:

	Setting 1	Setting 2
String	35,648.00	35,648.00
Number	35648	35648

num( pi( ), '0,00' ) returns:

	Setting 1	Setting 2
String	3,14	003
Number	3.141592653	3.141592653

With the limted information you provide, for your guage showing 100% I can only guess that maybe you are displaying numeric value 77.5 as percent that is interpreted as 7,750 % which goes off the scale of your chart

Best Regards, Bill

Re: Need help with expression

Gysbert_Wassenaar — Sun, 28 Apr 2013 19:32:41 GMT

'##.#%' means that the value should be shown with 1 decimal and a percentage sign.

The = sign isn't necessary in expressions. Expressions that start with an = sign are evaluated any time something changes in the document iirc. So it's usually better to leave out the = sign.

Re: Need help with expression

Mon, 29 Apr 2013 05:56:22 GMT

##.#% symbol show the Format of number(example 23.5% )

All predefined functions work when these are write after = sign. that means = sign show that you calculate some task.

Re: Need help with expression

Tue, 30 Apr 2013 06:15:11 GMT

Thanks everyone.

@Bill,

The reason above gauge is showing 100% is my expression was wrong.