Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
ssriramin19
Contributor III
Contributor III

cyclic group

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

11 Replies
alexandros17
Partner - Champion III
Partner - Champion III

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

ssriramin19
Contributor III
Contributor III
Author

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

ssriramin19
Contributor III
Contributor III
Author

Please help at the earliest . This is quite urgent

alexandros17
Partner - Champion III
Partner - Champion III

Plese send your document

ssriramin19
Contributor III
Contributor III
Author

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

Vidit
Creator
Creator

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

ssriramin19
Contributor III
Contributor III
Author

Expression of final


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

please help

ssriramin19
Contributor III
Contributor III
Author

please anyone help me at the earliest .

this is quite urgent

ssriramin19
Contributor III
Contributor III
Author

please anyone provide the approach at the earliest