Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
vikasmahajan
Champion
Champion

how to create a dynamic dimension or flag in qlik sense

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

1 Reply
rangam_s
Creator II
Creator II

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));