Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

ngosz4074
New Contributor III

Re: Grouping rows

I have seen it via Pivot table.

qliksus
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,

     Name,

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

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

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

   

FROM

[\Example.xlsx]

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

Group by ID,Name;