Measure in Dimension

[ck95]

Hello,

I have this expression:

IF(aggr(Text(count({1<[datum]={">=$(=date(today()-365,'YYYY-MM-DD'))"}>}distinct [oid])), [customer_uid2]) > '1', 'excisting customer', 'new customer')

This expression is working in Set Analysis in Qlik Sense as an measure but I need this as a dimension.

Can anyone help me?

[Rohan]

Hi, try this:

custmap:

Mapping Load

[customer_uid2], 

'existing customer' as Flag

where no_of_orders>1;

load 

[customer_uid2],

count(distinct oid) as no_of_orders

from Data where datum>=$(=date(today()-365,'YYYY-MM-DD')) group by [customer_uid2];

Data:

Load *,

applymap('custmap',[customer_uid2],'new customer') as newFlag

from Data;