expression to certain values

[#1]

Good Day to All

I'm new to qlikview and would like to collaborate with me doubt

1. We are loading a table from which you want the top 5 of a field but this top has something in particular and it is not all the data are in the field if not a few, in SQL equivalent to an (in) example "select * from table where field in ('a', 'b', 'c')" as this in a exprecion aria.

I thank you for your prompt response to this issue.

[jagan · Accepted solution]

Hi,

Try this expression

=Sum({<DimensionName = {'a', 'b', 'c'}>} Sales)

This way you can control the dimension values.  If not can you up with sample data and explain.

Hope this helps you.

Regards,

Jagan.

[MayilVahanan]

Hi

Try like this

=Sum({<DimensionName = {'a', 'b', 'c'}>} Sales) in chart

In Load,

Use

Load * from tablename where wildmatch(fieldname,'a','b','c');

//it load the value for a,b,c

[#4]

hi.

Thanks for the answer was very helpful, even to the use without equal.