topic expression to certain values in QlikView

expression to certain values

Tue, 02 Jul 2013 16:37:26 GMT

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.

Re: expression to certain values

jagan — Tue, 02 Jul 2013 17:30:21 GMT

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.

Re: expression to certain values

MayilVahanan — Tue, 02 Jul 2013 17:40:06 GMT

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

Re: expression to certain values

Tue, 02 Jul 2013 22:01:19 GMT

hi.

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