Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Partner
Partner

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:

View solution in original post

8 Replies
vivientexier
Partner
Partner

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:

View solution in original post

MK_QSL
MVP
MVP

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
Partner
Partner

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.

kumarnatarajan
Partner
Partner

Hi,

System fields start with $ sign.

Ex: $Fields

It is contain all fields name

Not applicable

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

Hi Natarajan,

Thank you very much for your kind concern.

Thanks

pavan kumar

peschu123
Partner
Partner

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
Contributor II
Contributor II

can anyone tell me what is this CD variable?