Crosstab Report

[Anonymous]

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............

[Gysbert_Wassenaar]

Can you post a small qlikview document that demonstrates the problem?

[Anonymous]

I attached the sample report layout...

[miguelbraga]

Hey there,

Can you please attach a Excel file with your values and/or elaborate your requirements and/or do as gwassenaar‌‌ have asked?

Regards,

MB

[miguelbraga]

The attached snapshot is an Excel file image, can you share that file?

Thanks,

MB

[Anonymous]

excel added..