topic Re: Using one field as key dimension and but show values from other field in QlikView https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553752#M440488 <P>Because IDs are sort able and version is not.</P> Thu, 07 Mar 2019 16:15:18 GMT wiz_nerd 2019-03-07T16:15:18Z Using one field as key dimension and but show values from other field https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553716#M440483 <P>I am using <STRONG>ID</STRONG> field as dimension but I want to</P><P>show the value of <STRONG>Version</STRONG>.</P><P>&nbsp;I want all the results except null values.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>ID</TD><TD>Version</TD><TD>x</TD><TD>y</TD></TR><TR><TD>1</TD><TD>abc_12</TD><TD>1</TD><TD>1</TD></TR><TR><TD>2</TD><TD>&nbsp;</TD><TD>2</TD><TD>2</TD></TR><TR><TD>3</TD><TD>abc_14</TD><TD>3</TD><TD>3</TD></TR><TR><TD>4</TD><TD>abc_15</TD><TD>4</TD><TD>4</TD></TR><TR><TD>5</TD><TD>abc_16</TD><TD>5</TD><TD>5</TD></TR><TR><TD>6</TD><TD>&nbsp;</TD><TD>6</TD><TD>6</TD></TR><TR><TD>7</TD><TD>abc_18</TD><TD>7</TD><TD>7</TD></TR><TR><TD>8</TD><TD>abc_19</TD><TD>8</TD><TD>8</TD></TR><TR><TD>9</TD><TD>abc_20</TD><TD>9</TD><TD>9</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Version as dimension based on ID Desired table</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Version</TD><TD>x</TD><TD>y</TD></TR><TR><TD>abc_12</TD><TD>1</TD><TD>1</TD></TR><TR><TD>abc_14</TD><TD>3</TD><TD>3</TD></TR><TR><TD>abc_15</TD><TD>4</TD><TD>4</TD></TR><TR><TD>abc_16</TD><TD>5</TD><TD>5</TD></TR><TR><TD>abc_18</TD><TD>7</TD><TD>7</TD></TR><TR><TD>abc_19</TD><TD>8</TD><TD>8</TD></TR><TR><TD>abc_20</TD><TD>9</TD><TD>9</TD></TR></TBODY></TABLE> Sat, 16 Nov 2024 04:14:45 GMT https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553716#M440483 wiz_nerd 2024-11-16T04:14:45Z Re: Using one field as key dimension and but show values from other field https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553720#M440484 <P>Not sure I understand 100% what you are trying to achieve but possibly you could use this an expression?&nbsp;</P><P>Only(Version)</P><P>What is your desired final table?</P> Thu, 07 Mar 2019 15:48:27 GMT https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553720#M440484 lorenzoconforti 2019-03-07T15:48:27Z Re: Using one field as key dimension and but show values from other field https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553727#M440485 <P>Hi&nbsp;<SPAN class="UserName lia-user-name lia-user-rank-Contributor-III lia-component-message-view-widget-author-username"><A href="https://community.qlik.com/t5/user/viewprofilepage/user-id/18132" target="_self"><SPAN class="">Lorenzo,</SPAN></A></SPAN></P><P>Please check I have updated the desired table.</P> Thu, 07 Mar 2019 15:52:55 GMT https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553727#M440485 wiz_nerd 2019-03-07T15:52:55Z Re: Using one field as key dimension and but show values from other field https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553747#M440487 <P>Why are you not using Version as dimension?</P> Thu, 07 Mar 2019 16:07:47 GMT https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553747#M440487 lorenzoconforti 2019-03-07T16:07:47Z Re: Using one field as key dimension and but show values from other field https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553752#M440488 <P>Because IDs are sort able and version is not.</P> Thu, 07 Mar 2019 16:15:18 GMT https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1553752#M440488 wiz_nerd 2019-03-07T16:15:18Z Re: Using one field as key dimension and but show values from other field https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1554072#M440517 Hi,<BR />If you create a table box, and put "Version", "x" and "y" column into this table box,<BR />is that what you want?<BR />Aiolos Zhao Fri, 08 Mar 2019 10:04:10 GMT https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1554072#M440517 uacg0009 2019-03-08T10:04:10Z Re: Using one field as key dimension and but show values from other field https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1554283#M440535 <P>Just sort Version by ID</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Untitled.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7616i9E13CBA0021FBD81/image-size/large?v=v2&amp;px=999" role="button" title="Untitled.png" alt="Untitled.png" /></span></P><P>&nbsp;</P> Fri, 08 Mar 2019 14:20:11 GMT https://community.qlik.com/t5/QlikView/Using-one-field-as-key-dimension-and-but-show-values-from-other/m-p/1554283#M440535 lorenzoconforti 2019-03-08T14:20:11Z