Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Expression not working

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!

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

=COUNT(

{<

     orders_invoice_date_year ={'$(vyear1)'},

     [Delivery Method] ={'GLD'}

>}Distinct orders_order_no)

View solution in original post

2 Replies
MK_QSL
MVP
MVP

=COUNT(

{<

     orders_invoice_date_year ={'$(vyear1)'},

     [Delivery Method] ={'GLD'}

>}Distinct orders_order_no)

Anonymous
Not applicable
Author

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