Discussion Board for collaboration related to QlikView App Development.
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.
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?
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;
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;
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.
It works, Thanks Chris.