topic Reading and Counting Cell Values Via Macro in QlikView https://community.qlik.com/t5/QlikView/Reading-and-Counting-Cell-Values-Via-Macro/m-p/493224#M184486 <HTML><HEAD></HEAD><BODY><P>I have 18 straight charts grouped into 6 sets, so each set has 3 charts. Each chart has one Dimension (client) and one Expression (Sales). Need to create a Macro that reads each set (3 charts at a time), count the number of times Clients appear in each set, if:</P><P></P><P>Count(Client) = 2, make the background color of that row (Dimension and Expression) Blue</P><P>Count(Client) = 3, make the background color of that row (Dimension and Expression) Green</P><P></P><P>Then read the next set and so on.</P><P>Attached is the sample.</P><P></P><P>Any suggestion would be appreciated.</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 18 Oct 2013 20:51:45 GMT Anonymous 2013-10-18T20:51:45Z Reading and Counting Cell Values Via Macro https://community.qlik.com/t5/QlikView/Reading-and-Counting-Cell-Values-Via-Macro/m-p/493224#M184486 <HTML><HEAD></HEAD><BODY><P>I have 18 straight charts grouped into 6 sets, so each set has 3 charts. Each chart has one Dimension (client) and one Expression (Sales). Need to create a Macro that reads each set (3 charts at a time), count the number of times Clients appear in each set, if:</P><P></P><P>Count(Client) = 2, make the background color of that row (Dimension and Expression) Blue</P><P>Count(Client) = 3, make the background color of that row (Dimension and Expression) Green</P><P></P><P>Then read the next set and so on.</P><P>Attached is the sample.</P><P></P><P>Any suggestion would be appreciated.</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 18 Oct 2013 20:51:45 GMT https://community.qlik.com/t5/QlikView/Reading-and-Counting-Cell-Values-Via-Macro/m-p/493224#M184486 Anonymous 2013-10-18T20:51:45Z Re: Reading and Counting Cell Values Via Macro https://community.qlik.com/t5/QlikView/Reading-and-Counting-Cell-Values-Via-Macro/m-p/493225#M184487 <HTML><HEAD></HEAD><BODY><P>See attached example.</P></BODY></HTML> Sat, 19 Oct 2013 17:10:40 GMT https://community.qlik.com/t5/QlikView/Reading-and-Counting-Cell-Values-Via-Macro/m-p/493225#M184487 Gysbert_Wassenaar 2013-10-19T17:10:40Z Re: Reading and Counting Cell Values Via Macro https://community.qlik.com/t5/QlikView/Reading-and-Counting-Cell-Values-Via-Macro/m-p/493226#M184488 <HTML><HEAD></HEAD><BODY><P>Thank you G Wassenaar, I can't assign Table and Group fields in the data model because of it's size and complexity.</P><P>Trying to achieve the grouping on front-end (sheet level)</P></BODY></HTML> Tue, 22 Oct 2013 20:49:17 GMT https://community.qlik.com/t5/QlikView/Reading-and-Counting-Cell-Values-Via-Macro/m-p/493226#M184488 Anonymous 2013-10-22T20:49:17Z