topic if statement to set analysis in QlikView

if statement to set analysis

israrkhan — Wed, 28 Oct 2015 06:19:29 GMT

Hi Guys.

can some one help me to convert below if statement into set analysis.

=count( if( (status = 'Closed' or status = 'resolved' ) and( measurementstatus = 'missed') and if (assigned_group like '*client*', title like '*abc*' , title like '*cde* ) , number ) )

your help would be much appreciated...!

Thanks

Khan

Re: if statement to set analysis

lironbaram — Wed, 28 Oct 2015 06:32:09 GMT

it should be something like

count( {< status = {'Closed' ,'resolved' }, measurementstatus = {'missed'},assigned_group ={ '*client*'}, title={ '*abc*','*cde*' }>} number )

Re: if statement to set analysis

sujeetsingh — Wed, 28 Oct 2015 06:46:31 GMT

count( {< status = {'Closed' ,'resolved' }, measurementstatus = {'missed'},assigned_group ={ '*client*'}, Wildmatch(title, '*abc*','*cde*')={1}>} number )

Re: if statement to set analysis

Wed, 28 Oct 2015 06:55:21 GMT

Hello IsrarKhan,

Try the below set analysis.

COUNT({<Status={'Closed','resolved'},measurementstatus ={'missed'},assigned_group={'*client*'},Title={'*abc*','*cde*'}>}Number)

Re: if statement to set analysis

jagan — Wed, 28 Oct 2015 06:58:23 GMT

Hi Israr,

Try this

=count( {<status ={ 'Closed', 'resolved'} , measurementstatus = {'missed'}, assigned_group ={'*client*'}, title={'*abc*','*cde*'}>} number )

Hope this helps you.

Regards,

Jagan.

Re: if statement to set analysis

israrkhan — Wed, 28 Oct 2015 07:09:45 GMT

Thanks guys..

You assigned *client* to assigned_group all the time..

But i have to check if Assigned group = *client*

When Assigned_group =*client* then take *abc* else take *cde*..

Just read twice, you will get it..i think p () function will be use here....

Re: if statement to set analysis

israrkhan — Wed, 28 Oct 2015 07:16:06 GMT

Kindly see the original question, having paroblem in red area...the second if statement...

Re: if statement to set analysis

sasikanth — Wed, 28 Oct 2015 07:52:13 GMT

HI,

Try some thing like

Script level :

load *, wildmatch( assigned_group,'*client*') as FLAG;

load * from table;

Expression:

=count( {<status ={ 'Closed', 'resolved'} , measurementstatus = {'missed'},title={"$(=pick(wildmatch(FLAG,1,0),'*abc*','*cde*'))"}>}number )

Re: if statement to set analysis

jonathandienst — Wed, 28 Oct 2015 08:05:40 GMT

Your original post was not very clear. Try this:

count({< status = {'Closed' ,'resolved'}, measurementstatus = {'missed'}, assigned_group = {'*client*'}, title={'*abc*'}> +

< status = {'Closed' ,'resolved'}, measurementstatus = {'missed'}, assigned_group -= {'*client*'}, title={'*cde*'}>} number)

Re: if statement to set analysis

jonathandienst — Wed, 28 Oct 2015 08:07:55 GMT

This should work also:

count({<status = {'Closed' ,'resolved'}, measurementstatus = {'missed'}> *

(<assigned_group = {'*client*'}, title={'*abc*'}> + <assigned_group -= {'*client*'}, title={'*cde*'})>} number)