topic Re: Split Data without Subfield Function in QlikView

Split Data without Subfield Function

rajni_batra — Thu, 19 Jan 2017 07:38:55 GMT

Hi Folks,

We have Data Mentioned as INPUT / OUTPUT in screenshot below,

we have email and segment (comma separated),

I am able to achieve OUTPUT with sub-field function but this increases the no of rows,

i have 30 Million records and after using this technique no of records got increased to 210 Million,

Is there any other way to achieve same output.

Re: Split Data without Subfield Function

Thu, 19 Jan 2017 08:08:24 GMT

Pull the data as you have, then resident from the imported table using a specific aggregated function (sum, count, average, etc.) to summarize the data then drop the original data set.

Hope this helps.

Pravesh

Re: Split Data without Subfield Function

rajni_batra — Thu, 19 Jan 2017 08:18:52 GMT

Segments are comma separated in a single filed (a,b,c,d),

I want segments to be plotted separately(

)

and then compute sum(email) on that for each segment,

I hope i am able to explain the issue now.