topic Re: Clear /Unclear a field in QlikView

Clear /Unclear a field

ferha_jafri — Mon, 23 Nov 2015 04:17:20 GMT

Hello Everyone,

I want to implement a condition as when I click on an image of text object then a particular field value get selected from a field and when I click on it again then it get cleared. .

Thank you

Regards

Ferha Sharma

Re: Clear /Unclear a field

PrashantSangle — Mon, 23 Nov 2015 04:30:09 GMT

Hi,

Use trigger from Text Object Property.

Text Object Property -> Action->Action Type(Selection) -> Select In Field -> Enter Field Name -> Enter Value

Regards

Re: Clear /Unclear a field

PrashantSangle — Mon, 23 Nov 2015 04:38:21 GMT

Hi,

Find attachment for your reference.

Regards

Re: Clear /Unclear a field

sasikanth — Mon, 23 Nov 2015 04:45:05 GMT

HI,

PFA

Hope it will work

Re: Clear /Unclear a field

ferha_jafri — Mon, 23 Nov 2015 04:49:16 GMT

I am not able to open the doc as I am using personal edition, could you pla mention the steps to select on one click and deselect on another click.

Re: Clear /Unclear a field

sasikanth — Mon, 23 Nov 2015 04:57:55 GMT

Create a variable in Varibale overview

1) vSet and assign a value '0'

2) Add two actions

1) Set a variable : give variable name vSet and value is if(vSet='0','1','0')

2) Select in Field : Give filed name and Field-value is if(vSet='1','Field-value-name','')

Re: Clear /Unclear a field

PrashantSangle — Mon, 23 Nov 2015 05:00:52 GMT

Hi,

1st Create Vaiable say vShow assign value to 1

Then Create 2 Text Object

1st Text Object -> Property-> Action -> add Two Action ->

1st Action is Select in Field -> insert Field Name and Value

2nd Action is External -> Set Variable -> Set Varaible Value=2

then Go to Layout ->Conditional ->if(vShow=1,1,0)

2nd Text Object -> Property-> Action -> add Two Action ->

1st Action is Clear Field -> insert Field Name

2nd Action is External -> Set Variable -> Set Varaible Value=1

then Go to Layout ->Conditional ->if(vShow=2,1,0)

then place both text object at same location.

You will acheive what you are expected.

Regards