Discussion board where members can get started with Qlik Sense.
I have a dummy table like this,
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:-(
Go to Solution.
May be this
If(Territory = 11304, 11302, Territory) as NewTerritory
Thanks for the help!