topic Re: how to get selected values in QlikView

how to get selected values

ravindraa — Tue, 16 Sep 2014 12:15:38 GMT

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

Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 03:56:53 GMT

Hi experts,

Please give me any suggesion on this.

Re: how to get selected values

sujeetsingh — Wed, 17 Sep 2014 04:00:01 GMT

Ravi,

I am confused a lot . Please explain in much detail

Re: how to get selected values

kushalthakral — Wed, 17 Sep 2014 04:07:20 GMT

Hi Ravindraa

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

Regards

Kushal Thakral

Re: Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 04:40:24 GMT

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.

Re: how to get selected values

jagan — Wed, 17 Sep 2014 04:50:00 GMT

Hi,

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

Regards,

Jagan.

Re: how to get selected values

aveeeeeee7en — Wed, 17 Sep 2014 04:59:31 GMT

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

Re: Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 05:06:05 GMT

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.

Re: how to get selected values

jagan — Wed, 17 Sep 2014 05:12:05 GMT

Hi,

Try like this

Dimension: officerdate

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

Regards,

jagan.

Re: Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 05:18:48 GMT

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.

Re: Re: how to get selected values

jagan — Wed, 17 Sep 2014 05:29:35 GMT

Hi,

Try like this

LOAD

If(Match(Officer_present , 'Parents_activity', 'sports_activity', 'Student_activity'), time_spent) AS Filter_time_spent

FROM DataSource;

Now use Filter_time_spent wherever you want.

Hope this helps you.

If you got the solution please Close this thread by giving Correct and Helpful answers to the posts which are helpful.

Regards,

Jagan.

Re: how to get selected values

ajaykumar1 — Wed, 17 Sep 2014 05:30:15 GMT

Hi,

can you try this in edit script;

1) if(wildmatch(Officer_present,'Parents_activity', 'sports_activity', 'Student_activity'),'CALCULATION') as OFFICER_PRESENET_DERIVED //if you want only Parents_activity,sports_activity,Student_activity

2) if(wildmatch(Officer_present,'Parents_activity', 'sports_activity', 'Student_activity'),'CALCULATION',Officer_present) AS OFFICER_PRESENET_DERIVED2 //if you want other values of Officer_present

Regards,

Ajay

Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 05:41:40 GMT

Thanks Jagan Mohan,

it is working fine.

Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 05:42:12 GMT

Thanks ajay ajay,

it is working fine.

Re: Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 06:33:37 GMT

Thanks Aviral Nag,

but it is display the all time activitys. but it is working fine.

Re: Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 06:34:39 GMT

HI sujeeti singh,

i hope you find the my attachment file

now it is working fine.

Re: Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 09:23:08 GMT

Hi Jagan Mohan,

It is working fine when the officere time spent with parents_activity , sports_activity and studnet_activity

If(Match(Officer_present , 'Parents_activity', 'sports_activity', 'Student_activity'), time_spent) AS Filter_time_spent

Here we need to caliculate when officer time spent with sports_activity,student_activity and parents_activity or other_activity .

In this case how to add the parents_activity or other_activity .

Please give me any suggession.

Thaks in advance.

Re: how to get selected values

ajaykumar1 — Wed, 17 Sep 2014 09:29:06 GMT

Hi,

Try this;

If(Match(Officer_present , 'Parents_activity', 'sports_activity', 'Student_activity'), time_spent) AS Filter_time_spent,

If(Match(Officer_present , 'Parents_activity', 'sports_activity', 'Student_activity','other_activity'), time_spent2) AS Filter_time_spent2

Note : sports_activity,student_activity and parents_activity or other_activity . Please explain what is AND,OR yo mentioned.

Regards,

Ajay

Re: Re: how to get selected values

ravindraa — Wed, 17 Sep 2014 09:46:28 GMT

Hi ajay ajay,

and is commonly write to divide the 3 words but i have to get time spent with parent_activity or otheractivity along with studnet_activity,sports_activity.

please give me any suggession on this..

Re: how to get selected values

ajaykumar1 — Wed, 17 Sep 2014 10:45:43 GMT

Hi,

Try this;

1) if(Officer_present='Student_activity' and Officer_present='sports_activity' or Officer_present='Parents_activity' or Officer_present='other_activity',time_spent,Officer_present) as NEW_FIELD;

2 ) if(Officer_present='Student_activity' and Officer_present='sports_activity' or Officer_present='Parents_activity',time_spent,

if(Officer_present='Student_activity' and Officer_present='sports_activity' or Officer_present='other_activity',time_spent,Officer_present)) as NEW_FIELD;

Regards,

Ajay