topic Re: Disable inputfield in a table for past months in QlikView

Disable inputfield in a table for past months

Anonymous — Mon, 28 Dec 2015 13:36:39 GMT

Hi all,

I have a table of sales with customer, item, month and quantity.

I setted the quantity to be an input field in order to let the user to input some values, and this works.

Then I would like to let the user to modify the quantity only for the future months, and the past months should be a readonly field.

I tried to do something like this:

if (
  month_id >= Year(Today())*100+Month(Today())
  , InputSum ( forecast_qty_SIM )
)

but the field is always in read only.

(I have already checked the condition and it is correct)

Do you have any idea?

Thanks

stefano

Re: Disable inputfield in a table for past months

Mon, 28 Dec 2015 15:16:57 GMT

what is the value of month id - in the coce you provided above, the expression Year(Today())*100+Month(Today()) will result in the value of 201512?

you may need to put parenthesis around either side of the '*' but the number comes out very high

=(Year(Today()))*(100+Month(Today()))

what date or value are you expecting???

Re: Disable inputfield in a table for past months

Mon, 28 Dec 2015 15:18:50 GMT

year(today()) * 100 = 210500?

Re: Disable inputfield in a table for past months

Anonymous — Mon, 28 Dec 2015 15:33:14 GMT

Hi Adam,

month_id field is in the format YYYYMM and the condition "Year(Today())*100+Month(Today())" returns the data in the same format (es. 201512).

My question is: how can I set the future month with the inputfield, and past months without it?

Thanks

stefano

Re: Disable inputfield in a table for past months

Mon, 28 Dec 2015 15:46:30 GMT

can you supply a,list of month_id values that are in your applciaiton. It looks like you are comparing 2 YYYYMM fields to each other.

have you tried having both fields in the num format?

can you post a sample qvw?

Re: Disable inputfield in a table for past months

Anonymous — Mon, 28 Dec 2015 15:55:47 GMT

Adam, the issue is not on the date condition (it works, I am sure about this).

My problem is how to set a field to be input field in some conditions, and to be a read only field in other condition.

In my example the condition was based on the month, but it could be based also on the customer, or on the item.

Thanks

stefano

Re: Disable inputfield in a table for past months

swuehl — Mon, 28 Dec 2015 16:17:43 GMT

I don't think you can enable / disable the input field per dimension value at all using a conditional

Have you seen a demo showing this somewhere?

Re: Disable inputfield in a table for past months

Mon, 28 Dec 2015 16:49:36 GMT

I understand what you are trying to do much better but as swuehl said, I do not believe you can change a dimesnion in that manner

some other options might be is to when you write out your data, you can do the check at tht point or there are more advanced extension objects that handle updating of fields, but that is updating the source of the data (the extensions are from KT Labs - )