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: 
QVUser1
Partner - Contributor III
Partner - Contributor III

Qlik Sense - Visualisation Chart

Hi Guys,

 I need one help while working with Table chart in Qlik sense . Where my output should be as following .

Where My Quarter, Year, COD ,BOD ,POD are my Expressions based on Classification as Inline Dimension.

Where Under Fiscal Year We need to have Quarter, Year and Under Demand We need to have COD,BOD ,POD

QVUser1_0-1608220389278.png

 



2 Solutions

Accepted Solutions
tm_burgers
Creator III
Creator III

I do not believe there is any way with a table in Qlik Sense to display as you expect here. You can't have the title row above the Classification row... with merged cells like that (not that I have ever seen). Though you could use a Pivot Table!

Is it the formatting you are struggling with, or creating the table itself with the values in the Correct Rows?

 

You wouldn't need to add your Classifications in an Inline table: just simply name your measure Columns as Quarter, Year, COD ,BOD ,POD. With the corresponding measures.

 

 

 

 

View solution in original post

QVUser1
Partner - Contributor III
Partner - Contributor III
Author

4 Replies
tm_burgers
Creator III
Creator III

I do not believe there is any way with a table in Qlik Sense to display as you expect here. You can't have the title row above the Classification row... with merged cells like that (not that I have ever seen). Though you could use a Pivot Table!

Is it the formatting you are struggling with, or creating the table itself with the values in the Correct Rows?

 

You wouldn't need to add your Classifications in an Inline table: just simply name your measure Columns as Quarter, Year, COD ,BOD ,POD. With the corresponding measures.

 

 

 

 

QVUser1
Partner - Contributor III
Partner - Contributor III
Author

Hi,

Can help  me in  doing this in Pivot Table .

Thanks for the reply

tm_burgers
Creator III
Creator III

Sure thing, 

 

In your Load Script add:

 

Classificiation:
LOAD * INLINE [
SEGMENT, CLASSIFICATION 
Fiscal Year, Quarter
Fiscal Year, Year
Demand, COD
Demand, BOD
Demand, POD
];

 

In your pivot table:

Row = CityDimension

Column1 = SEGMENT

Column2 = CLASSIFICATION

 

Then your measure is :

Pick(match(CLASSIFICATION,'Quarter','Year','COD','BOD','POD'),
'Your Quarter Measure',
'Your Year Measure',
'Your COD Measure',
'Your BOD Measure',
'Your POD Measure'
)

 

 

To adjust the order:

Sort by Segment Expression = match(SEGMENT,'Fiscal Year','Demand')

 

You can also color the columns (but not the headers); 

 

Measure Background Color :

pick(Match(SEGMENT,'Fiscal Year','Demand'),lightgreen(60),lightblue(60))

 

Should result in :

PivotTableExample.png

QVUser1
Partner - Contributor III
Partner - Contributor III
Author

Thank you