topic Re: how to get max(date) as a dimension in App Development https://community.qlik.com/t5/App-Development/how-to-get-max-date-as-a-dimension/m-p/1017610#M15243 <HTML><HEAD></HEAD><BODY><P>Date=Max(dates1) is saying invalid dimension</P><P>I have tried Date=today()-1 for previous day but it is not showing the tickets on that day instead showing full count..</P><P></P><P>I have a master calendar in the data model ... the join is b/w this table-&gt;Date and master calendar -&gt;Date</P></BODY></HTML> Fri, 12 Feb 2016 06:48:24 GMT 2016-02-12T06:48:24Z how to get max(date) as a dimension https://community.qlik.com/t5/App-Development/how-to-get-max-date-as-a-dimension/m-p/1017609#M15242 <HTML><HEAD></HEAD><BODY><P>I have table like this</P><P></P><P>how to plot a chart to get dimension is like max(date) or previous day and I have created measure like how many created and how many submitted</P><P></P><P>Thanks</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" height="545" style="color: rgb(102, 102, 102); font-family: Helvetica,Arial,sans-serif; font-size: 14px; font-style: normal; font-weight: normal; text-align: start; text-indent: 0px; height: 546px; width: 265px;"><TBODY><TR><TD height="26" style="font-family: arial, sans-serif; border: 0px solid black;" width="64">Ticket_no</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;" width="75">Date</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;" width="56">Status</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">1</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">1/27/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Created</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">1</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">1/28/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Modify</TD></TR><TR><TD align="right" height="24" style="font-family: arial, sans-serif; border: 0px solid black;">1</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">1/29/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">SUBMIT</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">1</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">2/2/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Closed</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">2</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">1/27/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Created</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">2</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">1/28/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Modify</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">2</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">1/29/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">SUBMIT</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">3</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">2/2/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Created</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">3</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">2/2/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Modify</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">3</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">8/8/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">SUBMIT</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">4</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">3/1/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Created</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">4</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">3/1/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Modify</TD></TR><TR><TD align="right" height="23" style="font-family: arial, sans-serif; border: 0px solid black;">5</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">8/8/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Created</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">5</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">8/8/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Modify</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">5</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">10/8/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">SUBMIT</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">6</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">8/9/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Created</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">6</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">8/9/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">Modify</TD></TR><TR><TD align="right" height="21" style="font-family: arial, sans-serif; border: 0px solid black;">6</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">10/8/2014</TD><TD style="font-family: arial, sans-serif; border: 0px solid black;">SUBMIT</TD></TR><TR><TD align="right" height="20" style="font-family: arial, sans-serif; border: 0px solid black;">6</TD><TD align="right" style="font-family: arial, sans-serif; border: 0px solid black;">11/11/2014&nbsp; </TD><TD>closed</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 12 Feb 2016 06:43:31 GMT https://community.qlik.com/t5/App-Development/how-to-get-max-date-as-a-dimension/m-p/1017609#M15242 2016-02-12T06:43:31Z Re: how to get max(date) as a dimension https://community.qlik.com/t5/App-Development/how-to-get-max-date-as-a-dimension/m-p/1017610#M15243 <HTML><HEAD></HEAD><BODY><P>Date=Max(dates1) is saying invalid dimension</P><P>I have tried Date=today()-1 for previous day but it is not showing the tickets on that day instead showing full count..</P><P></P><P>I have a master calendar in the data model ... the join is b/w this table-&gt;Date and master calendar -&gt;Date</P></BODY></HTML> Fri, 12 Feb 2016 06:48:24 GMT https://community.qlik.com/t5/App-Development/how-to-get-max-date-as-a-dimension/m-p/1017610#M15243 2016-02-12T06:48:24Z