Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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............
Can you post a small qlikview document that demonstrates the problem?
I attached the sample report layout...
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
The attached snapshot is an Excel file image, can you share that file?
Thanks,
MB
excel added..