Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Help required for Pick Match function withing If else

my Second Pick is not getting calculated after applying filter

I am trying to put all numbers Manually Product wise.

So when i apply filter on [TerritoryLevel4] ='S_UKI' it still shows value for [TerritoryLevel3]='S_EMEA'

Please help

E.g.

If([TerritoryLevel3]='S_EMEA',(Pick(Match([Product Sub Category],'A','B','C',

'D','E','F','G','H','I','J','K','L','M','N')+1,

7087645,3100720,7239302,3495407,11574307,1767474,5451370,4072107,9562232,3658490,4785699,322131,6208621,5825034,0))/1000000,

If([TerritoryLevel4] ='S_UKI',

(Pick(Match([Product Sub Category],'A','B','C',

'D','E','F','G','H','I','J','K','L','M','N')+1,

'1774348','655502','1518050','517787','2101909','-9183','3072889','853903','1993201','1183086','2501750','37068','1279540','1723476','0')/1000000),''))

Tags (1)