expression problem

[#1]

I try to use this

=count(if(year='2013' and code='12345', itmes )*25

But I do not not get the right amount

I know there is only 2 items and my result should be 50

[lironbaram]

hi

may be you somthing like

count(if(year=2013 and code=12345, itmes )*25

[#3]

Hi,

Close the parentheses ')' for the count function.

=count(if(year='2013' and code='12345', itmes ))*25

[#4]

Hi liron

Doesnt work – I do not get the right number of items

Fra: liron baram

Sendt: 14. august 2013 07:18

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: expression problem

QlikCommunity<http://community.qlik.com/index.jspa>

Re: expression problem

created by liron baram<http://community.qlik.com/people/roiuser> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/378629#378629>

[#5]

Hi venugopal4s

I got that – but it still doent give me the right amount

If I filter my fields and choose 2013 in salesyear and filter 12345 I items I get 8

But using the expression I get 64 ??

Fra: venugopal4s

Sendt: 14. august 2013 07:23

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: expression problem

QlikCommunity<http://community.qlik.com/index.jspa>

Re: expression problem

created by venugopal4s<http://community.qlik.com/people/venugopal4s> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/378630#378630>

[#6 · Accepted solution]

Hi,

Ok, try with SET analysis as below.

= COUNT({<year = {'2013'}, code = {'12345'}>} items) * 25

[#7]

Thanx – now i works

Fra: venugopal4s

Sendt: 14. august 2013 07:52

Til: Schou, Hans Henrik Søren (SSC009)

Emne: - Re: expression problem

QlikCommunity<http://community.qlik.com/index.jspa>

Re: expression problem

created by venugopal4s<http://community.qlik.com/people/venugopal4s> in Development (QlikView Desktop) - View the full discussion<http://community.qlik.com/message/378634#378634>