topic Re: How to get selected value from perticular in QlikView

How to get selected value from perticular

ravindraa — Thu, 18 Sep 2014 05:14:12 GMT

I struck in place please give me any suggesion.
My requierment is i have to caliculate officere time present.

to get the caliculation field i need to follow one caliculation.

Requierment:

timespent with studentactivity + timespent with parents_activity or timespent with other_activity + timespent with sports_activity.

in the edit script level i wrote like this.

fileter_time:
load
*,

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

from datasource;

please find the attchmets.

i am struck where i have to write or condition.

Please give any suggesion.
Thanks to advance.

Re: How to get selected value from perticular

ravindraa — Thu, 18 Sep 2014 06:58:06 GMT

Hi experts,

Please give me any suggesion on this.

thanks

Ravindra

Re: How to get selected value from perticular

Thu, 18 Sep 2014 07:46:32 GMT

Hi ravindraa,

I think you do not need to write any extra code in EDIT SCRIPT Window. Just IMPORT the Excel.

Now you can smply write the follwing code in any expression.

= if(SubStringCount('|' & Concat(distinct Officer_present, '|') & '|', '|Parents_activity|'),
(Sum(if(Officer_present='Student_activity',time_spent)) +
Sum(if(Officer_present='sports_activity' ,time_spent)) +
Sum(if(Officer_present='Parents_activity' ,time_spent))),
(Sum(if(Officer_present='Student_activity',time_spent)) +
Sum(if(Officer_present='sports_activity' ,time_spent)) +
Sum(if(Officer_present='other_activity' ,time_spent))))

Pls refer to the qvw attached.

Re: How to get selected value from perticular

ravindraa — Thu, 18 Sep 2014 08:27:33 GMT

Hi Kuntal Dey,

Thaks for reply but i have to use caliculation field for other place as input field thats why , please give me any suggession.

Thanks

Ravindra

Re: How to get selected value from perticular

Thu, 18 Sep 2014 08:30:41 GMT

Did not get you. Can u pls specify more clearly

Re: How to get selected value from perticular

ravindraa — Thu, 18 Sep 2014 08:55:13 GMT

Hi Kuntal Dey,

I have to caliculate the officer time spent for one field.

Because after create this i have to calicute the % wise time spent (%time=(Filter_time_spent/Time spent fullhours)*100).

thats why please give me suggesion on this.

thanks in advance.

Re: How to get selected value from perticular

ravindraa — Thu, 18 Sep 2014 11:38:40 GMT

Hi experts please help me onthis issue.