Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Locked field (?)

Hi,

I have a field (Jaar) which, for some apparent reason, seems to be locked. I cannot click on the LB (it's not marked as Readonly). I'm running QV Desktop 11

Here's a shot on the Table tab in the Document properties:

Locked field.PNG

script looks straightforward

LOAD

          DUAL(Year(Datum) & '- 0', AutoNumberHash128(Year(Datum) & '- 0')) AS %Financieel_Periode_key,

           0   

                                                    AS Periode,

    Year(Datum)            AS Jaar,

     Year(Datum) & '-Q4'  AS [Jaar-kwartaal],

     Year(Datum) & '- 0' AS [Jaar-periode],

     'Q1' AS [kwartaal],

     Makedate(Year(Datum),1,1)   AS Datum,

Makedate(Year(Datum),1,1)   AS Periode_begin,

YearEnd(Datum)     AS Periode_eind;

LOAD

          AddYears(Makedate('$(vMin_Jaar)',1,1), IterNo()-1)           AS Datum

AutoGenerate(1)

WHILE Date(AddYears(Makedate('$(vMin_Jaar)',1,1), IterNo()-1)) <= '$(vFinancieelPeriode_EindDatum)';

Any idea's?

Dror

1 Reply
Not applicable
Author

right click on tab, select properties, add field, right click field and select Unlock