Please kindly assist in doing the table as per requirement.

[suvechha_b]

Hi All,

Please kindly assist in the below requirement -

The "Partner" table in the Qliksense App has "*On Platform - CIMS" with RB_BATCH_TYPE "D" and "M".

Thus, in the report - I am getting two records like below -

Is there any way , if the report can show "Partner Name"  - "*On Platform - CIMS" as one and in both field "Monthly Claims Data" and "Daily Claims Data" as "Y" like below image-

sample model attached.

[PrashantSangle · Accepted solution]

Try below expression as measure instead of dimension

if(MaxString({<RB_BATCH_TYPE={'D'}>} RB_BATCH_TYPE)='D','Y')

if(MaxString({<RB_BATCH_TYPE={'M'}>} RB_BATCH_TYPE)='M','Y')

Regards,

Prashant Sangle

[suvechha_b]

Hi PrashantSangle,

Please kindly assist me on this question.

https://community.qlik.com/t5/New-to-Qlik-Sense/Assist-me-in-getting-the-requirement/m-p/1628410#M14...