topic Re: Group Help in QlikView

Group Help

VishalWaghole — Sun, 11 Aug 2013 05:13:18 GMT

Hi Community

I have one pivot table containg Dimension as one Cyclic Group.

Cyclic Group having 3 Fields.

My requirment is, The field which i select such fields get store into one variable.

I tried it by GetCurrentField() function by passing Group Name but it didnt work.

So Please Help me......

Thanks

Re: Group Help

Gysbert_Wassenaar — Sun, 11 Aug 2013 09:08:43 GMT

Your requirement is not clear to me.

If you want to store the name of the current field in the cycle group in a variable you can use the getcurrentfield function. For example a variable vField: =getcurrentfield(MyGroupNameHere).

If you want to store a list of dimension values of the current field in the cycle group in a variable you can try this:

vField: =getcurrentfield(MyGroupNameHere)

vFieldValues: =concat(distinct $(vField) ,',')

or vFieldValues: =concat(distinct $(=getcurrentfield(MyGroupNameHere)) ,',')

Re: Group Help

VishalWaghole — Sun, 11 Aug 2013 09:23:47 GMT

Hi gysbert thanks for ur rpl...

I have one cyclic group which contain three dimensions

Number1

Nymber2

And

Number3

If i select Number1 then variable store the field as number1 but not the field values.

Similar to Number2 and Number3

How can i achive this task..??

Thansk..

Re: Group Help

VishalWaghole — Sun, 11 Aug 2013 12:42:02 GMT

I tried it by using

=getcurrentfield(MyGroupNameHere)

this but it wont work..

PFA here

Re: Group Help

Gysbert_Wassenaar — Sun, 11 Aug 2013 18:36:26 GMT

See attached qvw