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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

expression combination

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 Solution

Accepted Solutions
jagan
Partner - Champion III
Partner - Champion III

Hi,

Create a Straight table and try like this

Dimension : Date              

Expression 1 - Total of all Directive:

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

Expression 2 - Total of all EDI:

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


Now select Sum of Expressions option in

Chart Properties -> Expression tab.


Regards,

Jagan.

View solution in original post

4 Replies
MK_QSL
MVP
MVP

can you briefly explain how below coming?

Date               UNLOAD_TO_DIRECTIVE               EDI

Total              4                                                   2

13/01/2014     2                                                   1

14/01/2014     2                                                   1

Not applicable
Author

UNLOAD_TO_DIRECTIVE = COUNT OF ALL ITEMS UNDER UNLOAD_TO_DIRECTIVE IN THIS CASE 4

EDI = COUNT OF EDI AND EDI* IN THIS CASE 2

jagan
Partner - Champion III
Partner - Champion III

Hi,

Create a Straight table and try like this

Dimension : Date              

Expression 1 - Total of all Directive:

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

Expression 2 - Total of all EDI:

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


Now select Sum of Expressions option in

Chart Properties -> Expression tab.


Regards,

Jagan.

Anonymous
Not applicable
Author

See attachment.