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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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!

Labels (1)
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...