Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
akumar_c
Contributor

Script Help

Hi Team, I have a scenario, Like --> I have 2 country data and now I need to merge the both. Data is in this format. Metric Country LOB Value KPI 18 MALDIVES XLOB 1 KPI 21 MALDIVES XLOB PD KPI 18 MALDIVES XLOB PD Metric Country LOB VALUE KPI 18 SRI LANKA XLOB PD KPI 21 SRI LANKA XLOB PD KPI 18 SRI LANKA XLOB ND Output : Need Output on the behalf of these are the condition : •If one country at LOB level has data and other country is PD, then treat PD as zero when adding together. •If both countries at LOB level PD then combined PD •If one country at LOB level PD and one Country ND then combined is ND. OUTPUT Metric Country LOB VALUE KPI 18 SRI LANKA & MALDIVES XLOB 0 KPI 21 SRI LANKA & MALDIVES XLOB PD KPI 18 SRI LANKA & MALDIVES XLOB ND So Can anyone look into the same and revert me. Regards, AS