Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
moslem_teymoori
Creator
Creator

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
Creator III
Creator III

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

moslem_teymoori
Creator
Creator
Author

It does not show anything , i tried!

moslem_teymoori
Creator
Creator
Author

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

arvind1494
Specialist
Specialist

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

abhijith862
Contributor III
Contributor III

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
Partner - Champion II
Partner - Champion II

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


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

hjimenez25
Partner - Contributor II
Partner - Contributor II

Hi Moslem,

Maybe you can try this:

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

I hope this helps.

Regards.