how to get selected values

[ravindraa]

Hi all,
I have one requierment that i need to caliculate the "officeer time present" based on the caliculation.

caliculation part:

->Calicuationfield= timespent with Parents_activity accompained with Student_activity +  timespent with Parents with out Studnet_activity + time in sports_activity.

Officer_present                       <-this is the field name

Student_activity
Parents_activity
sports_activity
Travellig_activity
other_activity

To get this in edit script i have wrote below logic please find.

/////// in the EDIT SCRIPT LEVEL i wrote this code/////////////////////////////

load *,

if(Officer_present='Parents_activity' or 'Student_activity',
                          if(Officer_present='Parents_activity' ,
                            if(Officer_present='sports_activity',time_spent_activity))) as Calicuationfield;

sql  *from Officer_present_table;

Please give any suggesion to get the values.

Thanks in advance.......

[ravindraa]

Hi experts,

Please give me any suggesion on this.

[sujeetsingh]

Ravi,

I am confused a lot . Please explain in much detail

[kushalthakral]

Hi Ravindraa

Please mention clearly your requirement and if possible please attach sample qvd

Regards

Kushal Thakral

[ravindraa]

Hi

  My requierment is i have to maintains Offices time present i mean how many hours he spent with parents ,students and with sports master (these activites values  maintains  one field that is Officer_presen), i am attaching sample file please find this.

1st feb how many hours he(officer) spent with student , parents and sports man(i have to follow one caliculation to get that field ) please find below  caliculation.

CALICULATION:

timespent with Parents_activity accompained with Student_activity +  timespent with Parents with out Studnet_activity + time in sports_activity.

[jagan]

Hi,

Can you explain with an example with your data and expected output.

Regards,

Jagan.

[aveeeeeee7en]

Not clear about your requirement. But as far as I've understood you can try below expression in your text box and see the result:

=Sum({<Officer_present={'Parents_activity','Student_activity'}>}time_spent)

+

Sum({<Officer_present={'Parents_activity'}>}time_spent)

+

Sum({<Officer_present={'sports_activity'}>}time_spent)

I've tried this expression and it is giving the Answer: 19

Hope that helps.

Regards

Aviral Nag

[ravindraa]

Hi Jagan Mohan,

  i need to display the value like below

1/02/2014     - 7 hours.(time spent with student and parents + time spent with parents + time spent wtih sports)

02/02/2014   - 7 hours.

Please give me any suggesion.

[jagan]

Hi,

Try like this

Dimension: officerdate

Expression: Sum({<Officer_present = {'Parents_activity', 'sports_activity', 'Student_activity'}>} time_spent)

Regards,

jagan.

[ravindraa]

Hi jagan Mohan,

   thanks for help but can you give me suggession in EDIT script level because i have to use result field for another input.