Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Dynamic logic

Hi,

We have an location field which having all locations but we have to capture only few locations which is to be static all the time.

Logic used :=if(location_new<>'016' and location_new<>'025' and location_new<>'099',location_new)

But the new locations got updated frequently so here am not able to capture only the locations which i required.

Locations need to static every time even if the new locations added = 012,034,045,067.

Thanks..

11 Replies
Anonymous
Not applicable

I made a small sample and I have to correct my statement

define variable vLocNew as

'012','034','045','067'

define calculated dimension

=if (match(Location_new,$(vLocNew))>0, Location_new,null())

tick suppress when value is null

my result

you could achive also by using set Analysis

sum({<Location_new={'$(=vLocNew)'}>}[Total Orders]

or

sum({<Location_new={'012',034',045','067')'}>}[Total Orders]

nareshthavidishetty
Creator III
Creator III
Author

Thanks..Rudolf it's working.