Disregard selection in expression only not in dimension of Straight Table

[prathipsrinivas]

Hi All,

I would like to limit the rows of Straight table  using date filter but expression requires to consider all the date to give correct information.

For Example,

I would to show only claims whose Entrydate lies in current month but in expression i would like to sum all the transactions made.

Is there any way to achieve it?

Thanks,

Prathip

[chrismarlow]

Prathip,

You can use set analysis and P() function to give set of claims subject to current selection & 'cancel' the selection by date. So taking a toy set of data;

data:

LOAD * INLINE [

    Claim, EntryDate, Transaction, TransactionValue

    A, 01/02/2018, 2, 10

    A, 01/01/2018, 1, 5

    B, 01/02/2018, 1, 15

    C, 01/01/2018, 1, 20

];

I can use;

Count({<EntryDate=,Claim=P({$} Claim)>}Transaction)

Sum({<EntryDate=,Claim=P({$} Claim)>}TransactionValue)

And see that when I select just 01/02/2018 I see all transaction for A and the one transaction for B & C is supressed;

Hope that helps.

Cheers,

Chris.

[prathipsrinivas]

It works, Thanks Chris.

Cheers,

Prathip