Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

FFBB1983
New Contributor III

Sales Territary Alignment

Dear Qlikers,

I have a dummy table like this,

Postal CodeTerritory
L0B11205
L0C11203
L0E11204
L0G00000000
L0H11202
L0K11201
L1C11206
L1E11303
L1G11302
L1H11301
L1J11304
L1K11102
L1L11103
L1M11101

 

If I want to load this table and collapse all 11304 postal code to 11302, how should I write the scripts?

 

I wrote  If(NewTerritory=11304,11302), but it is not working:-(

 

1 Solution

Accepted Solutions

Re: Sales Territary Alignment

May be this

If(Territory = 11304, 11302, Territory) as NewTerritory
2 Replies

Re: Sales Territary Alignment

May be this

If(Territory = 11304, 11302, Territory) as NewTerritory
FFBB1983
New Contributor III

Re: Sales Territary Alignment

Thanks for the help!