topic Re: expression problem in QlikView

expression problem

Wed, 14 Aug 2013 05:16:22 GMT

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

Re: expression problem

lironbaram — Wed, 14 Aug 2013 05:17:48 GMT

may be you somthing like

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

Re: expression problem

Wed, 14 Aug 2013 05:22:51 GMT

Hi,

Close the parentheses ')' for the count function.

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

Re: expression problem

Wed, 14 Aug 2013 05:43:48 GMT

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>

Re: expression problem

Wed, 14 Aug 2013 05:47:24 GMT

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>

Re: expression problem

Wed, 14 Aug 2013 05:51:46 GMT

Hi,

Ok, try with SET analysis as below.

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

Re: expression problem

Wed, 14 Aug 2013 05:54:05 GMT

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>