set_analysis script

[casoales1973]

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

[maxgro]

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)

[casoales1973]

Works

Many thanks Massimo for your prompt support.

[maxgro]

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