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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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...