topic Re: User field depended condition in expression in QlikView

User field depended condition in expression

Thu, 06 Sep 2012 10:41:34 GMT

Hi,

I have list with dates and diagram where I need to get sum of values where date less or equal to date selected in list box.

for example:

I have data like this

data.date

data.value

the list shows data.date in month format

the expression in diagram I need is somthing like:

Sum(

if(

data.date <= (valueSelectedInList),

ByMonthPlan.Value,

)

If anyone know the way how to do it, please help.

Thu, 06 Sep 2012 12:15:44 GMT

Could you try:

Sum(

if(

data.date = (GetFieldSelections(Items.Code)),

ByMonthPlan.Value,

)

Thu, 06 Sep 2012 12:28:30 GMT

Yes, I was tryed GetFieldSelections() with various arguments but I can't get any value.

Now I find way to get selected value but still can't use it in expression.

I put list in to {dateState} set and (max({dateState}data.date)) returns correct result

but expression returns nothing:

Sum( TOTAL

if(

data.date <= (max({dateState}data.date)),

data.Value,

)

any way thanks for the answer.

Thu, 06 Sep 2012 13:03:06 GMT

I added variable selectedDateString '=(max({dateState}data.date))'

and the expressions:

Sum( TOTAL

if(

data.date <= selectedDateString,

data.Value,

)

do work