topic Re: Count inside only function in QlikView

Count inside only function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Is it possible to incorporate count function inside only function. if not how can i write the below expression.

only({<temp_batch_id={'$(v_module1)'}>}if(count({<result_err_flag={'E'}>}result_err_flag)>0,'E',

if(count({<result_err_flag={'W'}>}result_err_flag)>0,'W',

if(IsNull(result_err_flag),'P'))))

sincerely,

Re: Count inside only function

lironbaram — Mon, 02 Jan 2017 07:58:22 GMT

why do you need the only function

maybe something like this

aggr(

f(count({<result_err_flag={'E'}>}result_err_flag)>0,'E',

if(count({<result_err_flag={'W'}>}result_err_flag)>0,'W',

if(IsNull(result_err_flag),'P'))),temp_batch_id)

Re: Count inside only function

saimahasan — Mon, 02 Jan 2017 08:06:04 GMT

Try with Aggr() function. May be it helps you.

Re: Count inside only function

Anonymous — Mon, 02 Jan 2017 09:14:07 GMT

Actually I have a set of temp_batch_id's. In this expression I have to pass only one temp_batch_id which is stored in the variable v_module1. so for that reason i have used only function.

Re: Count inside only function

Anonymous — Mon, 02 Jan 2017 09:16:20 GMT

Actually i don't want this expression to be aggregated against temp_batch_id's. I need to pass few temp_batch_id's only which is stored in some variables like v_module1

Re: Count inside only function

Anil_Babu_Samineni — Mon, 02 Jan 2017 09:36:08 GMT

Can you send full expression, I mean Without any variables and i see few flags does this direct field or you created for flag to show 0,1

Re: Count inside only function

Anonymous — Mon, 02 Jan 2017 09:46:53 GMT

if(count({<result_err_flag={'E'}>}result_err_flag)>0,'E',

if(count({<result_err_flag={'W'}>}result_err_flag)>0,'W',

if(IsNull(result_err_flag),'P'))). this is my expression and it is working fine. but in this expression i need to pass some temp_batch_id's. for eg: temp_batch_id=v_module1. (all flags are direct fields)

Re: Count inside only function

Anil_Babu_Samineni — Mon, 02 Jan 2017 10:00:17 GMT

What was the Variable here?

May be this

if(count({<result_err_flag={'E'}, temp_batch_id={'$(v_module1)'}>}result_err_flag)>0,'E',

if(count({<result_err_flag={'W'}, temp_batch_id={'$(v_module1)'}>}result_err_flag)>0,'W',

if(IsNull(result_err_flag),'P','Remaining')))

Re: Count inside only function

Anonymous — Mon, 02 Jan 2017 10:21:44 GMT

I have tried this. the problem with the this expression is, since the outer condition is an if loop this expression will work only when you select the temp_batch_id as the v_module1. if nothing is selected it wont work.

I want to get the output even though nothing is selected. that's why i tried to use only function

Re: Count inside only function

Anil_Babu_Samineni — Mon, 02 Jan 2017 10:26:39 GMT

What is v_modele1 Here, And Try with $ for Selections

if(count({$<result_err_flag={'E'}, temp_batch_id={'$(v_module1)'}>}result_err_flag)>0,'E',

if(count({$<result_err_flag={'W'}, temp_batch_id={'$(v_module1)'}>}result_err_flag)>0,'W',

if(IsNull(result_err_flag),'P','Remaining')))

Re: Count inside only function

Anonymous — Mon, 02 Jan 2017 11:10:41 GMT

Thanks Anil. Its working now. below is my complete expression now.

if(Value=1,if(count({$<result_err_flag={'E'},temp_batch_id={'$(v_module1)'}>}result_err_flag)>0,'E',

if(count({$<result_err_flag={'W'},temp_batch_id={'$(v_module1)'}>}result_err_flag)>0,'W',

only({<temp_batch_id={'$(v_module1)'}>}if(IsNull(result_err_flag),'P')))),

if(Value=2,if(count({<result_err_flag={'E'},temp_batch_id={'$(v_module1)','$(v_module2)','$(v_module3)'}>}result_err_flag)>0,'E',

if(count({<result_err_flag={'W'},temp_batch_id={'$(v_module1)','$(v_module2)','$(v_module3)'}>}result_err_flag)>0,'W',

only({<temp_batch_id={'$(v_module1)','$(v_module2)','$(v_module3)'}>}if(IsNull(result_err_flag),'P')))),

if(Value=3,if(count({<result_err_flag={'E'},temp_batch_id={'$(v_module1)','$(v_module2)','$(v_module3)','$(v_module4)','$(v_module5)'}>}result_err_flag)>0,'E',

if(count({<result_err_flag={'W'},temp_batch_id={'$(v_module1)','$(v_module2)','$(v_module3)','$(v_module4)','$(v_module5)'}>}result_err_flag)>0,'W',

only({<temp_batch_id={'$(v_module1)','$(v_module2)','$(v_module3)','$(v_module4)','$(v_module5)'}>}if(IsNull(result_err_flag),'P')))),

if(count({<result_err_flag={'E'}>}result_err_flag)>0,'E',

if(count({<result_err_flag={'W'}>}result_err_flag)>0,'W',

if(IsNull(result_err_flag),'P'))))))

v_module variables are the last 5 temp_batch_id.