topic Re: Using Cyclic groups in Expressions in QlikView

Using Cyclic groups in Expressions

arixooo123 — Mon, 14 Jul 2014 05:54:37 GMT

Hello Dear friends

I want to have a choice of selecting the columns in expressions.

to clarify, assume i have 3 columns speed, power, stamina in the table of Players. I like to see the trend of these 3 factors in just one line chart.

i use month field as the dimension of chart.(to see the trend in a year)

i created a cyclic group including the mentioned factors (speed, power, stamina) named FAC.

i like to see the cyclic group icon in chart and select one of the factors and see the trend of it.

is it even possible? if it's not, what alternatives do i have?

Re: Using Cyclic groups in Expressions

sujeetsingh — Mon, 14 Jul 2014 05:57:41 GMT

Follow this

How to get the Field Name form Cyclic Group?

Re: Using Cyclic groups in Expressions

sujeetsingh — Mon, 14 Jul 2014 05:58:08 GMT

This too

cycle through GROUPS of expressions on a chart........

Re: Using Cyclic groups in Expressions

lironbaram — Mon, 14 Jul 2014 06:06:19 GMT

the solution is quite simple

create a chart where year and player as the dimensions

and than create three expressions one for each factor

than group those expression together

have a look at the attach example

Re: Using Cyclic groups in Expressions

arixooo123 — Mon, 14 Jul 2014 06:21:17 GMT

Since i'm using the personal edition, i cant see your example, you see, i want to have just one line in chart, but that line should show the trend of the selected factor, so you're saying to do that i just need to group the three expressions?

then what? how to select just one of them?