Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

amirjabbar1900
New Contributor

trying to measure 2 conditions

hi,

count({<[Year]={$(=max([Year])-1)}>}EMP_STATUS='A')

in the above statement i m trying to count emp_status value A for perivous year .

is it correct ?

1 Solution

Accepted Solutions

Re: trying to measure 2 conditions

no,

Correct is as below.

count({<[Year]={"$(=max([Year])-1)"},EMP_STATUS={"A"}>}EMP_STATUS)


Regards,

Kaushik Solanki

12 Replies

Re: trying to measure 2 conditions

no,

Correct is as below.

count({<[Year]={"$(=max([Year])-1)"},EMP_STATUS={"A"}>}EMP_STATUS)


Regards,

Kaushik Solanki

OmarBenSalem
Esteemed Contributor

Re: trying to measure 2 conditions

I don't thinkk that would be ok, I would do it as follow:

count({<EMP_STATUS={'A'},[Year]={$(=max([Year])-1)}>}EMP_STATUS)

amirjabbar1900
New Contributor

Re: trying to measure 2 conditions

what if we want to calculate for the same year

amirjabbar1900
New Contributor

Re: trying to measure 2 conditions

what if we want to calculate for the same year

Re: trying to measure 2 conditions

It will be

count({<EMP_STATUS={'A'},[Year]={$(=max([Year]))}>}EMP_STATUS)

agigliotti
Honored Contributor II

Re: trying to measure 2 conditions

it should looks like below:

count( {< EMP_STATUS = {'A'}, [Year] = {"$(=Max([Year]))"}>} EMP_STATUS )

amirjabbar1900
New Contributor

Re: trying to measure 2 conditions

can i get tutorial/training guide for this ?

amirjabbar1900
New Contributor

Re: trying to measure 2 conditions

can i get tutorial/training guide for this ?

devarasu07
Honored Contributor II

Re: trying to measure 2 conditions

HI,

PFA,

Community Browser