Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qliklearnervir
New Contributor III

Add one field with fixed values

Hi,

I want to add 1 field in the straight table and the field value is "SRF_MMMYYYYConference"   .

Kindly suggest how can i add this field value in the table and this value we have to add from our end .

other than MMMYYYY , we have to hardcode complete value.

Kindly suggest.

7 Replies
gautik92
Valued Contributor III

Re: Add one field with fixed values

can you post some sample data

MVP
MVP

Re: Add one field with fixed values

In the UI you can simply have the expression like this:

'SRF_' & vDateVariable & 'Conference'      if referring to a variable that contains the date

or

'SRF_' & Min(ConfDate) & 'Conference'     if the conference date is associated with the dimensions in a meaningful way

qlikmsg4u
Valued Contributor

Re: Add one field with fixed values

add this line in your script,

'SRF_MMMYYYYConference' as new_field


then add this field in straight table

Re: Add one field with fixed values

This is needed to be added in the script or on the front end of the application?

sasiparupudi1
Honored Contributor III

Re: Add one field with fixed values

if you have YYYYMM as a dimension,

add a calculated dimension in the straight table like below

='SRF_' & YYYYMM&'Conference'

hth

Sasi

Arjunarao
Honored Contributor II

Re: Add one field with fixed values

Hi vir vir,

Please use the below script:

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='h:mm:ss TT';

//SET DateFormat='M/D/YYYY';

SET DateFormat='YYYYMM';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

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

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

Emplyee:

Load *, 'SRF_' & Date &' Conference' as NewDate;

load EMPNO, ENAME, JOB, MGR, date(HIREDATE) as Date, SAL, COMM, DEPTNO inline [

EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO

7369, SMITH, CLERK, 7902, 1980-12-17 00:00:00.000, 800.00, NULL, 20

7499, ALLEN, SALESMAN, 7698, 1981-02-20 00:00:00.000, 1600.00, 300.00, 30

7521, WARD, SALESMAN, 7698, 1981-02-22 00:00:00.000, 1250.00, 500.00, 30

7566, JONES, MANAGER, 7839, 1981-04-02 00:00:00.000, 2975.00, NULL, 20

7654, MARTIN, SALESMAN, 7698, 1981-09-28 00:00:00.000, 1250.00, 1400.00, 30

7698, BLAKE, MANAGER, 7839, 1981-05-01 00:00:00.000, 2850.00, NULL, 30

7782, CLARK, MANAGER, 7839, 1981-06-09 00:00:00.000, 2450.00, NULL, 10

7788, SCOTT, ANALYST, 7566, 1982-12-09 00:00:00.000, 3000.00, NULL, 20

7839, KING, PRESIDENT, NULL, 1981-11-17 00:00:00.000, 5000.00, NULL, 10

7844, TURNER, SALESMAN, 7698, 1981-09-08 00:00:00.000, 1500.00, 0.00, 30

7876, ADAMS, CLERK, 7788, 1983-01-12 00:00:00.000, 1100.00, NULL, 20

7900, JAMES, CLERK, 7698, 1981-12-03 00:00:00.000, 950.00, NULL, 30

7902, FORD, ANALYST, 7566, 1981-12-03 00:00:00.000, 3000.00, NULL, 20

7934, MILLER, CLERK, 7782, 1982-01-23 00:00:00.000, 1300.00, NULL, 10

];

Capture.JPG

//='SRF_' & YYYYMM&'Conference'

Arjunarao
Honored Contributor II

Re: Add one field with fixed values

Let us know if you get any issues. Thank you.

Community Browser