topic Re: Dynamic logic in QlikView

Dynamic logic

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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..

Re: Dynamic logic

Chanty4u — Tue, 28 Jun 2016 07:00:57 GMT

try this

=if(location_new<>'016' or location_new<>'025' or location_new<>'099','Location_New) as newlocation

Re: Dynamic logic

Anonymous — Tue, 28 Jun 2016 07:01:07 GMT

easiest way would be to define a variable like this:

let vLocNew = '016;025;099';

and test if (match(Location_new, vLocNew)=0

will be tru if Location_new doesnot contain any of the Locations defined in variable

alternatively you may define the new Locations in an Excel list and read this list into a variable

Re: Dynamic logic

migueldelval — Tue, 28 Jun 2016 07:01:28 GMT

Hi nareshthavidishetty,

I can´t understand you so well, but Ithink that you can use a variable to make it.

Your variable or variables can represent the values that you want to exclude or show.

Regards

Miguel del Valle

Re: Dynamic logic

nareshthavidishetty — Tue, 28 Jun 2016 07:09:30 GMT

Hi,

I need to show the data for the locations = 012,034,045,067 every time even if the new locations added to the filed.

The logic which we were used(=if(location_new<>'016' and location_new<>'025' and location_new<>'099',location_new)) is not dynamic like when ever an new location added to the field the new location will also show the results.

Result required : My chart should show the data only for(012,034,045,067 ) even if new locations added to the field.

Thanks..

Re: Dynamic logic

Anonymous — Tue, 28 Jun 2016 07:13:04 GMT

then this should work

let vLocNew = '012;034;045;067';

if (match(location_new, vLocNew)>0, location_new

only the 4 defined Locations will be displayed, even if 10 locations exists

Re: Dynamic logic

nareshthavidishetty — Tue, 28 Jun 2016 07:24:04 GMT

Hi,

We used the logic as dimension ,it gives empty results =if (match(location_new, vLocNew )>0, location_new)

But when check the variable alone it show the right results.

Thanks..

Re: Dynamic logic

Anonymous — Tue, 28 Jun 2016 07:29:15 GMT

does it work when you select only 1 Location?

in a straight table with Dimension Location_new it should work

in a textobject it should work when you select only 1 Location

when no or several locations are selected the if Expression will not work

can you explain your requirements?

Re: Dynamic logic

nareshthavidishetty — Tue, 28 Jun 2016 07:46:27 GMT

Hi,

After the logic used in dimension we were getting no results as below

Chart used: straight table

Logic used: =if (match(location_new, vLocNew )>0, location_new)

Thanks..

Re: Dynamic logic

tamilarasu — Tue, 28 Jun 2016 07:48:45 GMT

Try this,

=If(Match(location_new,'012','034','045','067'),location_new)

Also, don't forget to enable the option "Suppress When Value Is Null".

Re: Dynamic logic

Anonymous — Tue, 28 Jun 2016 08:05:47 GMT

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]

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

Re: Dynamic logic

nareshthavidishetty — Tue, 28 Jun 2016 08:12:46 GMT

Thanks..Rudolf it's working.