topic AW:Variable in Diagram-Expression in QlikView

Variable in Diagram-Expression

Mon, 24 Aug 2009 21:47:59 GMT

hi,

is it possible to define an expression of an diagram as variable?

Variable in Diagram-Expression

Mon, 24 Aug 2009 22:25:51 GMT

Sorry, but I'm really not sure what you are asking here, what is it that you want to do? Can you post an example of a doc that's not working?

Cheers,

AW:Variable in Diagram-Expression

rbecher — Mon, 24 Aug 2009 23:06:02 GMT

..just store a formula in a variable or table.

Var1 = "=sum(value)"

- Ralf

AW:Variable in Diagram-Expression

Mon, 24 Aug 2009 23:18:22 GMT

See attached

1. I created a variable called vFormel which changes according to what you are selecting in the list box for Formel (check the variables in Settings, Variables). I then created another copy of your pivot which is using this variable.

2. I created a variable with =Sum(Wert) as the content and then created a further copy of your pivot that uses this variable.

Hope this helps,

AW:Variable in Diagram-Expression

rbecher — Mon, 24 Aug 2009 23:19:24 GMT

..did the wrong upload. Now the example is attached.

AW:Variable in Diagram-Expression

Mon, 24 Aug 2009 23:36:31 GMT

.....so now Im completely confused, it looks to me like you have it working!!

Can you explain what you need to do with this now?

AW:Re: AW:Variable in Diagram-Expression

rbecher — Tue, 25 Aug 2009 00:23:59 GMT

..two different approaches. In my example user can edit expression, in your example use can select it.

- Ralf

AW:Re: AW:Variable in Diagram-Expression

Tue, 25 Aug 2009 14:19:36 GMT

i've got a datatable like this:

id, group, value

1, a, 10

2, a, 5

3, a, 8

4, b, 1

5, b, 8.3

6, b, 0

in my diagram i wanna sum all values which are in group a and average all values in group b in the same column.

so the expression can look like this

if(group='a', sum(value), avg(value))

in my case i have many groups. so it would be fine to add a second datatable:

group, expresssion

a, sum(value)

b, avg(value)

and use the field "expression" to define the expression of the diagram.

AW:Re: AW:Re: AW:Variable in Diagram-Expression

rbecher — Tue, 25 Aug 2009 15:17:02 GMT

Frank,

I don't think it's possible to have different aggregation functions in one column.

- Ralf

AW:Re: AW:Re: AW:Variable in Diagram-Expression

johnw — Wed, 26 Aug 2009 02:45:33 GMT

You can have different aggregation functions in one column, and with the exact data and expression Frank mentioned.

AW:Re: AW:Re: AW:Re: AW:Variable in Diagram-Expression

rbecher — Wed, 26 Aug 2009 14:11:26 GMT

I know this is possible, but only by using the if( ) function. I meant you cannot store functions in a field (Formel) and then switch by associated value (Grp or Nr).

- Ralf