Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
sharu055
Creator
Creator

How to implement Cyclic Group in Qliksense as Qlikview in Table Chart

Hi,

Am migrating qlikview dashboard to qliksense and i have one table chart with cyclic group. I created cyclic group dimension in qliksense and after adding the dimension am not able to see that cyclic dropdown in qliksense only one field is visible. Please help to fix this issue.

Qlikview chart:

sharu055_3-1759951154110.png

 

 

Labels (5)
2 Solutions

Accepted Solutions
mikaelsc
Specialist
Specialist

use the new straight table 

mikaelsc_0-1759952264189.png

 

View solution in original post

Amit_Prajapati
Creator II
Creator II

Hi @sharu055, If you're working with the new straight table, that option is available by default. However, if you're using the older table, you can create a filter using a cyclic dimension. This will display the cyclic selection icon, allowing similar functionality.

Amit_Prajapati_0-1760416828023.png

Amit_Prajapati_1-1760417063717.png

 

 

View solution in original post

13 Replies
mikaelsc
Specialist
Specialist

use the new straight table 

mikaelsc_0-1759952264189.png

 

sharu055
Creator
Creator
Author

I don't find the straight table in Chart selection in my Qliksense.

Amit_Prajapati
Creator II
Creator II

Hi @sharu055 ,
Please ensure you're working in Qlik SaaS, as the straight table visualization is not available in Qlik Enterprise.

Amit_Prajapati_0-1760009267642.png

 

sharu055
Creator
Creator
Author

Hi @Amit_Prajapati ,

Thanks for the response, i can see only below charts am am using Web based Qiksense version. Could you please help how to achieve cyclic group in Table chart. Dont find Straight table

sharu055_0-1760015210449.png

 

mikaelsc
Specialist
Specialist

mikaelsc_0-1760021942794.png

custom objects -> qlik viz bundle

ensure you have a quite recent version

 

sharu055
Creator
Creator
Author

@mikaelsc Thanks, i can see the straight table in viz bundle but not finding how to add the expression. 

Amit_Prajapati
Creator II
Creator II

Hi @sharu055 , To create a cyclic dimension, first make a Master Dimension.

Amit_Prajapati_1-1760071437706.png

 

sharu055
Creator
Creator
Author

Hi @Amit_Prajapati  I created the Master Dimension filed with 5 Different fields. But when i added as dimension in chart its not showing cyclic symbol not even changing the dimension values.

Please can you help with screen shot of adding Master Dimension to Straight table and steps

 

Amit_Prajapati
Creator II
Creator II

Hi @sharu055 , 

 

  • Create a master dimension and set it up as a cyclic group with the desired fields.

  • Build a chart, select the cyclic dimension as your dimension, and add the appropriate measure to visualize the data.

 

Amit_Prajapati_0-1760352838039.png

2. Then create a chart a use it as dimetion and add measure.

Amit_Prajapati_1-1760352888010.png