Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

use clause where in Exprssion

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]

1 Reply
Not applicable

Re: use clause where in Exprssion

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

Community Browser