topic Re: Expression not working in QlikView

Expression not working

Anonymous — Wed, 05 Nov 2014 16:23:01 GMT

Hi guys,

I have an expression

=COUNT({<orders_invoice_date_year ={$(vyear1)}>}{<[Delivery Method] ={'GLD'}>}Distinct orders_order_no)

The second part of this seems to work where the delivery method = 'GLD' but the first part where i want to show only the orders where the variable is vyear1 is being ignored...

i am obviously missing something in this expression.

Can someone point me in the right direction with this?

Thanks!

Re: Expression not working

MK_QSL — Wed, 05 Nov 2014 16:30:22 GMT

=COUNT(

orders_invoice_date_year ={'$(vyear1)'},

[Delivery Method] ={'GLD'}

>}Distinct orders_order_no)

Re: Expression not working

Anonymous — Wed, 05 Nov 2014 16:49:36 GMT

Absolutely brilliant. Thanks very much Manish! I knew this would be simple for someone...