https://community.qlik.com/t5/App-Development/Grouping-by-on-expression/m-p/1677924#M63744 <P>Hi, I have a table similar to the below:</P><TABLE width="281"><TBODY><TR><TD width="73">Id Number</TD><TD width="38">User</TD><TD width="103">Tag Description</TD><TD width="67">Tag Value</TD></TR><TR><TD>1</TD><TD>Jack</TD><TD>Country</TD><TD>UK</TD></TR><TR><TD>1</TD><TD>Jack</TD><TD>Hair Colour</TD><TD>Red</TD></TR><TR><TD>1</TD><TD>Jack</TD><TD>Shoe Size</TD><TD>41</TD></TR><TR><TD>1</TD><TD>Jack</TD><TD>Profession</TD><TD>Author</TD></TR><TR><TD>2</TD><TD>John</TD><TD>Country</TD><TD>France</TD></TR><TR><TD>2</TD><TD>John</TD><TD>Hair Colour</TD><TD>Blue</TD></TR><TR><TD>2</TD><TD>John</TD><TD>Shoe Size</TD><TD>45</TD></TR><TR><TD>2</TD><TD>John</TD><TD>Profession</TD><TD>Nurse</TD></TR><TR><TD>3</TD><TD>Mary</TD><TD>Country</TD><TD>UK</TD></TR><TR><TD>3</TD><TD>Mary</TD><TD>Hair Colour</TD><TD>Green</TD></TR><TR><TD>3</TD><TD>Mary</TD><TD>Shoe Size</TD><TD>38</TD></TR><TR><TD>3</TD><TD>Mary</TD><TD>Profession</TD><TD>Finance</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In my visualisations, I have built pie charts for "Tag Description" column so that each is displayed in a pie chart. However, when I select one of the variables such as "UK" for "Country", all the other pie charts stop displaying since the other rows are ignored.&nbsp;<BR /><BR />I currently use&nbsp;=If([Tag Description] like '*Country*', [Tag Value]). How can I use something like an index match to match values and sync across their shared Id Number column?<BR /><BR /></P> Sat, 16 Nov 2024 03:12:05 GMT adogramaci 2024-11-16T03:12:05Z https://community.qlik.com/t5/App-Development/Grouping-by-on-expression/m-p/1677924#M63744 <P>Hi, I have a table similar to the below:</P><TABLE width="281"><TBODY><TR><TD width="73">Id Number</TD><TD width="38">User</TD><TD width="103">Tag Description</TD><TD width="67">Tag Value</TD></TR><TR><TD>1</TD><TD>Jack</TD><TD>Country</TD><TD>UK</TD></TR><TR><TD>1</TD><TD>Jack</TD><TD>Hair Colour</TD><TD>Red</TD></TR><TR><TD>1</TD><TD>Jack</TD><TD>Shoe Size</TD><TD>41</TD></TR><TR><TD>1</TD><TD>Jack</TD><TD>Profession</TD><TD>Author</TD></TR><TR><TD>2</TD><TD>John</TD><TD>Country</TD><TD>France</TD></TR><TR><TD>2</TD><TD>John</TD><TD>Hair Colour</TD><TD>Blue</TD></TR><TR><TD>2</TD><TD>John</TD><TD>Shoe Size</TD><TD>45</TD></TR><TR><TD>2</TD><TD>John</TD><TD>Profession</TD><TD>Nurse</TD></TR><TR><TD>3</TD><TD>Mary</TD><TD>Country</TD><TD>UK</TD></TR><TR><TD>3</TD><TD>Mary</TD><TD>Hair Colour</TD><TD>Green</TD></TR><TR><TD>3</TD><TD>Mary</TD><TD>Shoe Size</TD><TD>38</TD></TR><TR><TD>3</TD><TD>Mary</TD><TD>Profession</TD><TD>Finance</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In my visualisations, I have built pie charts for "Tag Description" column so that each is displayed in a pie chart. However, when I select one of the variables such as "UK" for "Country", all the other pie charts stop displaying since the other rows are ignored.&nbsp;<BR /><BR />I currently use&nbsp;=If([Tag Description] like '*Country*', [Tag Value]). How can I use something like an index match to match values and sync across their shared Id Number column?<BR /><BR /></P> Sat, 16 Nov 2024 03:12:05 GMT https://community.qlik.com/t5/App-Development/Grouping-by-on-expression/m-p/1677924#M63744 adogramaci 2024-11-16T03:12:05Z