how to create a dynamic dimension or flag in qlik sense

[vikasmahajan]

Hi ,

Attaching QVF file  my requirement is within selected financial year I want to create a dynamic dimension which will identify the active/in-active customer also I need to classify Single/Multi means I want dimension whether customer feed fuel one time (Single) or more than one time Multi.

I have attached QVF & DATA.

Thanks in Adv.

Vikas

[rangam_s]

Try this, wherein you can see the status by Year for that CARD_ROOT_ID.

Data:

LOAD

    CARD_ROOT_ID,

    LOYALTY_PROGRAM_TYPE,

    "Customer Code",

    CARD_ROOT_ID & '|' & "Customer Code" as CustomerCardKey,

    PRODUCT_TYPE,

    "Sales Value",

    "Sales Volume",

    TXN_DATE,

    text(Year(TXN_DATE)) as Year,

    TRANSACTION_COUNT,

    CARD_TYPE,

    PREVIOUS_CARD_TYPE,

    AVG_RSP,

    CARD_CREATION_DATE

FROM [lib://BPCL/ROOT CARD Id.xls]

(biff, embedded labels, table is [ROOT CARD Id$]);

Join(Data)

Load CARD_ROOT_ID,

text(Year(TXN_DATE)) as Year,

    sum(TRANSACTION_COUNT) as TRANSACTIONS,

     if(sum(TRANSACTION_COUNT)=1,'Once','Multiple Time') as Status

Resident Data Group By CARD_ROOT_ID,text(Year(TXN_DATE));