topic Re: expression combination in QlikView

expression combination

Wed, 09 Jul 2014 18:50:27 GMT

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

MK_QSL — Wed, 09 Jul 2014 22:04:51 GMT

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

Wed, 09 Jul 2014 22:58:14 GMT

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 — Thu, 10 Jul 2014 02:13:55 GMT

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 — Thu, 10 Jul 2014 02:39:35 GMT

See attachment.