Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

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              

0 Replies