topic dynamic formel in Chart by Deminsion in QlikView https://community.qlik.com/t5/QlikView/dynamic-formel-in-Chart-by-Deminsion/m-p/216038#M69438 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">Hi,</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">I have in the Chart (Diminsion)</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">=</P><P style="margin: 0cm 0cm 0pt;">if(count(distinct Calendar.Year)=1, date(Calendar.Date, 'MMM'), date(Calendar.Date, 'MMM-YYYY'</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">))</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">it doesn't work.</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">Thanks</P><P></P></BODY></HTML> Wed, 14 Oct 2009 21:24:26 GMT 2009-10-14T21:24:26Z dynamic formel in Chart by Deminsion https://community.qlik.com/t5/QlikView/dynamic-formel-in-Chart-by-Deminsion/m-p/216038#M69438 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">Hi,</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">I have in the Chart (Diminsion)</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">=</P><P style="margin: 0cm 0cm 0pt;">if(count(distinct Calendar.Year)=1, date(Calendar.Date, 'MMM'), date(Calendar.Date, 'MMM-YYYY'</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">))</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">it doesn't work.</P><P style="margin: 0cm 0cm 0pt; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto;">Thanks</P><P></P></BODY></HTML> Wed, 14 Oct 2009 21:24:26 GMT https://community.qlik.com/t5/QlikView/dynamic-formel-in-Chart-by-Deminsion/m-p/216038#M69438 2009-10-14T21:24:26Z