Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Thank you
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.
Hi,
Can help me in doing this in Pivot Table .
Thanks for the reply
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 :
Thank you