Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
bwisealiahmad
Partner
Partner

How many payments within 10 days, 20 days etc.

Hi,


Trying to solve an issue here.

Company A has 3 different campaigns with different start dates. What I am trying to do is see how many payments came were received 10 days of sending out the campaign, 20 days etc from the starting date.

The idea is when you pick lets say Campaign X you can then see with bar charts how many payments were received within 10 days, within 20 days, and so on.

Any ideas? I've been thinking the class function.

1 Reply
amayuresh
Creator III
Creator III

I think this answer your question,

Output

1.PNG

Expression: Amount =sum({<Date={'>=$(=Date(aggr(Max(Date),Complain)-$(vDays)))'}>}Amount)