Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi,
Can you describe your exact requirement.. why you want to change the entire column values alternately..?
~Sushil
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.
Thanks your solution work (:
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