topic set analysis for data without association in QlikView

set analysis for data without association

laujerry — Wed, 18 Jun 2014 16:16:47 GMT

hello all,

i hv a sales table, with invoice date and is used as master calendar

member is in sales table to indicate the buyer

on the other hand, there is a member master, with join date inside

sales:

inv_date, inv_date_year, inv_month, member_id ...

member:

member_id, join_date, ..., sumcount

i want to count the # of new join member within a selected period (using inv_date)

but i cant count those member who join but make no purchase at all, even using set analysis

Sum(

{$<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }>}

sumcount

)

is there no way for me to do the counting using the same data model?

thanks

Re: set analysis for data without association

swuehl — Wed, 18 Jun 2014 18:30:10 GMT

As I read your request, you select a period in sales table field inv_date. This will associate only members in member table that have record in sales table, as long as you use the default state for your analysis. But what about using the set identifier 1?

Sum(

{1<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }>}

sumcount

)

or disregarding the explicit selections on inv_date:

Sum(

{$<joint_date = { ' >=$(=Min(inv_date)) <=$(=Max(inv_date)) ' }, inv_date= >}

sumcount

)

Re: set analysis for data without association

laujerry — Thu, 19 Jun 2014 16:01:22 GMT

your answer is correct, but i forget to tell u that, my expression is a chart expression

the solution works perfectly in a text object expression

but will still be affected by dimensions if put inside a chart expression

in my case, my expression "count" is under dimension "inv_date"

so putting 1 as set identifier seems not working (member without sales still not shown under certain period)