topic Re: data removal in App Development

data removal

Manni_SM — Fri, 31 Jan 2025 07:04:24 GMT

Hi ,

i want to removing any existing data and restricting any future data for the country /
region – ‘China’ on Dashboard

Entity :

BBC

BBL (Chin) LTD

Unknown

conditions are below:
Entity :
'- ' We don’t want to report if the entity is “-“ and country is China.If the legal entity is ‘-’ and the country is not equal to China we will still need it in dashboard.

BBC ----- We don’t want to report if the legal entity is “BBC“ and country is China.If the legal entity is ‘BBC’ and the country is not equal to China we will still need it in dashboard.

BBL (Chin) LTD ----- Retain any record for Entity ‘BBL (Chin) LTD’ irrespective of Country name, even if it is for China as Country

Unknown ---- Retain for all countries, even if the country is China.

i want to write condition in scripting

Re: data removal

Ben_P — Fri, 31 Jan 2025 11:00:35 GMT

It sounds like you just need to add a WHERE clause to your LOAD statement to exclude the data you don't want. Something like this should work:

WHERE NOT((ISNULL(Entity) OR Entity='BBC') AND Country='China')

Re: data removal

Manni_SM — Wed, 05 Feb 2025 14:24:08 GMT

Hi Ben_P thank you .

but i have country table . so customer is asked to use mapping table instead of where condition as in future we want to include more countries to remove .

how to write the script with mapping table ?

Re: data removal

Qrishna — Wed, 05 Feb 2025 15:04:48 GMT

your question is not clear, can you put some sample data and expected ouput like in tabular form rather than explaing verbally? thnx

Re: data removal

Manni_SM — Wed, 19 Feb 2025 09:29:55 GMT

@Ben @marcus_sommer

i want this should be converted to SQL where condition how to change qlik where condition to sql ?

WHERE NOT((ISNULL(Entity") OR "Entity"='BUS' or "Entity"='BBC' or "Entity"='BANK China' or
"Entity"='Hb Bank China' or
"Entity"='Hb GBL MGT (Chi) LTD') AND "Country "='China');