topic Re: Copy values in another column in QlikView

Copy values in another column

Anonymous — Mon, 29 Dec 2014 09:50:30 GMT

hello guys i need your help once again. I'm still new in the world QlikView so be patient :).

I start to explain my problem.

I have a table with several columns with different data inside them, all I have to do (I do not know if it possible) is to copy the contents of a column in another column by pressing a button.

Thank you again for any help and if something is not clear feel free to ask.

Re: Copy values in another column

francoiscave — Mon, 29 Dec 2014 10:02:56 GMT

Hi Mattia,

If I understand well your issue,

You can use a condirional exprexion in your chart (with a variable and a button):

François

Re: Copy values in another column

Anonymous — Mon, 29 Dec 2014 10:14:31 GMT

my problem is the expression. I don't really know how to write it and how to set the button.

Re: Copy values in another column

francoiscave — Mon, 29 Dec 2014 10:25:13 GMT

Mattia,

See the attached file...

It is what do you expect ?

François

Re: Copy values in another column

Anonymous — Mon, 29 Dec 2014 10:42:15 GMT

I can truly say that it is almost what I need. the only thing is that the column should always be present and not disappear and reappear when I press the button. anyway thanks!

Re: Copy values in another column

francoiscave — Mon, 29 Dec 2014 10:47:41 GMT

Mattia,

It's better like this ?

François

Re: Copy values in another column

Anonymous — Mon, 29 Dec 2014 10:58:35 GMT

ok I made a small change. Unchecking the conditional, the column does not disappear. Now I try to adapt this on my work. Thank you, I will let you know if it works (:

Re: Copy values in another column

francoiscave — Mon, 29 Dec 2014 11:09:21 GMT

Mattia,

I hope it will help you !

If you need some more help, post your app.

If you are satisfied, mark a response as correct or helpfull to close this thread.

Thanks,

Have fun with QV and happy new year !

François

Re: Copy values in another column

Anonymous — Mon, 29 Dec 2014 11:27:35 GMT

François it works!!!!! thank you so much!!!!!!!!

Edit.

you can bring the data into the new column without making any changes? I do not need to average but only copy them, what function can I use? This because the data that I'll get are numeric with decimals

Re: Copy values in another column

Anonymous — Mon, 29 Dec 2014 12:14:17 GMT

Not an issue you can just you can just replace =avg(Code) to only = Code