topic Re: multiple condition on expression in QlikView

multiple condition on expression

Anonymous — Thu, 26 Oct 2017 09:05:07 GMT

hi.

i m trying to add multiple condition on expression formula colum

like fallowing are the condition

select count(e.EMP_ID)

from ATTENDANCE_NEW.LEFT_REJOIN l,ATTENDANCE_NEW.EMP e,ATTENDANCE_NEW.DEPT d

where e.EMP_ID=l.EMP_ID

and e.DEPT_ID=d.DEPT_ID

and l.STATUS in ('Resigned' ,'Weeded Out');

and i want to put this condition like this

COUNT( {<Status={'Resigned','Weeded Out'}>} Status)

Re: multiple condition on expression

Anil_Babu_Samineni — Thu, 26 Oct 2017 09:12:31 GMT

Use this?

Where Match(Status,'Resigned', 'Weeded Out')

Re: multiple condition on expression

Anonymous — Thu, 26 Oct 2017 09:19:34 GMT

but here i need to count emp_id , and status condition are 'Resigned', 'Weeded Out'

this fallowing condition only count status , with condition 'Resigned', 'Weeded Out'

but i need to count emp_id

COUNT( {<Status={'Resigned','Weeded Out'}>} Status)

Re: multiple condition on expression

Anonymous — Thu, 26 Oct 2017 09:25:58 GMT

count(Emp_ID) Where Match(Status,'Resigned', 'Weeded Out')

will this correct

Re: multiple condition on expression

tresB — Thu, 26 Oct 2017 09:27:52 GMT

If your qv data model is properly associated (two tables are linked/joined with key field) , expression below might work:

COUNT( {<Status={'Resigned','Weeded Out'}>} emp_id)

Give a try.

Re: multiple condition on expression

Anil_Babu_Samineni — Thu, 26 Oct 2017 09:29:45 GMT

Yes, But for Aggregate functions you may need Group By clause?? Like

Load Field, Status, Count(Emp_ID) as Count_Emp_ID Where Match(Status, 'Resigned','Weeded Out') Group By Field, Status;

Re: multiple condition on expression

Anonymous — Thu, 26 Oct 2017 09:36:22 GMT

but its expression for measure

i dont think so i measure group by works

Re: multiple condition on expression

Anonymous — Thu, 26 Oct 2017 09:37:47 GMT

ya qv data model is properly associated

and

seems correct but data is not correct

Re: multiple condition on expression

Anil_Babu_Samineni — Thu, 26 Oct 2017 09:38:49 GMT

In UI, you can follow Tresesco solution, But you said, The values are wrong. How we know whether values are tested one or not.

Re: multiple condition on expression

sunny_talwar — Thu, 26 Oct 2017 11:46:56 GMT

Would you be able to share an image of your data model?