Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
prathipsrinivas
New Contributor III

Disregard selection in expression only not in dimension of Straight Table

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

2 Replies
chrismarlow
Contributor III

Re: Disregard selection in expression only not in dimension of Straight Table

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;

318630.png

Hope that helps.

Cheers,

Chris.

Highlighted
prathipsrinivas
New Contributor III

Re: Disregard selection in expression only not in dimension of Straight Table

It works, Thanks Chris.

Cheers,

Prathip

Community Browser