topic Re: Field selection in Script in QlikView

Field selection in Script

Wed, 21 Jan 2015 14:55:41 GMT

Hi All,

In a table i have a Value in a field , i want to only get (filter) that field in new field, its throwing error.

in 'Event Type' field i want to only load 'Date Change' values and want it in new field.

i need it in script level.

Re: Field selection in Script

alexandros17 — Wed, 21 Jan 2015 15:01:01 GMT

Load

...

If([Event Type] = 'Date Change', [Event Type], Null()) as SSG_Event_Type

...

Resident

...

let me know

Re: Field selection in Script

Wed, 21 Jan 2015 15:05:18 GMT

Thankyou Alexandros17

Re: Field selection in Script

Wed, 21 Jan 2015 15:16:54 GMT

Alessandro i have a similar expression i need to write in script, its showing null

Expression for Event Date.

=if(wildmatch([Event Phase Review Name],'*Phase*'), date([Event Date],'MM/DD/YYYY'))

Thank you in advance.

Re: Field selection in Script

alexandros17 — Wed, 21 Jan 2015 15:19:48 GMT

Try With

if(wildmatch([Event Phase Review Name],'*Phase*') > 0, date([Event Date],'MM/DD/YYYY'), 'NoValue') as myField

Let me know

Re: Field selection in Script

Wed, 21 Jan 2015 16:04:07 GMT

it is working fine , but not iam expecting this result.

Calculated Dimension

Eventdate

=if(wildmatch([Event Phase Review Name],'*Phase*'),date([Event Date],'MM/DD/YYYY'))

Its populating 2 records

But After writing in script its showing too many other records even Checked 'Supress Null values'

Re: Field selection in Script

alexandros17 — Wed, 21 Jan 2015 16:14:58 GMT

I do not think that this depends on the new field, it depends on the tables and how they are linked.

But Are you using the =if(wildmatch([Event Phase Review Name],'*Phase*'),date([Event Date],'MM/DD/YYYY'))

as a dimension?

Let me know

Re: Field selection in Script

Wed, 21 Jan 2015 16:25:48 GMT

ys they are using the same as for Event date

Calculated Dim

=if(wildmatch([Event Phase Review Name],'*Phase*'),date([Event Date],'MM/DD/YYYY'))

used same in Expression for comparison.

=if(wildmatch([Event Phase Review Name],'*Phase*'),Max(date([Event Date],'MM/DD/YYYY')))

first 2 field are calculated Dim, and last 2 are Expression

After the scripting

first 2 fields are Dim, other 2 are expressions.

Thankyou

Re: Field selection in Script

Wed, 21 Jan 2015 16:34:57 GMT

i scripted the same function to a dimension as you posted before.

if(wildmatch([Event Phase Review Name],'*Phase*') > 0, date([Event Date],'MM/DD/YYYY'), 'NoValue') as myField

But if i use this

if(wildmatch([Event Phase Review Name],'*Phase*'),date([Event Date],'MM/DD/YYYY'))

its showing the same result as above.

Re: Field selection in Script

alexandros17 — Wed, 21 Jan 2015 16:45:34 GMT

The script itself is correct, maybe the field [Event Phase Review Name] is still not available, that is:

If you do

Load
...
if(....) as myField,
If(MyField = ...) as myNewField
...

the script will throw an error because the field myField is not available for another test (the second if in the example.

In these cases:

Load
...
If(MyField = ...) as myNewField
;
Load
...
if(....) as myField,
...

Re: Field selection in Script

Wed, 21 Jan 2015 16:50:00 GMT

This is the script, can u suggest me further .