topic Re: Add one field with fixed values in QlikView

Add one field with fixed values

qliklearnervir — Wed, 02 Sep 2015 06:56:08 GMT

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.

Re: Add one field with fixed values

gautik92 — Wed, 02 Sep 2015 06:56:55 GMT

can you post some sample data

Re: Add one field with fixed values

petter — Wed, 02 Sep 2015 06:58:37 GMT

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

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

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

Re: Add one field with fixed values

qlikmsg4u — Wed, 02 Sep 2015 06:59:28 GMT

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

sunny_talwar — Wed, 02 Sep 2015 07:01:52 GMT

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

Re: Add one field with fixed values

sasiparupudi1 — Wed, 02 Sep 2015 07:17:18 GMT

if you have YYYYMM as a dimension,

add a calculated dimension in the straight table like below

='SRF_' & YYYYMM&'Conference'

hth

Sasi

Re: Add one field with fixed values

qlikviewwizard — Wed, 02 Sep 2015 07:42:07 GMT

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

];

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

Re: Add one field with fixed values

qlikviewwizard — Wed, 02 Sep 2015 07:43:49 GMT

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