set analysis matching dates

[#1]

hi i have the current scenario.

i have a table which holds customer information, Customerno, startdate ie . 20151110, 20151111,20151112.

i also have a calender table that is built upon the sales transaction field salesdate

from this calender i generate a date field which i use to sort my data.

what i would like to do create a set analysis whereby i chose a date from the calendertable example being 20151120 and then i would like to see how many customers where created equal to this date and before ie.  startdate <= 20151120

i have tried the following syntax without sucess,  any tips?

count({<startdate= {"<=date"}>}

Customerno)

in the qlikview application i have chosen the field date = 20151120

Best

Brad

[simenkg]

count({<startdate ={"<=$(=min(date))"}>} distinct Customerno)

[#3]

hej Simon!

thank you for your reply. however that returns the daily value for the date only and not accumulated total of all members up to the date chosen.

what i am looking for is the following

customerno startdate

10050          20151112

10060          20151113

10070          20151121

date = 20151120

the total customer count here should return 2, the total amount of customers up to that date 20151120.

Best

Brad

[Kushal_Chawda]

count({<startdate ={"<=$(=date(max(date),'YourDateFormat'))"}>} distinct Customerno)

[simenkg]

This is exactly what the expression does.

However, the output will differ if you use this in a text box or a straight table with some dimensions.

Where are you using your expression?

[tamilarasu]

Hi Bradley,

Simply try,

count({<startdate ={"<=$(=date)"}>} distinct Customerno)