Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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)

Anonymous
Not applicable
Author

It does not show anything , i tried!

Anonymous
Not applicable
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

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.