Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
Works
Many thanks Massimo for your prompt support.
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