Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
count({<startdate ={"<=$(=min(date))"}>} distinct Customerno)
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
count({<startdate ={"<=$(=date(max(date),'YourDateFormat'))"}>} distinct Customerno)
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?
Hi Bradley,
Simply try,
count({<startdate ={"<=$(=date)"}>} distinct Customerno)