Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Segment Data from aggregated data

Hi,

I have an aggregated table that has multiple(13)  flag fields in it that I want to get into 1 field called "Segment"

NORTH_IND

SOUTH_IND

WEST_IND

BLACK_IND

BLUE_IND

UP_IND

DOWN_IND

etc

etc

In this table there are also multiple fields (15) that I want to be able to SUM by

NAME_COUNT
EMAIL_COUNT

PHONE_COUNT

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.

Maybe there is a better way of achieving this?

Many Thanks

Stuart

1 Reply
MVP
MVP

Re: Segment Data from aggregated data

Would you be able to share few rows of actual data and explain what you want to see as the output?