Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
chetansehgal
Creator
Creator

Mutual Exclusion or intersection on salary for different months

Hi,

I have a requirement in which i want to show salary of employees who were part of company in Jan 2015 but not in Apr 2015 in a textbox.

Similarly salary of those employees who are part of company in Apr 2015 but not in Jan 2015.

I have below fields :

EMPID,

SAL,

YEAR

Month.

Any ideas.

Thanks.

4 Replies
ramoncova06
Specialist III
Specialist III

chetansehgal
Creator
Creator
Author

Thanks Ramon.

but its not working out..

jonathandienst
Partner - Champion III
Partner - Champion III

What did you try from these links?

If the answer is wrong, what did you get? And what did you expect?

As always, if you post a sample illustrating your issue, you will get more specific and accurate help.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
chetansehgal
Creator
Creator
Author

Hi Jonathan,

I have used some different formulas and that are working for me now.

Thanks