Discussion board where members can get started with QlikView.
i am a beginner , and i trying to discover the use of the 'expression' in qlikView.
i have two table:
date as date1]
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]
Try like this
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.