Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

capriconuser
New Contributor III

blank row in pivot table

I have this kind of data in table .. in script i megerd two fields like this

[HeadMAIN]&'.'&[SUBCLASS] as Merged

column1         column2

Product.P1      4

Product.P2      234

Product.P3     124

Product.P4      234   

Catergory.C1   12

Catergory.C2    94

Catergory.C3     54

Catergory.C4      45    

now i want to get one additional blank row after each headmain  how i do this

column1         column2

Product.P1      4

Product.P2      234

Product.P3     124

Product.P4      234

Product           

Catergory.C1   12

Catergory.C2    94

Catergory.C3     54

Catergory.C4      45

Category              

Tags (2)
Community Browser