Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

moslem_teymoori
Contributor

how to do a Filter on some codes?

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 ?Cattura.JPG

8 Replies
jaumecf23
Contributor III

Re: how to do a Filter on some codes?

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

moslem_teymoori
Contributor

Re: how to do a Filter on some codes?

It does not show anything , i tried!

moslem_teymoori
Contributor

Re: how to do a Filter on some codes?

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

arvind1494
Contributor III

Re: how to do a Filter on some codes?

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

abhijith862
New Contributor III

Re: how to do a Filter on some codes?

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
Honored Contributor III

Re: how to do a Filter on some codes?

May be this -

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

omarbensalem
Esteemed Contributor

Re: how to do a Filter on some codes?

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


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

hjimenez25
New Contributor II

Re: how to do a Filter on some codes?

Hi Moslem,

Maybe you can try this:

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

I hope this helps.

Regards.