topic Re: How to have multiple selections in cyclic groups in qlikview? in QlikView

How to have multiple selections in cyclic groups in qlikview?

Mon, 10 Feb 2014 05:30:26 GMT

I need to figure out a way to have multiple selections in cyclic groups that I have created.

Re: How to have multiple selections in cyclic groups in qlikview?

qlikpahadi07 — Mon, 10 Feb 2014 05:34:03 GMT

Please attach any sample

Re: How to have multiple selections in cyclic groups in qlikview?

vikasmahajan — Mon, 10 Feb 2014 05:51:55 GMT

Select Dimension-> Edit -> Select Cyclic group-> Add fields -> Field 1 Field 2 Field 3

This way you can add multiple fields in cyclic group.

Hope this help you.

Vikas

Re: How to have multiple selections in cyclic groups in qlikview?

Mon, 10 Feb 2014 06:21:18 GMT

Hi Srivastava,

Can you please elaborate little more on the questions. Below are my assumptions:

1) You can add multiple fields to the cyclic groups either from dimensions or from settings tab

2) If you select first dimension then it drills down to the second dimension which means it is providing the multi select already.

Please let me know if you are looking for anything different apart from this!

Thanks,

Sai

Re: How to have multiple selections in cyclic groups in qlikview?

Mon, 10 Feb 2014 06:21:25 GMT

Name	Parameter1	Parameter2	Parameter3	Parameter4	Parameter5	Parameter6	Parameter7	Parameter8	Parameter9
abc	a	a	a	x	a	x	a	a	x
def	b	b	b	y	b	y	b	b	y
ghi	c	c	z	c	z	c	z
jkl	d	d	d	d
Select parameter Set 1	(drop down list)		Select Parameter Set 2	(drop down list)
Parameter1			Parameter8
Parameter2			Parameter9
Parameter3
Parameter4
Parameter5
Parameter6
Parameter7

This is how my data set is. Now since the parameters are in columns, I have created a cyclic group containing two Parameter set(one containing first 7 parameters and the other containing remaining two). I wanted to select multiple values in parameter set 1 (from a drop down list ) and show all relevant values for selection in parameter set2. Is this possible in qlikview? Any kind of help is highly appreciated.

Re: Re: How to have multiple selections in cyclic groups in qlikview?

qlikpahadi07 — Mon, 10 Feb 2014 06:37:00 GMT

Yes you can if your data is properly mapped

see the attachment

Re: How to have multiple selections in cyclic groups in qlikview?

Mon, 10 Feb 2014 06:52:32 GMT

Thanks for your help guys.

So this is what my question is. Above you can see a pop up containing 4 parameters. It is a part of a cyclic group. Now, I want to have multiple selections in the group i.e.. I want to select for eg..Para1 and Para3 at same point and look at the numbers. I have got some 200 such parameters having all possible combinations.

Re: How to have multiple selections in cyclic groups in qlikview?

qlikpahadi07 — Mon, 10 Feb 2014 06:55:48 GMT

welcome

Re: How to have multiple selections in cyclic groups in qlikview?

Mon, 10 Feb 2014 11:13:47 GMT

Aruj,

Are you trying to look a distribution across 2 parameters at a time? Like

Para1 Para2 number_of_rows

a b 20

a a 40

Is this it?