Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Select ranges with buttons

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.

1 Solution

Accepted Solutions
sridhar240784
Not applicable

Select ranges with buttons

Hi,

Try using below expression.

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

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

Hope this helps you.

-Sridhar


2 Replies
sridhar240784
Not applicable

Select ranges with buttons

Hi,

Try using below expression.

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

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

Hope this helps you.

-Sridhar


jagan
Not applicable

Select ranges with buttons

Hi,

Try using the expression

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

Hope this helps you.

Regards,

Jagan.