topic Re: Create a dimension by grouping values in QlikView https://community.qlik.com/t5/QlikView/Create-a-dimension-by-grouping-values/m-p/374090#M1172839 <HTML><HEAD></HEAD><BODY><P>Magnus,</P><P></P><P>You need to created a calculated dimension like:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13409707232966270" jivemacro_uid="_13409707232966270"><P>If(NoOfDaysToResolveIssue&lt;=1,'In a day',if(NoOfDaysToResolveIssue&lt;=7,'Less Than a Week',if(NoOfDaysToResolveIssue&gt;7,'More than a weak','Yet to be resolved')</P></PRE><P></P><P>Add an expression as </P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13409707293508436" jivemacro_uid="_13409707293508436"><P>count(IssuesID)</P></PRE><P>.</P><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Fri, 29 Jun 2012 11:52:11 GMT 2012-06-29T11:52:11Z Create a dimension by grouping values https://community.qlik.com/t5/QlikView/Create-a-dimension-by-grouping-values/m-p/374089#M1172838 <HTML><HEAD></HEAD><BODY><P>I have a table with helpdesk issues and one of the fields is NoOfDaysToResolveIssue. I would like to create a bar chart with a dimension that showed how many issues were resolved in a day, in less than a week, in more than a week and issues not yet resolved, respectively. How do I do this in the best way? Should I create a dimension field when loading the table or in the Expressions tab?</P></BODY></HTML> Fri, 20 Nov 2020 18:02:30 GMT https://community.qlik.com/t5/QlikView/Create-a-dimension-by-grouping-values/m-p/374089#M1172838 2020-11-20T18:02:30Z Re: Create a dimension by grouping values https://community.qlik.com/t5/QlikView/Create-a-dimension-by-grouping-values/m-p/374090#M1172839 <HTML><HEAD></HEAD><BODY><P>Magnus,</P><P></P><P>You need to created a calculated dimension like:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13409707232966270" jivemacro_uid="_13409707232966270"><P>If(NoOfDaysToResolveIssue&lt;=1,'In a day',if(NoOfDaysToResolveIssue&lt;=7,'Less Than a Week',if(NoOfDaysToResolveIssue&gt;7,'More than a weak','Yet to be resolved')</P></PRE><P></P><P>Add an expression as </P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13409707293508436" jivemacro_uid="_13409707293508436"><P>count(IssuesID)</P></PRE><P>.</P><P></P><P>Regards,</P><P>Kiran Rokkam.</P></BODY></HTML> Fri, 29 Jun 2012 11:52:11 GMT https://community.qlik.com/t5/QlikView/Create-a-dimension-by-grouping-values/m-p/374090#M1172839 2012-06-29T11:52:11Z