Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,
S
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 .
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,
S
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$);
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,
S
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!!!!
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
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