topic Re: Segment Data from aggregated data in QlikView https://community.qlik.com/t5/QlikView/Segment-Data-from-aggregated-data/m-p/1302360#M617872 <HTML><HEAD></HEAD><BODY><P>Would you be able to share few rows of actual data and explain what you want to see as the output?</P></BODY></HTML> Mon, 08 May 2017 13:37:40 GMT sunny_talwar 2017-05-08T13:37:40Z Segment Data from aggregated data https://community.qlik.com/t5/QlikView/Segment-Data-from-aggregated-data/m-p/1302359#M617871 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have an aggregated table that has multiple(13)&nbsp; flag fields in it that I want to get into 1 field called "Segment"</P><P></P><P>NORTH_IND</P><P>SOUTH_IND</P><P>WEST_IND</P><P>BLACK_IND</P><P>BLUE_IND</P><P>UP_IND</P><P>DOWN_IND</P><P>etc</P><P>etc</P><P></P><P></P><P>In this table there are also multiple fields (15) that I want to be able to SUM by</P><P>NAME_COUNT<BR />EMAIL_COUNT</P><P>PHONE_COUNT</P><P></P><P></P><P>I can get Crosstable to work to get a table that has Segment in it; but I cant work out how to link that table back to the original table so I can SUM those extra fields by Segment.</P><P></P><P>Maybe there is a better way of achieving this?</P><P></P><P>Many Thanks</P><P>Stuart</P></BODY></HTML> Mon, 08 May 2017 13:16:55 GMT https://community.qlik.com/t5/QlikView/Segment-Data-from-aggregated-data/m-p/1302359#M617871 2017-05-08T13:16:55Z Re: Segment Data from aggregated data https://community.qlik.com/t5/QlikView/Segment-Data-from-aggregated-data/m-p/1302360#M617872 <HTML><HEAD></HEAD><BODY><P>Would you be able to share few rows of actual data and explain what you want to see as the output?</P></BODY></HTML> Mon, 08 May 2017 13:37:40 GMT https://community.qlik.com/t5/QlikView/Segment-Data-from-aggregated-data/m-p/1302360#M617872 sunny_talwar 2017-05-08T13:37:40Z