Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Plz show me the way to find out the data.

These are the sample bank transaction data.

transaction id               account        amount             transaction time(hhmmss)

------------------               -----------       ----------             ----------------------

    aaa                                a                100                 000100

    aab                                a                200                 000130

    aac                                a                100                 000200

    aad                                a                300                 000230

    aae                                a                200                 003000

    aaf                                 a                400                 000145

    bba                                b                100                 010000

    bbb                                b                200                 010030

    bbc                                b                300                 010510

    bbd                                b                300                 010520

I would like to select the RECORD or # OF TRANSACTION done by ONE account with following conditions.

1) transaction amount is 100~300 and

2) the # of transaction is more than or equal to 3 and

3) these transactions have occured within 5 minutes.

the answer of transaction id would be aaa,aab,aac,aad, bba,bbb,bbc,bbd.

I would be very habby to get the expression of the condition.

Thank you

Tags (1)
Community Browser