Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

List of system variables

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.

1 Solution

Accepted Solutions
vivientexier
Contributor II

Re: List of system variables

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:
8 Replies
vivientexier
Contributor II

Re: List of system variables

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:
MVP
MVP

Re: List of system variables

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';

vivientexier
Contributor II

Re: List of system variables

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.

Partner
Partner

Re: List of system variables

Hi,

System fields start with $ sign.

Ex: $Fields

It is contain all fields name

Not applicable

Re: List of system variables

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

Not applicable

Re: List of system variables

Hi Natarajan,

Thank you very much for your kind concern.

Thanks

pavan kumar

peschu123
Contributor III

Re: List of system variables

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

gowthamrajr
New Contributor II

Re: List of system variables

can anyone tell me what is this CD variable?