topic Re: condition in QlikView

condition

Wed, 29 May 2013 10:06:03 GMT

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

Re: condition

Wed, 29 May 2013 10:07:50 GMT

Try this,

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

Thanks

Re: condition

somenathroy — Wed, 29 May 2013 10:08:32 GMT

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

Regards,

som

Re: condition

alexandros17 — Wed, 29 May 2013 10:08:48 GMT

if Order-Year is a field you have to

count({$ <[Order-Year]={'>=2012<=2013'}>}DISTINCT UserPK)

hope it helps

Re: condition

Wed, 29 May 2013 10:16:57 GMT

thank u, but it doesn't work

I have 781 users in 2012

409 users in 2013

when I use this expression it gives 906 users!!

it must be less than 409

Re: condition

Gysbert_Wassenaar — Wed, 29 May 2013 10:26:06 GMT

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

Re: condition

Wed, 29 May 2013 10:27:29 GMT

the same result

Re: condition

Wed, 29 May 2013 10:29:20 GMT

if(Order-Year=2012 and Order-Year = 2013, count(distinct UserPK))

Re: condition

Wed, 29 May 2013 10:32:07 GMT

try this

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

Re: condition

Wed, 29 May 2013 10:34:20 GMT

@ Mr. Gysbert Wassenaar : there is an error in this expression

Re: condition

Eugeny_Ilyin — Wed, 29 May 2013 11:13:39 GMT

Try this

count({<UserPK=

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

>} DISTINCT UserPK)

Re: condition

Wed, 29 May 2013 11:15:54 GMT

help plz

I need common users in 2012 and 2013

Re: condition

Wed, 29 May 2013 11:21:30 GMT

@Mr. Eugeny Ilyin it works

thank you soooo much everybody