topic Re: Column format-separating date gaps, slant labels in QlikView https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123440#M370031 <HTML><HEAD></HEAD><BODY><P>Those are good suggestions.&nbsp; I've updated my table in this way, and it is easier to read now.&nbsp; Thanks.</P></BODY></HTML> Mon, 06 Jun 2016 19:50:07 GMT 2016-06-06T19:50:07Z Column format-separating date gaps, slant labels https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123436#M370027 <HTML><HEAD></HEAD><BODY><P>I have a pivot table in Qlikview that has columns with daily results by [Completion Date].</P><P>1.&nbsp; Is there a way to format cells in Qlikview, similar to attached Excel example, where there will be a bold line to separate columns where there are gaps in dates (so users could easily define weekend breaks)?</P><P>2.&nbsp; Is there a way to have vertical column labels display at a <SPAN style="text-decoration: underline;">slant</SPAN>, similar to attached Excel example, instead of straight vertical headings which are harder to read?</P></BODY></HTML> Fri, 03 Jun 2016 12:45:12 GMT https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123436#M370027 2016-06-03T12:45:12Z Re: Column format-separating date gaps, slant labels https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123437#M370028 <HTML><HEAD></HEAD><BODY><P>I think you can achieve the same format except the slant label instead you can create vertical label</P></BODY></HTML> Fri, 03 Jun 2016 12:59:01 GMT https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123437#M370028 Kushal_Chawda 2016-06-03T12:59:01Z Re: Column format-separating date gaps, slant labels https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123438#M370029 <HTML><HEAD></HEAD><BODY><P>I do have true vertical labels in my Qlikview app (the Excel version I provided is just an export from Qlikview that I modified with the slant and with the bold lines in between the first few date breaks to show what I want to achieve).</P></BODY></HTML> Fri, 03 Jun 2016 13:04:45 GMT https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123438#M370029 2016-06-03T13:04:45Z Re: Column format-separating date gaps, slant labels https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123439#M370030 <HTML><HEAD></HEAD><BODY><P>The slant labels won't be possible but as an alternatively you could add further dimensions like week (maybe also month/year) which could separate the dates to a week (and/or month/year) and might you be able to short your date without year and monthnumber to a day-number which then could be displayed horizontally.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 03 Jun 2016 13:18:00 GMT https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123439#M370030 marcus_sommer 2016-06-03T13:18:00Z Re: Column format-separating date gaps, slant labels https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123440#M370031 <HTML><HEAD></HEAD><BODY><P>Those are good suggestions.&nbsp; I've updated my table in this way, and it is easier to read now.&nbsp; Thanks.</P></BODY></HTML> Mon, 06 Jun 2016 19:50:07 GMT https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123440#M370031 2016-06-06T19:50:07Z Re: Column format-separating date gaps, slant labels https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123441#M370032 <HTML><HEAD></HEAD><BODY><P>Hi Susan,</P><P></P><P>We're happy to see you got help with your question. Could you please take a moment to <A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A>?</P><P></P><P>Thank you,</P><P>Qlik Community Team</P></BODY></HTML> Mon, 06 Jun 2016 20:59:19 GMT https://community.qlik.com/t5/QlikView/Column-format-separating-date-gaps-slant-labels/m-p/1123441#M370032 Anonymous 2016-06-06T20:59:19Z