Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

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
MVP & Luminary
MVP & Luminary

no,

Correct is as below.

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


Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

12 Replies
MVP & Luminary
MVP & Luminary

no,

Correct is as below.

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


Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

Partner
Partner

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

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

Contributor III
Contributor III

what if we want to calculate for the same year

Contributor III
Contributor III

what if we want to calculate for the same year

MVP & Luminary
MVP & Luminary

It will be

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Partner
Partner

it should looks like below:

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

Contributor III
Contributor III

can i get tutorial/training guide for this ?

Contributor III
Contributor III

can i get tutorial/training guide for this ?

Master II
Master II

HI,

PFA,