topic Re: List of system variables in QlikView

List of system variables

Thu, 16 May 2013 09:43:59 GMT

Hi,

I'm very new to qlikview, today I got interview call, and he asked me about 'System Variables'.

I don't have any idea about 'System Variables'.

Could any one tell me the list of system variables.

Thanks in Advance

pawan kumar.

Re: List of system variables

vivientexier — Thu, 16 May 2013 09:46:19 GMT

This is your system variables.

CD	=	F:
DateFormat	=	DD/MM/YYYY
DayNames	=	lun.;mar.;mer.;jeu.;ven.;sam.;dim.
DecimalSep	=	,
ErrorMode	=	1
MoneyDecimalSep	=	,
MoneyFormat	=	# ##0,00 €;-# ##0,00 €
MoneyThousandSep	=
MonthNames	=	janv.;févr.;mars;avr.;mai;juin;juil.;août;sept.;oct.;nov.;déc.
OpenUrlTimeout	=	86500
QvPath	=	C:\Program Files\QlikView
QvRoot	=	C:
QvWorkPath	=	C:\Users\
QvWorkRoot	=	C:
ScriptError	=
ScriptErrorCount	=	0
ScriptErrorList	=
StripComments	=	1
ThousandSep	=
TimeFormat	=	hh:mm:ss
TimestampFormat	=	DD/MM/YYYY hh:mm:ss[.fff]
WinPath	=	C:\windows
WinRoot	=	C:

Re: List of system variables

MK_QSL — Thu, 16 May 2013 09:47:16 GMT

You can find them at load script.....

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='#,##0.00;-£#,##0.00';

SET TimeFormat='hh:mm:ss';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YY hh:mm:ss[.fff]';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Re: List of system variables

vivientexier — Thu, 16 May 2013 09:49:28 GMT

In order to find them :

Go to "Settings" > "User Preferences" > "Show System Variables".

Then you will be able to see them in your :

"Variable Overview" (in "Settings" menu).

For this variable to exist, you need your application to be load at least once.

Re: List of system variables

kumarnatarajan — Thu, 16 May 2013 09:56:26 GMT

Hi,

System fields start with $ sign.

Ex: $Fields

It is contain all fields name

Re: List of system variables

Fri, 17 May 2013 06:34:20 GMT

Thank you very much Viven,

You really deserve it, thanks a lot.

Can you please share to me any link or documents regarding 'system variables'.

And one more thing: please see the attachment

It contains a bar chart, while i'm practicing, I created this.

Every thing is good, except BIA (green bar) it contains some value(lower that 4.8), the values are not visable.

Please give me a solution to view the values with in the stacked area.

Thanks in Advance

Pavan kumar

Re: List of system variables

Fri, 17 May 2013 06:38:55 GMT

Hi Natarajan,

Thank you very much for your kind concern.

Thanks

pavan kumar

Re: List of system variables

peschu123 — Sat, 16 Aug 2014 13:49:37 GMT

Hi,

I just stumbled over this thread and I saw your post.

The field containing fieldnames is "$field" (without s) the field you refer to just contains the number of fields.

Best Regards,

Peter

Re: List of system variables

gowthamrajr — Mon, 28 Dec 2015 07:28:35 GMT

can anyone tell me what is this CD variable?