Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

expr explination ? urgent

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

vperiod is = getfieldselctions(period)

here period is  16/11/2014

1 Solution

Accepted Solutions
renjithpl
Specialist
Specialist

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


View solution in original post

6 Replies
morganaaron
Specialist
Specialist

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.

Anonymous
Not applicable
Author

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?

renjithpl
Specialist
Specialist

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


renjithpl
Specialist
Specialist

remove 1 from the script.

arulsettu
Master III
Master III

try like this

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

morganaaron
Specialist
Specialist

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)...