Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

insert value in a table by Button

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.

1 Solution

Accepted Solutions
rubenmarin

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

View solution in original post

5 Replies
rubenmarin

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
Master II
Master II

Hi,

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

~Sushil

ThornOfCrowns
Specialist II
Specialist II

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
Not applicable
Author

Thanks your solution work (:

Anonymous
Not applicable
Author

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