Query on straight table

[Mahamed_Qlik]

Dear all,

I need quick help on the below requirement :

Requirement :

In straight table, I have dimension month and one expression named as sales.

Expression for sales : Sum(Sales)

So it looks like :

Month	Sales
JAN	1200
FEB	1000
MAR	5000
APR	2500

So, the requirement is user want to see any random range of sales, for example he wants to see sales >500 and <1000

or sales >1000 and <2500

And this selection he wants to done in table itself. How can this be done ?

In general, this can be achieved, if the sales is only showing in list box then we can directly search as

>500<1000 and we will get the resulted value in list box.

So how this can be done using straight table ?

Regards,

Mahamed

[Mahamed_Qlik]

I am not getting select exclude...because I am not using single list box for tht dimension.

these are shown in straight table.

[Mahamed_Qlik]

Here is the screenshot:

[Clever_Anjos · Accepted solution]

Right click into dropdown after selecting 300*

It´s in portuguese but same options

[Clever_Anjos]

Did it worked?

[Mahamed_Qlik]

Yes. Thank you so much for your hel

Regards,

Mahamed

[Clever_Anjos]

Nice!