Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pathiqvd
Creator III
Creator III

Cyclic Group in Qliksense

Hi I need to create cyclic group in Qliksense without using any extensions.Is it Possible?

17 Replies
Not applicable

Nice ..Useful

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Thanks Rohit for sharing this link to my blog post.

stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

Thanks Arul for sharing this link to my Community post.

shivam0703
Contributor III
Contributor III

how u did that???

Koniki
Contributor II
Contributor II

how can you  create a new cyclic  without alternate dimension and measure,

and without  extension 

 

Mounika4
Contributor III
Contributor III

Hi Pathiqvd,

i tried your above example for cyclic dimension in qliksense , its working as expected 

I loaded the inline  table and I wrote dimension like: $(=If(GetSelectedCount(FiledNames)=0,'Region',Only(FiledNames)))

what did you give the label name here: ? do i need to create any variable after loading inline table?

Mounika4_0-1678959348350.png

 

 

Mounika4
Contributor III
Contributor III

Yeah its working as expected Thank you Pathiqvd

 

Mounika4
Contributor III
Contributor III

Yeah its working good in pivot table in qliksense,but issue was if loaded 2 cyclic groups in scripts liks

Cycle1:

load *inline[ 

FieldNames

Region

plant

Grade

Commodity

......

after i wrote in dimension like  =$(=If(GetSelectedCount(FieldNames)=0,'Region',Only(FieldNames)))

nd taken filter as FieldNames

Next i loaded 2 cyclic group table

 

Cycle2:

load *inline[

Fields

ABC

Grade

Commodity

......

after i wrote in dimension like  =$(=If(GetSelectedCount(Fields)=0,'Commodity',Only(Fields)))

filter i taken as Fields

=======but here==

if i select Commodity in the FiledNames filter ..the chart getting like below snap

Mounika4_0-1678976588438.png

getting error like the dimesion is already in use

Mounika4_1-1678976721874.png

 

Grade field also having both the tables but if i select commodity in  1st filter and region in second filter i am this issue

 

please anyone help me on this