topic Re: getting variable values in QlikView

getting variable values

becki_kain — Wed, 25 Nov 2020 16:16:04 GMT

hello:

i'm setting some variables, in the variable expression box, and like to see the value of all of them, in one place. It seems i can't do a text box with just

=var1

=var2

in it, to see them all. is there another way to see all variables which are set, and as they change? these are not variables set in the load script since they are based on user input.

thanks

becki kain

Re: getting variable values

m_woolf — Tue, 10 Oct 2017 20:04:38 GMT

Use an Input box

Re: getting variable values

vishsaggi — Tue, 10 Oct 2017 20:09:22 GMT

Can you explain a little. Use like = var1 & Chr(13) &var2

Re: getting variable values

becki_kain — Tue, 10 Oct 2017 21:20:51 GMT

sorry, so i'm setting a bunch of variables instead making (columns) expressions like :

v_total_sales1 = sum (total sales volume for time period 1)

(pseudo code of course)

v_total_sales2 = sum (total sales volume for time period 2)

v_seg_sales = seg_sales/v_total_sales1

the time periods are selected by the user, from a drop down. is there a way of having a box or something that lists all variables, which are set, each time the user changes the time period times?

Re: getting variable values

trdandamudi — Tue, 10 Oct 2017 21:29:09 GMT

Nagaraju code mentioned above will do exactly what you need. Try it out...

In a text box type as below:

= v_total_sales1 Chr(13)

&v_total_sales2 Chr(13)

&v_seg_sales

Re: getting variable values

vishsaggi — Tue, 10 Oct 2017 22:33:54 GMT

Did you try the way i mentioned in my previous response. Can i know how exactly your variables defined?

Using Ctrl+ALt+V add variables with their relevant expressions while copying expressions use = equals to sign. Then

in your text box add those variables.

= Var1& Chr(13) &var1 & Chr(13) &var2

Re: getting variable values

rwunderlich — Wed, 11 Oct 2017 01:37:19 GMT

As mw suggested, use an Input Box object. On the General tab, add each variable you want to see.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: getting variable values

becki_kain — Wed, 11 Oct 2017 13:33:40 GMT

thank you! I was making this harder than it really had to be! when you said "input box" I thought of user input, which I already have, not using it for display. thanks!