topic urgent: dynamic age range in QlikView https://community.qlik.com/t5/QlikView/urgent-dynamic-age-range/m-p/390176#M565711 <HTML><HEAD></HEAD><BODY><P>Dear QV-users,</P><P></P><P>I want to combine two dimensions. </P><P><IMG __jive_id="28415" class="jive-image-thumbnail jive-image" onclick="" alt="Slider_!.png" src="https://community.qlik.com/legacyfs/online/28415_Slider_!.png" width="450" /></P><P>This graph (number per age) has a calculated dimension:</P><P>= <SPAN style="color: #0000ff; font-size: 12pt;">class</SPAN><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">floor</SPAN><SPAN style="font-size: 12pt;">((</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Today</SPAN><SPAN style="font-size: 12pt;">()-</SPAN><SPAN style="color: #800000; font-size: 12pt;">Geboortedatum</SPAN><SPAN style="font-size: 12pt;">)/365.25),</SPAN><STRONG><EM style=": ; color: #808080; font-size: 12pt;">$(AgeRange)</EM></STRONG><SPAN style="font-size: 12pt;">,'Age')&nbsp; </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Geboortedatum = Date of birth</SPAN></P><P><SPAN style="font-size: 12pt;"><IMG __jive_id="28416" class="jive-image-thumbnail jive-image" onclick="" alt="Slider_2.png" src="https://community.qlik.com/legacyfs/online/28416_Slider_2.png" width="450" /></SPAN></P><P><SPAN style="font-size: 12pt;">This graph has a calculated dimension:</SPAN></P><P>=<SPAN style="color: #800000; font-size: 12pt;">Jaar</SPAN><SPAN style="font-size: 12pt;">-</SPAN><SPAN style="color: #800000; font-size: 12pt;">Geboortejaar </SPAN></P><P></P><P><SPAN style="color: #800000; font-size: 12pt;">Jaar = Year</SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;">Geboortejaar = Year of birth</SPAN></P><P></P><P><SPAN style="color: #800000; font-size: 12pt;">I would like to combine those two calculated dimensions into <SPAN style="font-size: 14pt;">ONE <SPAN style="font-size: 12pt;">dimension within <SPAN style="font-size: 14pt;">ONE </SPAN></SPAN></SPAN></SPAN><SPAN style="color: #800000; font-size: 14pt;"><SPAN>graph</SPAN></SPAN></P><P></P></BODY></HTML> Thu, 03 Jan 2013 12:37:31 GMT shahamel 2013-01-03T12:37:31Z urgent: dynamic age range https://community.qlik.com/t5/QlikView/urgent-dynamic-age-range/m-p/390176#M565711 <HTML><HEAD></HEAD><BODY><P>Dear QV-users,</P><P></P><P>I want to combine two dimensions. </P><P><IMG __jive_id="28415" class="jive-image-thumbnail jive-image" onclick="" alt="Slider_!.png" src="https://community.qlik.com/legacyfs/online/28415_Slider_!.png" width="450" /></P><P>This graph (number per age) has a calculated dimension:</P><P>= <SPAN style="color: #0000ff; font-size: 12pt;">class</SPAN><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">floor</SPAN><SPAN style="font-size: 12pt;">((</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">Today</SPAN><SPAN style="font-size: 12pt;">()-</SPAN><SPAN style="color: #800000; font-size: 12pt;">Geboortedatum</SPAN><SPAN style="font-size: 12pt;">)/365.25),</SPAN><STRONG><EM style=": ; color: #808080; font-size: 12pt;">$(AgeRange)</EM></STRONG><SPAN style="font-size: 12pt;">,'Age')&nbsp; </SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Geboortedatum = Date of birth</SPAN></P><P><SPAN style="font-size: 12pt;"><IMG __jive_id="28416" class="jive-image-thumbnail jive-image" onclick="" alt="Slider_2.png" src="https://community.qlik.com/legacyfs/online/28416_Slider_2.png" width="450" /></SPAN></P><P><SPAN style="font-size: 12pt;">This graph has a calculated dimension:</SPAN></P><P>=<SPAN style="color: #800000; font-size: 12pt;">Jaar</SPAN><SPAN style="font-size: 12pt;">-</SPAN><SPAN style="color: #800000; font-size: 12pt;">Geboortejaar </SPAN></P><P></P><P><SPAN style="color: #800000; font-size: 12pt;">Jaar = Year</SPAN></P><P><SPAN style="color: #800000; font-size: 12pt;">Geboortejaar = Year of birth</SPAN></P><P></P><P><SPAN style="color: #800000; font-size: 12pt;">I would like to combine those two calculated dimensions into <SPAN style="font-size: 14pt;">ONE <SPAN style="font-size: 12pt;">dimension within <SPAN style="font-size: 14pt;">ONE </SPAN></SPAN></SPAN></SPAN><SPAN style="color: #800000; font-size: 14pt;"><SPAN>graph</SPAN></SPAN></P><P></P></BODY></HTML> Thu, 03 Jan 2013 12:37:31 GMT https://community.qlik.com/t5/QlikView/urgent-dynamic-age-range/m-p/390176#M565711 shahamel 2013-01-03T12:37:31Z Re: urgent: dynamic age range https://community.qlik.com/t5/QlikView/urgent-dynamic-age-range/m-p/390177#M565712 <HTML><HEAD></HEAD><BODY><P>=</P><P><SPAN style="color: #0000ff; font-size: 12pt;">class</SPAN><SPAN style="font-size: 12pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 12pt;">floor</SPAN><SPAN style="font-size: 12pt;">(<BR /><BR /> (</SPAN><SPAN style="color: #800000; font-size: 12pt;">Jaar</SPAN><SPAN style="font-size: 12pt;">-</SPAN><SPAN style="color: #800000; font-size: 12pt;">Geboortejaar</SPAN><SPAN style="font-size: 12pt;">)),<BR /><BR /> </SPAN><STRONG><EM style=": ; color: #808080; font-size: 12pt;">$(AgeRange)</EM></STRONG><SPAN style="font-size: 12pt;"><BR /><BR /> ,'Age') </SPAN></P><P></P></BODY></HTML> Thu, 03 Jan 2013 12:48:42 GMT https://community.qlik.com/t5/QlikView/urgent-dynamic-age-range/m-p/390177#M565712 shahamel 2013-01-03T12:48:42Z