Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
er_abhichandra
Contributor III
Contributor III

Help with logic

Hi All,

I have a scenario where I have a list of Partners for an organization and their particular sales data according to Year-Quarter.

I want to find out a list of 'Net New Dormant' partners for the Year-Quarter selected. The logic for finding 'Dormant' partners for the select Year-Quarter is that if the Partners has not had any sales in the Previous 2 quarters and current quarter, but had sales in the 7 quarter before the Previous 2 quarters, then it is a 'Dormant' partner in the selected Year-Quarter.

For e.g.:

Selected Year-Quarter - '2014 Q4'

Sales in Quarter '2014 Q4', '2014 Q3', '2014 Q2' = 0(zero)

Sales in Quarters '2012 Q3'-'2014 Q1' is not 0(zero)

Now I want to find the 'Net New Dormant' which basically tells me how many NEW dormant partners I have in the selected Year-Quarter, which basically means the partner was not dormant in the previous Year-Quarter but it is in the selected Year-Quarter.

It employs the same Dormant logic for the calculation.

If need I can provide a sample data qvw.

Thanks,

Abhinava

1 Solution

Accepted Solutions
er_abhichandra
Contributor III
Contributor III
Author

Hi All,

I have developed a Solution for this.

Regards,

Abhinava

View solution in original post

3 Replies
Not applicable

Ya. Please provide the sample data.

er_abhichandra
Contributor III
Contributor III
Author

Hi,

Attached is the sample data file.

Thanks,

Abhinava !

er_abhichandra
Contributor III
Contributor III
Author

Hi All,

I have developed a Solution for this.

Regards,

Abhinava