Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

laujerry
Contributor

set analysis for data without association

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

1 Solution

Accepted Solutions
MVP
MVP

Re: set analysis for data without association

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

)

2 Replies
MVP
MVP

Re: set analysis for data without association

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

)

laujerry
Contributor

Re: set analysis for data without association

hi

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)

Community Browser