topic Re: set analysis matching dates in QlikView

set analysis matching dates

Wed, 02 Dec 2015 08:33:10 GMT

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

Re: set analysis matching dates

simenkg — Wed, 02 Dec 2015 08:57:25 GMT

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

Re: set analysis matching dates

Wed, 02 Dec 2015 09:01:59 GMT

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

Re: set analysis matching dates

Kushal_Chawda — Wed, 02 Dec 2015 09:04:11 GMT

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

Re: set analysis matching dates

simenkg — Wed, 02 Dec 2015 09:08:45 GMT

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?

Re: set analysis matching dates

tamilarasu — Wed, 02 Dec 2015 09:09:09 GMT

Hi Bradley,

Simply try,

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