insert value in a table by Button

[Anonymous]

Hi everyone, i'm new to QlikView and I need some help to solve my problem.

All I have to do is to insert a character (which can be S or N)  in the entire column of an existing table each time you press the button.

For example, at the beginning the column is blank, I press the button and puts all S. I press again and puts all N. And so on, the button alternates the S with N.

How can I do?

Any help is appreciated, and sorry if my English is not perfect.

Thanks for any help.

[rubenmarin · Accepted solution]

Hi Mattia,

In Config-->Variable panel, you can create a variable, in example: vSN.

In the button actions you can add an 'external'-->'set variable' action for the variable vSN and with the value:

=If(vSN='N', 'S', 'N')

Int he table you only need to add an expression with the variable name, like:

vSN

[sushil353]

Hi,

Can you describe your exact requirement.. why you want to change the entire column values alternately..?

~Sushil

[ThornOfCrowns]

Create a variable ( eg vToggle )

Create a button

Make the button action set variable to toggle between S and N ( eg If( vToggle = 'S','N','S') )

Put vToggle as a Calculated expression in your table.

It should now show the value of vToggle as a column.

[Anonymous]

Thanks your solution work (:

[Anonymous]

ok I try to explain in the best way.

I'm managing the awards related to sales and I must simply decide whether to validate all the awards (so S that stands for Yes) or deny them (so N that stands No). I hope it is clear