data removal

[Manni_SM]

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 

[Ben_P]

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')

[Manni_SM]

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 ?

[Qrishna]

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

[Manni_SM]

@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');