topic Re: Inputfield messing the actual field in QlikView

Inputfield messing the actual field

Fri, 06 Feb 2015 12:14:32 GMT

Hi!

I am adding command " '0' as [Change of HS date]" to my script to create a inputfield. But when I add the " Inputfield [Change of HS date];" on top of the table where I load data the field values turn into random numbers!

Any idea why this happens and how to fix it? Thanks!

Regards, Heidi

Re: Inputfield messing the actual field

sunny_talwar — Fri, 06 Feb 2015 12:21:49 GMT

That's weird, would you be able to paste the exact script where you assign [Change of HS date] as inputfield and then the table where you assign 0 as [Change of HS date]

Best,

Re: Inputfield messing the actual field

avinashelite — Fri, 06 Feb 2015 12:28:12 GMT

Hi Hedi,

Are you using the input function in the script??? or your creating the input field in the front end??

please post your script or sample app .

Re: Inputfield messing the actual field

sunny_talwar — Fri, 06 Feb 2015 12:31:33 GMT

From what I understand from her question, it seems that she is trying to do it within the script.

'0' as [Change of HS date]" to my script

Inputfield [Change of HS date];" on top of the table where I load data

Its weird why its doing that for her, Isn't it Avinashelite?

Best,

Re: Inputfield messing the actual field

Fri, 06 Feb 2015 12:33:51 GMT

Hi! This is how I have written it in the script and it has worked like this before! When I comment the inputfield -line out, Change of HS date shows zeroes like it should but with the inputfield command the numbers appear to table box and if I try to use it in straight table with inputsum()-command, it shows only '-'.

INPUTFIELD [Change of HS date];
DataTable:
Load *,
Year([Handshake / Agreed Date]) as [Handshake Year],
Month([Handshake / Agreed Date]) as [Handshake Month]
;
LOAD
date([Handshake / Agreed Date], 'YYYY-M-DD') as [Handshake / Agreed Date],
Date(MonthStart([Handshake / Agreed Date]), 'YYYY-M') as [Year-Month],
0 as [Change of HS date],
[Project Name],
Id,
[Project Status],
date([Added Date], 'YYYY-M-DD') as [Added Date]
FROM
[excelfile.xls]
(biff, embedded labels, table is Sheet$);

Re: Inputfield messing the actual field

sunny_talwar — Fri, 06 Feb 2015 12:38:00 GMT

To me everything looks in place, what do you think Avinashelite bro?

Best,

Re: Inputfield messing the actual field

sunny_talwar — Fri, 06 Feb 2015 12:48:02 GMT

Try this:

INPUTFIELD [Change of HS date];
DataTable:
Load *,
Year([Handshake / Agreed Date]) as [Handshake Year],
Month([Handshake / Agreed Date]) as [Handshake Month]
;
LOAD
date([Handshake / Agreed Date], 'YYYY-M-DD') as [Handshake / Agreed Date],
Date(MonthStart([Handshake / Agreed Date]), 'YYYY-M') as [Year-Month],
[Project Name],
Id,
[Project Status],
date([Added Date], 'YYYY-M-DD') as [Added Date]
FROM
[excelfile.xls]
(biff, embedded labels, table is Sheet$);

Join(DataTable)

LOAD 0 as [Change of HS date]

AutoGenerate 1;

Se if this helps

Please note: Removed 0 as [Change of HS date] from the above table

Best,

Re: Inputfield messing the actual field

avinashelite — Fri, 06 Feb 2015 13:00:05 GMT

Hi Heidi, sunindia

The script is working fine, its not any issue also.

As per my analysis, since its an input field she or user might have entered those values in the input field .

When you enter any values in the input box it saves it as entered number and that will be shown in that field :

The Peculiar thing is the entered input number is stored even after the reload also!!!!

Re: Inputfield messing the actual field

Fri, 06 Feb 2015 13:04:46 GMT

Hi Sunindia!

This trick removed the random values and now there is only zeros but the input function is not working in table box or straight table. Any idea why?

Regards, Heidi

Re: Inputfield messing the actual field

Fri, 06 Feb 2015 13:05:58 GMT

Input field values are retained even after reloads, will probably need a macro to reset, have a look at http://community.qlik.com/message/348223#348223

hope that helps

Joe

Re: Inputfield messing the actual field

avinashelite — Fri, 06 Feb 2015 13:06:29 GMT

Re: Inputfield messing the actual field

Fri, 06 Feb 2015 13:07:30 GMT

That's not the problem.

I haven't been able to input any values because the whole input function is not working in table box or straight table.

-Heidi

Re: Inputfield messing the actual field

sunny_talwar — Fri, 06 Feb 2015 13:07:51 GMT

That is true, but when she said the values were random + she also said that she commented the inputfield statement from the script which makes me think if that is the issue. Because from what I know the inputfield will only survive the reload if it stays there each time. If during one of the reloads, the inputfield was removed, the next time you reload with the inputfield, the value will be what you entered (0 in her case).

Let me know if I am thinking this incorrectly.

Best,

Re: Inputfield messing the actual field

Fri, 06 Feb 2015 13:11:10 GMT

hmm can you move your field creation up into your preceding load then, just in case the fact it is loaded twice is causing the issue

Re: Inputfield messing the actual field

avinashelite — Fri, 06 Feb 2015 13:15:41 GMT

yes sunindia bro Exactly, when she comments inputfeild the old state values will be rest,

but when she reloads it will be set to 0

Re: Inputfield messing the actual field

sunny_talwar — Fri, 06 Feb 2015 13:16:13 GMT

Posted the unsaved copy of the app. PFA

Best,

Re: Inputfield messing the actual field

avinashelite — Fri, 06 Feb 2015 13:20:01 GMT

can you post your app.

Re: Inputfield messing the actual field

Fri, 06 Feb 2015 13:22:32 GMT

Hi Joe!

Doesn't do anything. When I do the join - autogenerate load Sunindia suggested - values become zeros, which is good but I still can't input anything so there is still something badly wrong with this /:

Re: Inputfield messing the actual field

sunny_talwar — Fri, 06 Feb 2015 13:23:53 GMT

Did you look at the sample QVW file I have posted. You might be able to figure out what the difference is.

Best,

Re: Inputfield messing the actual field

johnca — Fri, 06 Feb 2015 13:30:39 GMT

All the instances I've used an inputfield I've written it thus, after declaring it;

' ' as [Change of HS date]

(Two single quotes with a space between them.)

Try it with the single quotes like this;

'0' as [Change of HS dates]