Peek previous count with If condition - Qlik Community

dhavalvyas · ‎2017-12-13

There is site live date and site close date.Many ATM ID is closed in 2099 and before 2099.Also there is same site ID repeated.So i want total site ID open date wise on selection of month and year.

Suppose from 100 ATM ID on 01/01/2017 10 ATM ID close so it remains with 90 and on 01/02/2017 5 new ATM ID open and 8 ATM ID close then output should be 90+5-8=87 ATM ID.

shiveshsingh · ‎2017-12-13

Are Site Live Date and ATM Live Date same? Can we take any one from these for reference?

shiveshsingh · ‎2017-12-13

Which date are u referring Site Close Date or ATM close date?

dhavalvyas · ‎2017-12-13

No both are different and we have to consider Site Live date for count.

shiveshsingh · ‎2017-12-13

What is the criteria of date selection? What is the logic for that?

dhavalvyas · ‎2017-12-13

Creating unlinked calendar.make year,month field from raw data.

count in charts should show on the selection of unlinked calendar year and month.

sunny_talwar · ‎2017-12-13

Would you be able to share the application you might be working with? It might be easy to see what you already have and carry it forward from there or make modifications