topic Re: insert value in a table by Button in QlikView

insert value in a table by Button

Anonymous — Wed, 24 Dec 2014 11:17:44 GMT

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.

Re: insert value in a table by Button

rubenmarin — Wed, 24 Dec 2014 11:23:52 GMT

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

Re: insert value in a table by Button

sushil353 — Wed, 24 Dec 2014 11:25:07 GMT

Hi,

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

~Sushil

Re: insert value in a table by Button

ThornOfCrowns — Wed, 24 Dec 2014 11:27:55 GMT

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.

Re: insert value in a table by Button

Anonymous — Wed, 24 Dec 2014 11:38:09 GMT

Thanks your solution work (:

Re: insert value in a table by Button

Anonymous — Wed, 24 Dec 2014 11:46:13 GMT

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