topic Re: set_analysis script in QlikView

set_analysis script

casoales1973 — Mon, 11 Aug 2014 12:55:29 GMT

Hi All,

I have the following filter to apply and I want to include all in a set_analysis script, but I dont know how is the correct syntax:

I want to reproduce the sum of stock of particular products.

I need to apply these different conditions:

<[CLASSETECNICAD] = {"01 - Camicie Uomo"} and [SOTTOCLASSETECNICAD] = {"01RE - Camicie Regolari"} and ( [CONTSTAGD] ={"B - BASIC"} or [CONTSTAGD]={"M - BASIC M/M"})

I try this but I'm sure the script not respect the filter that I want to apply

SUM(

<[CLASSETECNICAD] = {"01 - Camicie Uomo"}, [SOTTOCLASSETECNICAD] = {"01RE - Camicie Regolari"}, [CONTSTAGD] ={"B - BASIC"}, [CONTSTAGD]={"M - BASIC M/M"} >

}

GIACENZA_NEGO)

What's the correct syntax to obtain the filters needed?

Thanks in advance

Alessandro

Re: set_analysis script

maxgro — Mon, 11 Aug 2014 12:59:28 GMT

I think the problem is in the OR

SUM(

<[CLASSETECNICAD] = {"01 - Camicie Uomo"}, [SOTTOCLASSETECNICAD] = {"01RE - Camicie Regolari"}, [CONTSTAGD] ={"B - BASIC","M - BASIC M/M"} >

}

GIACENZA_NEGO)

Re: set_analysis script

casoales1973 — Mon, 11 Aug 2014 13:07:30 GMT

Works

Many thanks Massimo for your prompt support.

Re: set_analysis script

maxgro — Mon, 11 Aug 2014 13:14:37 GMT

When you think you get the answer, please close this discussion by giving Correct and Helpful answers to the posts which are useful for you. It helps others in finding answers for similar scenarios. Thanks and good Qlik.

and download this useful doc for set analysis

Sets Analysis: syntaxes, exemples