topic Re: help with set analysis in QlikView

help with set analysis

Mon, 12 Aug 2013 09:48:44 GMT

Good morning,

I am struggling with this problem that involves set analysis. My objective is to calculate the count of inspections but considering different weights for each Category (2 and 3 have double weight) if MotivoID is 1, because if it is 2 should be single weight as it is for categories 1, 6 and 7.

My code is:

= (if(Ano > 2011 and MotivoID <> 2,

( 2 * Count({$< CategoriaID = {"2"} >} InspeccaoID ) +

// Count({$< CategoriaID = {"2"} >} InspeccaoID ) +

// Count({$< CategoriaID = {"3"} >} InspeccaoID ) +

2 * Count({$< CategoriaID = {"3"} >} InspeccaoID ) +

Count({$< CategoriaID = {"1"} >} InspeccaoID ) +

Count({$< CategoriaID = {"6"} >} InspeccaoID ) +

Count({$< CategoriaID = {"7"} >} InspeccaoID )

))

if(Ano > 2011,

count({$ <[MotivoID] = {"2"}>} InspeccaoID)))

So far it hasn't gave me the results I am looking for.

Any help will be very helpful.

Thanks in advance,

afonso

Re: help with set analysis

shahamel — Mon, 12 Aug 2013 11:08:34 GMT

Try this url

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

Gr. Sandeep

Re: help with set analysis

shahamel — Mon, 12 Aug 2013 11:29:06 GMT

Would you be so kind to send me a small file with an inline table which gives me a small example containing the fields:

Ano, MotivoID, CategoriaID and InspecaoID

In the meantime you can also use this document:

http://www.google.nl/url?sa=t&rct=j&q=p%20possible%20e%20exclude%20qlikview&source=web&cd=1&ved=0CCoQFjAA&url=http%3A%2F%2Fcommunity.qlik.com%2Fservlet%2FJiveServlet%2FpreviewBody%2F1867-102-1-1858%2FQlikLearn-Set-Analysis-Presentation.pdf&ei=o8QIUtjoK8nusgaTzICABQ&usg=AFQjCNFzmcFiFOtzkNgUP25yrI16xAiHxw&bvm=bv.50500085,d.Yms

Re: help with set analysis

Mon, 12 Aug 2013 11:31:32 GMT

I think I managed to find a solution that solve my problem.

Thanks to all that try to help me.

Re: help with set analysis

Wed, 14 Aug 2013 08:48:09 GMT

Thanks Sandeep. With all this notes I managed to solve my problem.

Best regards,

Afonso Lopes

De: Sandeep Hamelink

Enviada: segunda-feira, 12 de Agosto de 2013 12:29

Para: Afonso Lopes

Assunto: - Re: help with set analysis

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

Re: help with set analysis

created by Sandeep Hamelink <http://community.qlik.com/people/shahamel> in New to QlikView - View the full discussion <http://community.qlik.com/message/377835#377835>