How to create a Grouped view for categories with Mini chart in QlikSense

[kaushi2020]

Hi All, 

I have a task to create a group based dimension where I will have to show a Mini chart for the 6 months trend analysis. 

is there any way we can create a table same as below ?

Categories	Line Items
Category-1	Line Item-1
	Line Item-2
	Line Item-3
	Line Item-4
Category-2	Line Item-5
	Line Item-6
	Line Item-7
	Line Item-8

[BartBrouwer]

Create a table, like

Load * inline [

Category, Line Items

Category-1, Line-Item-1

Category-1, Line-Item-2

Category-1, Line-Item-3

Category-1, Line-Item-4

Category-2, Line-Item-5

Category-2, Line-Item-6

Category-2, Line-Item-7

Category-2, Line-Item-8

];

[kaushi2020]

thanks for your reply, when we put this category in a table as dimension then it will show category name against each label. instead of a grouped one. 

[BartBrouwer]

Are you using a straight table or pivot table in which you use this dimension? You could try if you get your desired result with a pivot table. In a straight table you won't, I think. Furthermore, I am thinking the relationship between category and line items is actually hierarchical, isn't it? If this doesn't work maybe try using an hierarchical instead of inline load