Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
arixooo123
Contributor II

Using Cyclic groups in Expressions

    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?

Tags (3)
1 Solution

Accepted Solutions
Partner
Partner

Re: Using Cyclic groups in Expressions

hi

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

View solution in original post

4 Replies
sujeetsingh
Honored Contributor III

Re: Using Cyclic groups in Expressions

sujeetsingh
Honored Contributor III

Re: Using Cyclic groups in Expressions

Partner
Partner

Re: Using Cyclic groups in Expressions

hi

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

View solution in original post

arixooo123
Contributor II

Re: Using Cyclic groups in Expressions

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?