topic How to make sub-headings? in App Development https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360140#M30488 <HTML><HEAD></HEAD><BODY><P>Hello everyone!</P><P></P><P>How can i divide my measures by 2 big columns?</P><P>So i got this: </P><P></P><P><IMG alt="в33йцвау3в.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163686_в33йцвау3в.png" style="height: 203px; width: 620px;" /></P><P>And i want to sub-heading my measures over with red lines in 2 sub-columns like this:</P><P></P><P><IMG alt="32r23r.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/163687_32r23r.png" style="height: 191px; width: 620px;" /></P></BODY></HTML> Wed, 17 May 2017 10:25:49 GMT Vasiliy_Beshentsev 2017-05-17T10:25:49Z How to make sub-headings? https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360140#M30488 <HTML><HEAD></HEAD><BODY><P>Hello everyone!</P><P></P><P>How can i divide my measures by 2 big columns?</P><P>So i got this: </P><P></P><P><IMG alt="в33йцвау3в.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163686_в33йцвау3в.png" style="height: 203px; width: 620px;" /></P><P>And i want to sub-heading my measures over with red lines in 2 sub-columns like this:</P><P></P><P><IMG alt="32r23r.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/163687_32r23r.png" style="height: 191px; width: 620px;" /></P></BODY></HTML> Wed, 17 May 2017 10:25:49 GMT https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360140#M30488 Vasiliy_Beshentsev 2017-05-17T10:25:49Z Re: How to make sub-headings? https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360141#M30489 <HTML><HEAD></HEAD><BODY><P>You might get the grouping from the data model and drag both the Dimenion into the Column part of Pivot. QS will then group both of them and show the the grouped column with a + sign which you can click to see the underlying values (25,30,35....etc)</P><P></P><P>Screen1:</P><P><IMG alt="Screen1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/163707_Screen1.PNG" style="height: 102px; width: 620px;" /></P><P></P><P>Screen2:</P><P><IMG alt="Screen2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/163708_Screen2.PNG" style="height: 92px; width: 620px;" /></P></BODY></HTML> Wed, 17 May 2017 12:16:24 GMT https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360141#M30489 ansarikashif2017 2017-05-17T12:16:24Z Re: How to make sub-headings? https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360142#M30490 <HTML><HEAD></HEAD><BODY><P>I can't do like that because my measures self-maked in expressions.</P></BODY></HTML> Wed, 24 May 2017 06:34:14 GMT https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360142#M30490 Vasiliy_Beshentsev 2017-05-24T06:34:14Z Re: How to make sub-headings? https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360143#M30491 <HTML><HEAD></HEAD><BODY><P>It's possible way only if i make measures in load data script.</P></BODY></HTML> Wed, 24 May 2017 06:35:10 GMT https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360143#M30491 Vasiliy_Beshentsev 2017-05-24T06:35:10Z Re: How to make sub-headings? https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360144#M30492 <HTML><HEAD></HEAD><BODY><P>Are the columns in the pivot table dynamic i.e. can the value in the series 25 30 35...60 increase further or it will remain the same?</P><P></P><P>If they remain the same, probably in some way you can use the same expression which calculates the measure value to construct a dimension which retruns string such as "25", "30", "35"....."0","5","10"...etc</P></BODY></HTML> Tue, 30 May 2017 15:44:35 GMT https://community.qlik.com/t5/App-Development/How-to-make-sub-headings/m-p/1360144#M30492 ansarikashif2017 2017-05-30T15:44:35Z