topic Adding expressions to cyclic group in QlikView

Adding expressions to cyclic group

Thu, 04 Nov 2010 16:10:35 GMT

I'm trying to add the following expression to a cyclic group:

=If( Sum(Variable1)=0 , 0 , Sum(Variable1))

I keep getting an error in the straight table saying "// Error in calculated dimension"

If i want to cycle between 2 expressions is this the best way to do it? Thanks.

Adding expressions to cyclic group

stephencredmond — Thu, 04 Nov 2010 16:13:25 GMT

Hi,

If you want to cycle between two expressions, as opposed to 2 dimensions, just add the 2 expressions and then "Group" them (use the "Group" button or just drag one onto the other).

Regards,

Stephen

Adding expressions to cyclic group

Thu, 04 Nov 2010 16:24:48 GMT

Wow never even saw that group option in the expressions tab. Thanks Stephen. It's really weird that they let you add a group with expressions in it to the dimensions tab. Design fail? Anyways, thanks again.

Adding expressions to cyclic group

stephencredmond — Thu, 04 Nov 2010 16:45:44 GMT

Well, you can add correctly functioning expressions as dimensions so it is not so much a design failure as just a problem with the wrong expression - nothing that QlikView can do about that!

😉

Stephen

Adding expressions to cyclic group

Thu, 24 Mar 2011 14:49:03 GMT

I have done the grouping but what I would like to do, but don't see how to, is to re-use that group of metrics for other charts. Is there a way to do that like you can with creating groups of dimensions?

Thanks!

Adding expressions to cyclic group

Thu, 24 Mar 2011 15:02:11 GMT

As Stephen mentioned in the reply above yours, you can add expressions as dimensions. So you can add expressions in the dimension Groups as well. Then you can use these groups in other charts/tables.

Besides this I don't think you can save grouped expressions.