topic Re: expr explination ? urgent in QlikView

expr explination ? urgent

Anonymous — Wed, 10 Dec 2014 09:31:56 GMT

max({1<month={'$(=month(vperiod))'}>}period))

vperiod is = getfieldselctions(period)

here period is 16/11/2014

Re: expr explination ? urgent

morganaaron — Wed, 10 Dec 2014 09:51:18 GMT

Confusing, given what it seems to be doing, but from what I can tell:

A user makes a selection in the field 'period' and the value is passed to the variable vperiod.

The expression then returns the maximum period where the month field is equal to the month of the period held in the variable.

It'd be more helpful if you could mention what format the fields were both in and what the expression was being used for.

Re: expr explination ? urgent

Anonymous — Wed, 10 Dec 2014 09:58:37 GMT

Thats fien aaron,

i understood now my req is

in period i have dates like

period:

11/26/2014

11/27/2014

11/28/014

but when i select 11/26/2014 even though above expression returning data for 11/28/2014 only

i want see for selected date

but i have in my expression MAX , i think because of this i am getting 11/28/2014

how to get current selected date period?

Re: expr explination ? urgent

renjithpl — Wed, 10 Dec 2014 10:03:53 GMT

max({<month={'$(=month(vperiod))'}>}period))

Re: expr explination ? urgent

renjithpl — Wed, 10 Dec 2014 10:05:21 GMT

remove 1 from the script.

Re: expr explination ? urgent

arulsettu — Wed, 10 Dec 2014 10:09:45 GMT

try like this

=max({<month={$(=month(vperiod))}>}period)

Re: expr explination ? urgent

morganaaron — Wed, 10 Dec 2014 10:10:37 GMT

Is there a reason you take the field selection, pass it to a variable, and then re-evaluate this?

What is the expression doing? Is it embedded in another calculation? Because if you just want to return your selected date, you can just use max(period)...