Qlik Sense: Cyclic Group in Straight Table

[pradnya_amol]

Hello All,

I have used Cyclic group in Straight table in QlikView. I want to build the similar chart in Qlik Sense. Can any one please tell me how to achieve it in Qlik Sense?

PFB the image for reference.

[pradnya_amol]

This don't create Cyclic but Calculated Dimension. Thanks but I tried this as well.

[Mounika4]

Hi Pradnya_amol,

i have the same problem,

i have Cyclic group in Straight table in QlikView. I want to build the similar chart in Qlik Sense. 

i used the pick match() but i could not see the  exact results

Did you achieved in qliksense ? if yes , please tell me how to achieve it in Qlik Sense?

[saso70]

Hi please check the example

[Mounika4]

Hi, When i am trying to open your attachment :i am getting like this 

[Mounika4]

i resolved it thanks for response

[Mounika4]

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

getting error like the dimesion is already in use

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