topic Re: cyclic group in QlikView

cyclic group

ssriramin19 — Fri, 23 Jan 2015 08:31:33 GMT

My requirement is that I have created the cyclic group . Also I have three measure quanitity (actual ,sales and final). Requirement is that cyclic group should not be applied to actual but only to final and sales. But all the three measures needs to be dispalyed in one single straight table.

Can anyone please guide me on how to approach

Thanks

Re: cyclic group

alexandros17 — Fri, 23 Jan 2015 08:39:55 GMT

To manage dimensions in a cyclic Group use the function

getcurrentfield (GroupName)

With this finction you can take the selected dimension into thr Group and use it with an If condition to show or not the expression

Let me know

Re: cyclic group

ssriramin19 — Fri, 23 Jan 2015 08:49:32 GMT

I could able to use getcurrentfield (GroupName) but unable to use it in if condition so that only for certaion meaures cyclic group needs to be applied.

Please help

Re: cyclic group

ssriramin19 — Fri, 23 Jan 2015 08:56:41 GMT

Please help at the earliest . This is quite urgent

Re: cyclic group

alexandros17 — Fri, 23 Jan 2015 08:57:43 GMT

Plese send your document

Re: cyclic group

ssriramin19 — Fri, 23 Jan 2015 09:06:23 GMT

Please find the attached word document which has has the needed details . Since the size of the application is quite large I am unable to send it across here .

Thanks

Re: cyclic group

Vidit — Fri, 23 Jan 2015 09:16:53 GMT

You will have to use set analysis in teh expression used for Final.

it would be easier, if you could share the expressions you have used.

Regards

Vidit

Re: cyclic group

ssriramin19 — Fri, 23 Jan 2015 09:50:46 GMT

Expression of final

=if(count(ACTUAL),SUM(ACTUAL*Conf))

please help

Re: cyclic group

ssriramin19 — Fri, 23 Jan 2015 09:57:03 GMT

please anyone help me at the earliest .

this is quite urgent

Re: cyclic group

ssriramin19 — Fri, 23 Jan 2015 10:32:03 GMT

please anyone provide the approach at the earliest

Re: cyclic group

ssriramin19 — Fri, 23 Jan 2015 12:34:34 GMT

Please provide the solution for the above mentioned problem . this needs to be completed.

Re: cyclic group

Anonymous — Fri, 23 Jan 2015 13:02:08 GMT

Hi,

Try below code in expression tab – conditional text box for the Actual expression

GetCurrentField(CyclicGroupName) <> 'dimension'

Regards