Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
davinfrost
Contributor III
Contributor III

select just 1 month from 1 field

hi guys, i have a case,
when i filter date, i choose month , on november.
as we can see on the table, all data showed based on paymentdate.

 

BranchInvoiceNoInvoiceDatePaymentDate KEY_DATEFLAG_TRANSTERMSIDCOD_GROUPCOD_INVOICE
CAA CISI 18 1918 CAA10/30/201811/8/201820181108Duedate_Inv1>7 DAYS9
CAA CISI 18 1923 CAA11/1/201811/2/201820181102Duedate_Inv11 DAYS1
CAA CISI 18 1927 CAA11/1/201811/16/201820181116Duedate_Inv1>7 DAYS15
CAA CISI 18 1954 CAA11/9/201811/19/201820181119Duedate_Inv1>7 DAYS10

 

 

i use this :

 

count(aggr(sum(
{<
TERMSID={'1'},
FLAG_TRANS={'Duedate_Pelunasan_Inv'},
COD_GROUP={'>7 DAYS'},

Day={">=$(=Num(Min(Day)))<=$(=Max(Day))"},
// Month={'$(=max(Month))'},
Year={'$(=max(Year))'}
>} 
COD_INVOICE),[Invoice No]))


how to change based into invoicedate, so if i choose november, only invoicedate on november are show? because its still appear 1 data from october? did i miss something?

 

 

thank you.

2 Replies
Anil_Babu_Samineni

May be ignore the field

count(aggr(sum(
{<
TERMSID={'1'},
FLAG_TRANS={'Duedate_Pelunasan_Inv'},
COD_GROUP={'>7 DAYS'},

Day={">=$(=Num(Min(Day)))<=$(=Max(Day))"},
// Month={'$(=max(Month))'},
Year={'$(=max(Year))'}, invoicedate=
>} 
COD_INVOICE),[Invoice No]))
Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Zhandos_Shotan
Partner - Creator II
Partner - Creator II

Hi!

May be like this:

 

Max( 
Aggr( 
Count({<InvoiceNo={"=Month(InvoiceDate)=Month(PaymentDate)"}>} InvoiceNo), 
InvoiceNo)
)

Check attached sample

Best regards