help with set analysis

[#1]

I would like to add som conditions to my analysis or (ifs)

example:

= COUNT({<year = {'2013'}, code = {'72378'}>} item) * 25 is what I´m using for 1 code.

but I got 6 codes which should be multiplied with different amounts

so something like

= COUNT({<year = {'2013'}, code = {'72378'}>} item) * 25, if code={'72379'}* 35, if code={'72380'}*5 and so on???????

[#2]

Hi,

Please try this expression

=if(code=72378,count({<year={2013}>}item)*25,if(code=72379,count({<year={2013}>}item)*35,if(code=72380,count({<year={2013}>}item)*5,...)))

[#3]

Hi nirmal

It does the count, - but not the multiplication

Fra: nirmal.j

Sendt: 15. august 2013 11:59

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

Emne: - Re: help with set analysis

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

Re: help with set analysis

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

[#4]

Can you please attach the sample application

[#5]

Sorry – not possible for this app.

Fra: nirmal.j

Sendt: 15. august 2013 12:13

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

Emne: - Re: help with set analysis

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

Re: help with set analysis

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

[#6 · Accepted solution]

Hi,

I hope the attachment will help you.

[#7]

Fik du løst denne?

Du kan lave nested if sætninger men performance på sådan noget er ikke særlig godt. Er det ikke muligt at lave i SQL databasen?

ellers skal du lave en if for hver multiplikation du vil lave for hvert statement.. tror jeg

[#8]

Hej Thomas

fik løst det

[kouroshkarimi]

Can you please mark the question as answered if it's resolved? Thanks