how to do a Filter on some codes?

[Anonymous]

Hello buddies, howdy ?
i want to apply a filter in a graph, to show only the reqired data! i know it could be done in the loading of the data but i am going to try in scripting. this is my filter but doesn't work! it is applied in the Y direction and the X is the date!  any Idea ?

[jaumecf23]

Try something like this : Sum({<CodMP={"2-L%"}>} sUmqta14)

[Anonymous]

It does not show anything , i tried!

[Anonymous]

The percentage means maybe there are some more values ! like a condition in SQL

[arvind1494]

use a set analysis to apply a specific filters on a chart

[abhijith862]

you can use Set Analysis for the same where the indirect field will influence the column

Use this Link for the Wizard which will help you in framing the same:

Set Analysis Wizard for QlikView | qlikblog.at

Regards,

Abhijith

[Digvijay_Singh]

May be this -

Sum({<CodMP={"2-L*"}>} sUmqta14)

[OmarBenSalem]

Sum({<CodMP={"2-L*"}>} sUmqta14)

this will return the sum of sUmqta14 for all the CodMP that start with 2-L

[hjimenez25]

Hi Moslem,

Maybe you can try this:

Sum ( if(WildMatch(CodMP,'2-L*') > 0,Value,null()))

I hope this helps.

Regards.