topic Re: showing fields in QlikView

showing fields

narender123 — Wed, 02 Mar 2016 12:02:22 GMT

Hi All,

I have a script like:

LOAD IED_ID,

DOC_VER,

OP_NAME,

if(OP_NAME='Store',CLOSED_DATE_TIME) as Stored_Date_Time,

if(OP_NAME='Agent Release',CLOSED_DATE_TIME) as Agent_Validated_Time,

if(OP_NAME='Total Discharge',CLOSED_DATE_TIME) as Released_Date_Time,

NEW_GEN_REG_TIM,

CLOSED_DATE_TIME,

OP_DATE_TIME,

C_BINDER_ID,

from table;

I set a expression in my table

=Interval(Released_Date_Time - NEW_GEN_REG_TIM, 'hh:mm:ss')

and the columns are

Stored_Date_Time Agent_Validated_Time Released_Date_Time NEW_GEN_REG_TIM

But in result it is showing data in Released_Date_Time and NEW_GEN_REG_TIM dimention with expression result.

Why the Stored_Date_Time and Agent_Validated_Time showing null value??

Re: showing fields

Chanty4u — Wed, 02 Mar 2016 12:05:13 GMT

did u cross chk with ur original data? is that hvng null values?

Re: showing fields

Anonymous — Wed, 02 Mar 2016 12:11:41 GMT

enhance your table by field CLOSED_DATE_TIME and OP_NAME and verify the Content and your condition in script

only if OP_NAME doesnot have values like 'Store' or 'Agent Release' then null will be calcluted in target field

else problem with lower/upper characters?

Re: showing fields

Wed, 02 Mar 2016 12:14:17 GMT

Hi Narendra,

Could you check the data once whether the

if(OP_NAME='Store',CLOSED_DATE_TIME) as Stored_Date_Time,

if(OP_NAME='Agent Release',CLOSED_DATE_TIME) as Agent_Validated_Time

is evaluating.

Re: showing fields

narender123 — Wed, 02 Mar 2016 12:29:29 GMT

Hi Chanty,

I checked my data all fileds have value.

where Released_Date_Time is present only at that place both Stored_Date_Time and Agent_Validated_Time will be absent.

But in table only Released_Date_Time data is visible .

But when i used other expression rather than subtraction both Stored_Date_Time and Agent_Validated_Time showing value.

Thanks.

Narender

Re: showing fields

narender123 — Wed, 02 Mar 2016 12:31:51 GMT

Thank you for reply.

Please see my reply to Chanty.

Narender

Re: showing fields

narender123 — Wed, 02 Mar 2016 12:32:09 GMT

Thank you for reply.

Please see my reply to Chanty.

Narender

Re: showing fields

avinashelite — Wed, 02 Mar 2016 12:36:31 GMT

can please share the sample data and the desire output format so that it will helpful for us to give the solution ..

Re: showing fields

jonas_rezende — Wed, 02 Mar 2016 13:12:39 GMT

Hi, Narender Makhija.

The my suggestion would be word insert of test. After reload, see if appear in ListBox of fields Stored_Date_Time and Agent_Validated_Time. Example:

LOAD IED_ID,

DOC_VER,

OP_NAME,

if(OP_NAME='Store',CLOSED_DATE_TIME,'Test Store Date Time') as Stored_Date_Time,

if(OP_NAME='Agent Release',CLOSED_DATE_TIME,'Test Agent Validated Time') as Agent_Validated_Time,

NEW_GEN_REG_TIM,

CLOSED_DATE_TIME,

OP_DATE_TIME,

C_BINDER_ID,

from table;

Value appears with the occurrence test?

Hope this helps!