topic where condition in dimension in QlikView

where condition in dimension

capriconuser — Tue, 12 Feb 2019 09:47:39 GMT

I have a script but i dont want to write where condition in this script

i have dimensions like these

Name

Type

there is 3 types of people now i want only 3 type in table but i dont want to put where condition in script because this table is associated with other tables so i am trying to filter it out on TYPE dimension how i done this

any help ?

Re: where condition in dimension

pradosh_thakur — Tue, 12 Feb 2019 09:55:08 GMT

Assuming you want a,b,c you can do the following.

inner join (Your_source_table)

load * inline [

Type

a

b

c

];

Re: where condition in dimension

capriconuser — Tue, 12 Feb 2019 10:05:20 GMT

no i dont want like that i want to filter it our on dimension not on script ..

i have data like this

type

i add dimension TYPE then from that i only want 3

i dont want to where condition in script

Re: where condition in dimension

pradosh_thakur — Tue, 12 Feb 2019 10:09:14 GMT

try this in filter

if(type=3,type,null())

Re: where condition in dimension

jyotiwagde — Tue, 12 Feb 2019 10:12:07 GMT

if(type=1 or type=2 or type= 3 ,type)

Re: where condition in dimension

capriconuser — Tue, 12 Feb 2019 10:14:26 GMT

this is not working

Re: where condition in dimension

jyotiwagde — Tue, 12 Feb 2019 10:18:15 GMT

if type field is in Text format put it in ' '(Single quote)

Re: where condition in dimension

capriconuser — Tue, 12 Feb 2019 10:20:46 GMT

i did that but not working

if(type='3',type)

Re: where condition in dimension

pradosh_thakur — Tue, 12 Feb 2019 10:21:03 GMT

What exactly is the requirement? you are writing two fields type and TYPE. which is confusing . PLease state your requirement clearly to help you better. the above solution should have worked.

Re: where condition in dimension

capriconuser — Tue, 12 Feb 2019 10:34:07 GMT

type is TYPE is same ..

look there is the data in TYPE column I.E. 1,2,3 now i want 3 type in my data like with this i have a separate columns from different tables

i,e,

name country address type

abc US none 1

xyz UAE abc_address 3

def MAL gh_Address 2

and so on data

type typename

1 low

2 high

3 medium

now i add script like this

load name , country , address type from abc_file

and on the other tab

load type,typename from type_file

now if i only want data type 3 is supposed to write script like this

load name , country , address type from abc_file where type=3

but i dont want like this

i add table then i add dimensions i.e. name and type so now on that type dimension how i add where condition ?