Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
lalitkgehlot89
Creator II
Creator II

Count of Not present Emp in current Month.

Hi,

In provide sample data I want to check the count of Emp who was not present in last month but not in current Month.

In given date Empcode -3 is not in Mar18,

Capture.PNG

17 Replies
lalitkgehlot89
Creator II
Creator II
Author

Thanks a lot Tresesco.

Can we do it for the current month that means without any selection it should show current month not present empcode.

singbittoo
Creator
Creator

you can simply change the tresesco's expression to : it should work

=Concat(DISTINCT {<Month ,EmpCode=P({1<Month={"$(=Month(AddMonths(today(),-1)))"}>})> - <Month ,EmpCode=P({1<Month={"$(=Month(today()))"}>})>} EmpCode, ',') , check for brackets and all ..

singbittoo
Creator
Creator

Hi Tresesco, what's the use of putting Month, in set analysis ? Concat(DISTINCT {<Month, <- this one

singbittoo
Creator
Creator

you can add three more rows like

  

4/4/201812
4/4/20186
4/4/2018

7

and write the above expression it will work fine

tresesco
MVP
MVP

Current month as in system month (month(today())), or latest month available in data?

tresesco
MVP
MVP

Try removing that part and see the effect on output in the sample app. If even that doesn't help understand, let me know. I am generally lazy explaining in text.

mark6505
Partner
Partner

Hi Lalit,

How about something in script like this.

Mark

singbittoo
Creator
Creator

yes the code doesn't work, is it equivalent to ignoring month selection ? if there is something else to it can you explain it will be helpful