Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

New Contributor III

Re: Grouping rows

I have seen it via Pivot table.

Valued Contributor II

Re: Grouping rows

The below script seems to give your required result not sure what issue you are facing

LOAD Distinct ID,


     MaxString([4 Week Flag]) as [4 Week Flag],  

     MaxString([8 Week Flag]) as [8 Week Flag],    

     MaxString([12 Week Flag]) as [12 Week Flag]




(ooxml, embedded labels, header is 1 lines, table is Sheet1)

Group by ID,Name;