Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

combination expression

Hey All

Need to make a combination expression :

Following expression is working

=count({<Date={">=$(vStartDate)<=$(vEndDate)"}>}SALES)

Date               UNLOAD_TO_DIRECTIVE               EDI

13/01/2014     EDI                                                EDI

13/01/2014     KLBIKK                                          KLBIKK

14/01/2014     BLE014                                          BLE014  

14/01/2014     EDI + 20                                         EDI + 20

Need the following overview - total of all directive and total of all EDI*

Date               UNLOAD_TO_DIRECTIVE               EDI

Total              4                                                   2

13/01/2014     2                                                   1

14/01/2014     2                                                   1

Can some help me out plse

Tks

Rudi

1 Reply
maxgro
MVP
MVP

count( {<Date={">=$(vStartDate)<=$(vEndDate)"},EDI={"EDI*"}>}EDI)

or

count(total {<Date={">=$(vStartDate)<=$(vEndDate)"},EDI={"EDI*"}>}EDI)