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

[Gysbert_Wassenaar]

Add a slider with two variables vMin and vMax. Give both variables reasonable min and max ranges. This slider can be used to change the range of sales that the user wants to see. Change your expression to use the variables to select the months that meet the wanted range: sum({<Sales={">$(vMin)<$(vMax)"}>}Sales)

[Clever_Anjos]

Enable "Searchable" at Presentation Tab and check if fits you needs

[rajeshqvd]

use input box.

[Mahamed_Qlik]

Hi Clever,

This check is not allowing to check :

[Mahamed_Qlik]

Hi Gysbert,

You are correct but, what if I do have multiple expression ?

for example I want to put this in Ad hoc report wherein, there are multiple dimensions and measures

and user will select any of them.

Regards,

Mahamed

[Gysbert_Wassenaar]

Add that extra bit I added to sum(Sales) to every expression in your table.

[Clever_Anjos]

• Is it a Straight table?
• Did you select the expression you want to search on "columns" list?

[Mahamed_Qlik]

Yes..I did now.

It works. Thank you so much again.

I have one more requirement in this,

There is one dimension named as ticket number and values are like 300123,300222,451225,898556,300252

And user to search but wants  exclude the ticket number starting with 300.

This is the same dimension list in above straight table. and as said before the searchable is not active for dimension list.

Kindly help.

Regards,

Mahamed

[Clever_Anjos]

Two approaches

• Mark that column as "DropDown", so your user selects 300* and then "Select Excluded"
• use Sum({<Dim-={"300*"}>}Value) (please note the - sign before 😃