topic Re: MODELLING PROBLEM in QlikView

MODELLING PROBLEM

adiarnon — Thu, 18 Feb 2016 09:14:52 GMT

HI,

MY user have two filters-

one for the PB_VENDOR

and one for COST_BP_Name

the bussiness meaning is the same.

so he want to combine this two filters to one.

how can i do it?

Re: MODELLING PROBLEM

ashfaq_haseeb — Thu, 18 Feb 2016 09:18:39 GMT

Hi,

You need to look at link table.

Concatenate vs Link Table

Regards

ASHFAQ

Re: MODELLING PROBLEM

alexandros17 — Thu, 18 Feb 2016 09:21:24 GMT

You could rename one of the two using an alias:

load

....

PB_VENDOR as COST_BP_Name

....

otherwise you could create another table with only a distinct load concatenation of both fields in order to have a unique new field and use this as a filer, youe expression must then be changed into PB_VENDOR = getfieldselections(NewField)

this solution is a bit tricky however.

Hope this helps

Re: MODELLING PROBLEM

ahmar811 — Thu, 18 Feb 2016 09:30:03 GMT

Try this

first you need to create new table which is resident of CC_COST like below

Link_Table:

load

COST_BP_Name as PB_VENDOR

resident

CC_COST;

after that this new table is link to table PROJECT_BUDGET with filed name PB_VENDOR

hope this help you

Thanks & Regards

Ahmar Ansari