use clause where in Exprssion

[#1]

hi everyone,

i am  a beginner , and i trying to discover the use of the 'expression' in qlikView.

i have two table:

[table 1:

resource_id,

task_id,

ETC,

conso,

date as date1]

[table2:

resource_id,

project_id,

dispo,

date as date2]

for not havaing loops in my modele i changed the name of the date field "date" and "resource id"

my problem is i want

to: sum(conso)+sum(ETC)+[sum(dispo) where date equal to date in my dimention (date1) and project_id = the selected project in my list box]

[#2]

Hi,

Try like this

if(Date1=

subfield(GetCurrentSelections(Date),':',2) and project_id=subfield(GetCurrentSelections(project_id),':',2)

sum(conso)+sum(ETC)+[sum(dispo))  // Here u must select the one value in Date and project_id.

~Kabilan K