topic Re: help with set analysis in QlikView

help with set analysis

Thu, 15 Aug 2013 09:51:25 GMT

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???????

Re: help with set analysis

Thu, 15 Aug 2013 09:58:37 GMT

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,...)))

Re: help with set analysis

Thu, 15 Aug 2013 10:08:57 GMT

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>

Re: help with set analysis

Thu, 15 Aug 2013 10:13:01 GMT

Can you please attach the sample application

Re: help with set analysis

Thu, 15 Aug 2013 10:33:27 GMT

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>

Re: help with set analysis

Thu, 15 Aug 2013 14:51:10 GMT

Hi,

I hope the attachment will help you.

Re: help with set analysis

Tue, 05 Nov 2013 12:43:45 GMT

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

Re: help with set analysis

Tue, 05 Nov 2013 13:38:02 GMT

Hej Thomas

fik løst det

Re: help with set analysis

kouroshkarimi — Tue, 05 Nov 2013 13:59:18 GMT

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