topic Re: Help with SET ANALYSIS in QlikView

Help with SET ANALYSIS

Wed, 11 Jul 2012 12:49:10 GMT

Hi guys,

I'm in trouble with an expression.

I have to do the sum of Field3 ONLY if Field1 = Field2.

I tried to solve my problem using this expression:

=sum( {$<Field1 = Field2>} Field3 )

but unfortunately it doesn't work.

It works fine only if I select a value from a list box, but I need it works with any selection.

Any help will be appreciated.

Thanks in advance

Re: Help with SET ANALYSIS

Wed, 11 Jul 2012 12:59:01 GMT

Set analysis is based on selected vlaues. If you want it to work without the selection try sum(if()) something like: sum(if(Field1= Field2, Field3,0) Regards Rahul Lakhina

Re: Help with SET ANALYSIS

Wed, 11 Jul 2012 13:07:28 GMT

Hi Rahul,

First of all, thank you so much for your reply.

I alredy tried that kind of formula and it doesn't work.

I thought it could work.

Regards

Giampiero

Re: Help with SET ANALYSIS

Wed, 11 Jul 2012 13:11:22 GMT

What data do you have in Field 1 and 2 can you post an example? Plus you might have to aggr this over your dimension. Try: aggr(sum(if(Field1= Field2, Field3,0) ,dimension) Regards RL

Re: Help with SET ANALYSIS

Wed, 11 Jul 2012 13:17:57 GMT

Try the set analysis wizard from Qlikblog

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

Re: Help with SET ANALYSIS

Wed, 11 Jul 2012 13:28:59 GMT

Field 1 and 2 are plates of trucks.

Unfortunately it's quite difficult to me to post an example.

I tried aggr function but it doesn't work.

Thanks Rahul.

Regards

Giampiero

Re: Help with SET ANALYSIS

Wed, 11 Jul 2012 14:29:46 GMT

Rahul,

I can say you that Field 1 is in TAB1, Field2 & Field3 are in TAB2.

Hope it helps to better understand.

@Chris: Thanks a lot

regards

Giampiero