topic Re: display variable outcome in each row. in QlikView

display variable outcome in each row.

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

Name Total goal Avg Goal

Ronaldo 10( variable returns that value) 40 ( variable returns that value)

Messi 5( variable returns that value) 41( variable returns that value)

etc,,,,

all goal and avg goal is calculate by variable in each row ....what kind of object that i have to use to get this value to display and how

thanks,,

Re: display variable outcome in each row.

trdandamudi — Tue, 17 May 2016 23:56:43 GMT

Can you please share some sample data along with expected output....

Re: display variable outcome in each row.

everest226 — Wed, 18 May 2016 00:44:37 GMT

its just a concept that i am working on.is it possible.

Re: display variable outcome in each row.

sunny_talwar — Wed, 18 May 2016 01:01:39 GMT

I guess we are not sure what you envision, can you try to put your vision down on Excel?

Re: display variable outcome in each row.

everest226 — Wed, 18 May 2016 03:51:54 GMT

the requirement is that i have a 10 student names in one column and other two column are there averages of total book read and other is total class average which is also set by variable . i am trying to create object which is readable only .

Re: display variable outcome in each row.

SunilChauhan — Wed, 18 May 2016 04:59:31 GMT

Create two variable with set expression. provide Calculation logic in it

and in table expression right using $ sign for both variable

Re: display variable outcome in each row.

ankit777 — Wed, 18 May 2016 05:23:19 GMT

Its possible.

Create both variable and write your expression without preceding '='

Now use this variable in your chart expression as =$(Variable)

To display data like shown above use a Straight table.

This should work.

Re: display variable outcome in each row.

Kushal_Chawda — Wed, 18 May 2016 05:40:15 GMT

You need to use Synthetic dimension

create straight table

Dimension:

=valuelist('Ronaldo','Messi')

Expression:

1) Total Goal

= Pick( match(valuelist('Ronaldo','Messi'),'Ronaldo','Messi'),

$(VariableForRonaldo),$(VariableForMessi))

1) Avg Goal

= Pick( match(valuelist('Ronaldo','Messi'),'Ronaldo','Messi'),

$(VariableForRonaldo),$(VariableForMessi))

Re: display variable outcome in each row.

tresB — Wed, 18 May 2016 07:14:09 GMT

Is your emphasis on

Ujjwal kc wrote:

.....object which is readable only .

If so, you could create a straight table and make it read-only by checking 'Read Only' in general tab of the chart.

Re: display variable outcome in each row.

everest226 — Wed, 18 May 2016 18:21:58 GMT

Thanks Kushal

could you please elaborate on the expression for total goal and average goals???

Expression:

1) Total Goal

= Pick( match(valuelist('Ronaldo','Messi'),'Ronaldo','Messi'),

$(VariableForRonaldo),$(VariableForMessi))

1) Avg Goal

= Pick( match(valuelist('Ronaldo','Messi'),'Ronaldo','Messi'),

$(VariableForRonaldo),$(VariableForMessi))

I dont get the variable part???

Re: display variable outcome in each row.

Kushal_Chawda — Thu, 19 May 2016 05:45:25 GMT

Pick function picking up values from match function and assigning corresponding values from variable to that picked value.