topic Select ranges with buttons in QlikView

Select ranges with buttons

Tue, 21 Feb 2012 15:18:38 GMT

Hi, I have a field 'Serials' and I need select with buttons diferents ranges. In 'Serials' the numbers are between 11000000 - 25000000

Examples

Button 1. Must select serials >= 12500000 and <= 13000000

Button 2. Must select serials >= 15000000 and <= 25000000

I have a button with some selected values (11000000|11000001|11000002|11000003) and is OK, but in big ranges is impossible...

Thank you.

sridhar240784 — Tue, 21 Feb 2012 15:38:42 GMT

Hi,

Try using below expression.

Button 1 : ='>='&12500000&'<='13000000

Button 2 : ='>='&15000000&'<='25000000

Hope this helps you.

-Sridhar

jagan — Tue, 21 Feb 2012 15:43:05 GMT

Hi,

Try using the expression

=Concat ({<Serials={'>=12500000<=13000000'}>} DISTINCT Serials)

Hope this helps you.

Regards,

Jagan.