Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
MVP
MVP

Re: expression combination

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.

4 Replies
MVP
MVP

Re: expression combination

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

Re: expression combination

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

MVP
MVP

Re: expression combination

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.

satyadev_j
Valued Contributor

Re: expression combination

See attachment.

Community Browser