Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
felisema
New Contributor III

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

Re: insert value in a table by Button

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

5 Replies

Re: insert value in a table by Button

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
Honored Contributor II

Re: insert value in a table by Button

Hi,

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

~Sushil

thornofcrowns
Valued Contributor II

Re: insert value in a table by Button

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.

felisema
New Contributor III

Re: insert value in a table by Button

Thanks your solution work (:

felisema
New Contributor III

Re: insert value in a table by Button

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

Community Browser