Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Merge Cells of Pivot table

Hi All,

Below is a pivot table i want to make:-     

    

DIm1Exp1Exp2Exp3Exp4
Dim_val1t1121v1
Dim_val2t2
Dim_val3t3121v2
Dim_val4t4
Dim_val5t5121v3
Dim_val6t6

I want to merge row 1,2 for Exp2, Exp3, Exp4

merge row 3,4 for Exp2, Exp3, Exp4

merge row 5,6 for Exp2, Exp3, Exp4

How can this be achieved. ?

Thanks