topic Re: Re: Show dimension values in a chart based a condition in QlikView https://community.qlik.com/t5/QlikView/Re-Show-dimension-values-in-a-chart-based-a-condition/m-p/797283#M281644 <HTML><HEAD></HEAD><BODY><P>Sorry, I branched it accidentally.</P><P></P><P>Unfortunately it didn't work. Here is a QVW with the chart I want to do.</P><P></P><P>Project 1 and 2 have the full evaluation for Jan-Mar and Project 3 has only evaluation for Jan and Feb. I'd like my chart shows only the dimensions Jan and Feb.</P><P></P><P>Thanks again.</P><P></P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>Ruben Marin wrote:</P> <P></P> <P>Hi, a llitle changes with aggr, and to assure only 1 date are retrieved per month:</P> <P>=aggr(if(count(dat_evaluation_project)=32, date(max(dat_evaluation_project),'MMM/YY')),month_evaluation_project)</P> <P style="min-height: 8pt; height: 8pt; padding: 0px;"></P> <P>Hope this helps</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE></BODY></HTML> Fri, 21 Nov 2014 13:09:06 GMT 2014-11-21T13:09:06Z Re: Show dimension values in a chart based a condition https://community.qlik.com/t5/QlikView/Re-Show-dimension-values-in-a-chart-based-a-condition/m-p/797282#M281643 <HTML><HEAD></HEAD><BODY><P>Hi, a llitle changes with aggr, and to assure only 1 date are retrieved per month:</P><P>=aggr(if(count(dat_evaluation_project)=32, date(max(dat_evaluation_project),'MMM/YY')),month_evaluation_project)</P><P></P><P>Hope this helps</P></BODY></HTML> Fri, 21 Nov 2014 12:32:01 GMT https://community.qlik.com/t5/QlikView/Re-Show-dimension-values-in-a-chart-based-a-condition/m-p/797282#M281643 rubenmarin 2014-11-21T12:32:01Z Re: Re: Show dimension values in a chart based a condition https://community.qlik.com/t5/QlikView/Re-Show-dimension-values-in-a-chart-based-a-condition/m-p/797283#M281644 <HTML><HEAD></HEAD><BODY><P>Sorry, I branched it accidentally.</P><P></P><P>Unfortunately it didn't work. Here is a QVW with the chart I want to do.</P><P></P><P>Project 1 and 2 have the full evaluation for Jan-Mar and Project 3 has only evaluation for Jan and Feb. I'd like my chart shows only the dimensions Jan and Feb.</P><P></P><P>Thanks again.</P><P></P><P></P><BLOCKQUOTE><TABLE border="1"><TBODY><TR><TD> <P>Ruben Marin wrote:</P> <P></P> <P>Hi, a llitle changes with aggr, and to assure only 1 date are retrieved per month:</P> <P>=aggr(if(count(dat_evaluation_project)=32, date(max(dat_evaluation_project),'MMM/YY')),month_evaluation_project)</P> <P style="min-height: 8pt; height: 8pt; padding: 0px;"></P> <P>Hope this helps</P> </TD></TR></TBODY></TABLE></BLOCKQUOTE></BODY></HTML> Fri, 21 Nov 2014 13:09:06 GMT https://community.qlik.com/t5/QlikView/Re-Show-dimension-values-in-a-chart-based-a-condition/m-p/797283#M281644 2014-11-21T13:09:06Z Re: Re: Re: Show dimension values in a chart based a condition https://community.qlik.com/t5/QlikView/Re-Show-dimension-values-in-a-chart-based-a-condition/m-p/797284#M281645 <HTML><HEAD></HEAD><BODY><P>Hi Gustavo, check attachment, I added a month field and a variable to assing max evaluations</P></BODY></HTML> Fri, 21 Nov 2014 13:17:09 GMT https://community.qlik.com/t5/QlikView/Re-Show-dimension-values-in-a-chart-based-a-condition/m-p/797284#M281645 rubenmarin 2014-11-21T13:17:09Z