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: 
Not applicable

condition

Hello,

I put this expression to count Users who made orders in 2012 and 2013:


count({<Order-Year=2012, Order-Year=2013>}DISTINCT UserPK)

but it doesn't work, the second condition is not considered.

plz help

Labels (1)
12 Replies
Eugeny_Ilyin
Creator II
Creator II

Try this

count({<UserPK=

p({<[Order-Year]={'2012'}>})*p({<[Order-Year]={'2013'}>})

>} DISTINCT UserPK)

Not applicable
Author

help plz

I need common users in 2012 and 2013

Not applicable
Author

@Mr. Eugeny Ilyin it works

thank you soooo much everybody