topic GetObjectField with Dimentionality as index in QlikView https://community.qlik.com/t5/QlikView/GetObjectField-with-Dimentionality-as-index/m-p/1357712#M416503 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have pivot table with calculated dimentions</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="font-size: 12.0pt; color: black;">Calculated dimention text</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="font-size: 12.0pt; color: black;">Calculated value</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; color: black;">=</SPAN><STRONG><EM><SPAN style="font-size: 12.0pt; color: gray;">$(=FirstSortedValue(</SPAN><SPAN lang="EN-US" style="font-size: 12.0pt; color: gray;">Dim</SPAN><SPAN style="font-size: 12.0pt; color: gray;">,</SPAN><SPAN lang="EN-US" style="font-size: 12.0pt; color: gray;">Dim_ID,1</SPAN><SPAN style="font-size: 12.0pt; color: gray;">)) </SPAN></EM></STRONG></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;">Year</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; color: black;">=</SPAN><STRONG><EM><SPAN style="font-size: 12.0pt; color: gray;">$(=FirstSortedValue(</SPAN><SPAN lang="EN-US" style="font-size: 12.0pt; color: gray;">Dim</SPAN><SPAN style="font-size: 12.0pt; color: gray;">,</SPAN><SPAN lang="EN-US" style="font-size: 12.0pt; color: gray;">Dim_ID,2</SPAN><SPAN style="font-size: 12.0pt; color: gray;">))</SPAN></EM></STRONG></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;">WeekNum</P></TD></TR></TBODY></TABLE><P></P><P>Why </P><P>$(=GetObjectField(0)) returns 2017 and 2016</P><P>while </P><P><SPAN style="font-size: 13.3333px;">$(=GetObjectField(Dimentionality()-1)) returns "-"</SPAN></P><P><SPAN style="font-size: 13.3333px;">How to get to work <SPAN style="font-size: 13.3333px;">GetObjectField with Dimentionality as index.</SPAN><BR /></SPAN></P></BODY></HTML> Mon, 10 Jul 2017 14:10:18 GMT wkolbnik 2017-07-10T14:10:18Z GetObjectField with Dimentionality as index https://community.qlik.com/t5/QlikView/GetObjectField-with-Dimentionality-as-index/m-p/1357712#M416503 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>I have pivot table with calculated dimentions</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="font-size: 12.0pt; color: black;">Calculated dimention text</SPAN></P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;"><SPAN lang="EN-US" style="font-size: 12.0pt; color: black;">Calculated value</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; color: black;">=</SPAN><STRONG><EM><SPAN style="font-size: 12.0pt; color: gray;">$(=FirstSortedValue(</SPAN><SPAN lang="EN-US" style="font-size: 12.0pt; color: gray;">Dim</SPAN><SPAN style="font-size: 12.0pt; color: gray;">,</SPAN><SPAN lang="EN-US" style="font-size: 12.0pt; color: gray;">Dim_ID,1</SPAN><SPAN style="font-size: 12.0pt; color: gray;">)) </SPAN></EM></STRONG></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;">Year</P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;"><SPAN style="font-size: 12.0pt; color: black;">=</SPAN><STRONG><EM><SPAN style="font-size: 12.0pt; color: gray;">$(=FirstSortedValue(</SPAN><SPAN lang="EN-US" style="font-size: 12.0pt; color: gray;">Dim</SPAN><SPAN style="font-size: 12.0pt; color: gray;">,</SPAN><SPAN lang="EN-US" style="font-size: 12.0pt; color: gray;">Dim_ID,2</SPAN><SPAN style="font-size: 12.0pt; color: gray;">))</SPAN></EM></STRONG></P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="319"><P style="margin-bottom: .0001pt;">WeekNum</P></TD></TR></TBODY></TABLE><P></P><P>Why </P><P>$(=GetObjectField(0)) returns 2017 and 2016</P><P>while </P><P><SPAN style="font-size: 13.3333px;">$(=GetObjectField(Dimentionality()-1)) returns "-"</SPAN></P><P><SPAN style="font-size: 13.3333px;">How to get to work <SPAN style="font-size: 13.3333px;">GetObjectField with Dimentionality as index.</SPAN><BR /></SPAN></P></BODY></HTML> Mon, 10 Jul 2017 14:10:18 GMT https://community.qlik.com/t5/QlikView/GetObjectField-with-Dimentionality-as-index/m-p/1357712#M416503 wkolbnik 2017-07-10T14:10:18Z Re: GetObjectField with Dimentionality as index https://community.qlik.com/t5/QlikView/GetObjectField-with-Dimentionality-as-index/m-p/1357713#M416504 <HTML><HEAD></HEAD><BODY><P>Hm..that strange but</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">$(=GetObjectField(Dimentionality()<STRONG>+</STRONG>1)) wonks fine</SPAN></P></BODY></HTML> Mon, 10 Jul 2017 14:13:24 GMT https://community.qlik.com/t5/QlikView/GetObjectField-with-Dimentionality-as-index/m-p/1357713#M416504 wkolbnik 2017-07-10T14:13:24Z