topic Show dimension values in a chart based a condition in QlikView https://community.qlik.com/t5/QlikView/Show-dimension-values-in-a-chart-based-a-condition/m-p/797127#M281594 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I have this chart that shows the evolution (by month) of evaluation (good, regular, bad) of projects. I have 32 projects but I only want to show values for a specific month if all the 32 projects have the evaluation. </P><P>Ex:</P><P>October - 32 projects evaluated</P><P>November - 32 projects evaluated</P><P>December - 10 projects evaluated</P><P></P><P>In my chart will be shown only October and November.</P><P></P><P>I tried using some aggregation in the Date dimension like this below, but didn't work.</P><P></P><P>=if(aggr(count(dat_evaluation_project),month_evaluation_project)=32 , date(dat_evaluation_project,'MMM/YY'))</P><P></P><P>Any ideas?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Fri, 21 Nov 2014 12:22:45 GMT 2014-11-21T12:22:45Z Show dimension values in a chart based a condition https://community.qlik.com/t5/QlikView/Show-dimension-values-in-a-chart-based-a-condition/m-p/797127#M281594 <HTML><HEAD></HEAD><BODY><P>Hi folks,</P><P></P><P>I have this chart that shows the evolution (by month) of evaluation (good, regular, bad) of projects. I have 32 projects but I only want to show values for a specific month if all the 32 projects have the evaluation. </P><P>Ex:</P><P>October - 32 projects evaluated</P><P>November - 32 projects evaluated</P><P>December - 10 projects evaluated</P><P></P><P>In my chart will be shown only October and November.</P><P></P><P>I tried using some aggregation in the Date dimension like this below, but didn't work.</P><P></P><P>=if(aggr(count(dat_evaluation_project),month_evaluation_project)=32 , date(dat_evaluation_project,'MMM/YY'))</P><P></P><P>Any ideas?</P><P></P><P>Thanks in advance.</P></BODY></HTML> Fri, 21 Nov 2014 12:22:45 GMT https://community.qlik.com/t5/QlikView/Show-dimension-values-in-a-chart-based-a-condition/m-p/797127#M281594 2014-11-21T12:22:45Z