topic Re: Calculated Date Dimension in QlikView https://community.qlik.com/t5/QlikView/Calculated-Date-Dimension/m-p/1720855#M723828 <P>I need to have a calculated dimension only, as i have multiple expressions.</P><P>Thanks In advance.</P> Mon, 22 Jun 2020 12:15:34 GMT priya945 2020-06-22T12:15:34Z Calculated Date Dimension https://community.qlik.com/t5/QlikView/Calculated-Date-Dimension/m-p/1720848#M723826 <P>Hi All,</P><P>Please help to create a <STRONG>calculated dimension</STRONG> to restrict the data to only previous month from below data.</P><TABLE width="309"><TBODY><TR><TD width="103">ID</TD><TD width="103">Date</TD><TD width="103">value</TD></TR><TR><TD>377</TD><TD>3/17/2020</TD><TD>5</TD></TR><TR><TD>447</TD><TD>4/13/2020</TD><TD>5</TD></TR><TR><TD>534</TD><TD>3/19/2020</TD><TD>5</TD></TR><TR><TD>259</TD><TD>3/12/2020</TD><TD>5</TD></TR><TR><TD>129</TD><TD>4/7/2020</TD><TD>5</TD></TR><TR><TD>346</TD><TD>4/8/2020</TD><TD>3</TD></TR><TR><TD>342</TD><TD>5/26/2020</TD><TD>5</TD></TR><TR><TD>353</TD><TD>5/23/2020</TD><TD>5</TD></TR><TR><TD>434</TD><TD>6/1/2020</TD><TD>4</TD></TR></TBODY></TABLE><P>Result:</P><TABLE width="309"><TBODY><TR><TD width="103">ID</TD><TD width="103">Date</TD><TD width="103">value</TD></TR><TR><TD>342</TD><TD>5/26/2020</TD><TD>5</TD></TR><TR><TD>353</TD><TD>5/23/2020</TD><TD>5</TD></TR></TBODY></TABLE><P>Thanks in advance.</P> Sat, 16 Nov 2024 18:27:33 GMT https://community.qlik.com/t5/QlikView/Calculated-Date-Dimension/m-p/1720848#M723826 priya945 2024-11-16T18:27:33Z Re: Calculated Date Dimension https://community.qlik.com/t5/QlikView/Calculated-Date-Dimension/m-p/1720852#M723827 <P>Do you really want a calculated dimension?</P><P>Why not using Set analysis in expression?</P> Mon, 22 Jun 2020 12:07:34 GMT https://community.qlik.com/t5/QlikView/Calculated-Date-Dimension/m-p/1720852#M723827 MindaugasBacius 2020-06-22T12:07:34Z Re: Calculated Date Dimension https://community.qlik.com/t5/QlikView/Calculated-Date-Dimension/m-p/1720855#M723828 <P>I need to have a calculated dimension only, as i have multiple expressions.</P><P>Thanks In advance.</P> Mon, 22 Jun 2020 12:15:34 GMT https://community.qlik.com/t5/QlikView/Calculated-Date-Dimension/m-p/1720855#M723828 priya945 2020-06-22T12:15:34Z