Hi All,
I want to create the crosstab report in qlikview,Please find the details below
and attached Report Layout.
Polcy-No,Maj-Lin,Min-Lin,Tran-Type these fields in rows and RI-Type,8x,GLF,Exit 8X/GLF,RI 02 = GLF in column.
8x=sum of 82,83,84
GLF=values of 00(RI-Type)
Grand Total=sum of 00,01,02,82,83,84
Exit 8X/GLF=8x/GLF
RI 02 = GLF=IF(ISBLANK(02), "No RI 02", IF(02=GLF, "Equal", "Not Equal"))
Please give some idea how to implement this Thanks in Advance............