topic Re: Inputfield Condition in QlikView

Inputfield Condition

sathishkumar_go — Tue, 23 Oct 2012 13:23:08 GMT

HI All, I have one scnerio - For last 6 months data user want to change the values (Input field), Rest of the months user can't able to edit. Example: Month Jan'12 Feb'12 Mar'12 Apr'12 May'12 Jun'12 Jul'12 Aug'12 Sep'12 Oct'12 Value 20 15 30 20 15 100 100 100 100 100 Here, May to Oct User can change the value rest of the month they can't able to edit. while loading the data I have flag for last 6 months. sothat I used this if(Flag_Last6Months =1,inputsum(Value_Last6Months),sum(Value)) But its not working ( I have Value and Value_Last6Months fileds, I declared Value_Last6Months as input field) Anyother way.... looking forward ur help.... Regards Sathish

Re: Inputfield Condition

MayilVahanan — Tue, 23 Oct 2012 14:21:46 GMT

I think attached file, helps u. If not, can you please post a sample file?

Re: Inputfield Condition

jeffmartins — Tue, 23 Oct 2012 16:02:28 GMT

Hi sathishkumar.gobi,

You can create a straight table with columns you can and cannot edit for all months.

Then you create a variable to hide the columns you don't want to show.

I've updated the file and created the variable to hide the columns.

See the attached file. Hope it helps you.

Regards

Re: Inputfield Condition

jeffmartins — Wed, 24 Oct 2012 01:48:25 GMT

Hi sathishkumar.gobi,

You can create a straight table with columns you can and cannot edit for all months.

Then you create a variable to hide the columns you don't want to show.

I've updated the file and created the variable to hide the columns.

See the attached file. Hope it helps you.

Regards