topic Re: year expression in QlikView https://community.qlik.com/t5/QlikView/year-expression/m-p/1281681#M860834 <HTML><HEAD></HEAD><BODY><P>Not sure I follow your question... can you reframe your question?</P></BODY></HTML> Fri, 06 Jan 2017 01:10:23 GMT sunny_talwar 2017-01-06T01:10:23Z year expression https://community.qlik.com/t5/QlikView/year-expression/m-p/1281678#M860831 <HTML><HEAD></HEAD><BODY><P>hi i am new to qlik</P><P>i have following expression,&nbsp; how can i modify that expression for 2016 and 2016 dec</P><P></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Count (DISTINCT [Real user])</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">i want two expression </SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1 for 2016 only ( all data of 2016)</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">2 for </SPAN>December<SPAN style="font-size: 10pt; line-height: 1.5em;"> 2016 ( only data of dec 2016)</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Thanks<BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/year-expression/m-p/1281678#M860831 2020-11-25T16:16:04Z Re: year expression https://community.qlik.com/t5/QlikView/year-expression/m-p/1281679#M860832 <HTML><HEAD></HEAD><BODY><P>1) <STRONG>Count({&lt;Year = {2016}&gt;} DISTINCT [Real user])</STRONG></P><P></P><P>2) <SPAN style="font-size: 13.3333px;"><STRONG>Count({&lt;Year = {2016}, Month = {'Dec''}&gt;} DISTINCT [Real user])</STRONG></SPAN></P></BODY></HTML> Thu, 05 Jan 2017 18:59:48 GMT https://community.qlik.com/t5/QlikView/year-expression/m-p/1281679#M860832 sunny_talwar 2017-01-05T18:59:48Z Re: year expression https://community.qlik.com/t5/QlikView/year-expression/m-p/1281680#M860833 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 13.3333px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #edf8ca;">Count({&lt;Year = {2016}, Month = {'Dec''}&gt;} DISTINCT [Real user])</STRONG></P><P></P><P>what what if i want to capture distinct&nbsp; real user in 2016 whichever months that has higher </P></BODY></HTML> Thu, 05 Jan 2017 23:56:53 GMT https://community.qlik.com/t5/QlikView/year-expression/m-p/1281680#M860833 2017-01-05T23:56:53Z Re: year expression https://community.qlik.com/t5/QlikView/year-expression/m-p/1281681#M860834 <HTML><HEAD></HEAD><BODY><P>Not sure I follow your question... can you reframe your question?</P></BODY></HTML> Fri, 06 Jan 2017 01:10:23 GMT https://community.qlik.com/t5/QlikView/year-expression/m-p/1281681#M860834 sunny_talwar 2017-01-06T01:10:23Z