Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
1 Reply
maxgro
MVP
MVP

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

or

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