topic Re: Query on straight table in QlikView

Query on straight table

Mahamed_Qlik — Fri, 05 Aug 2016 11:45:09 GMT

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

Re: Query on straight table

Gysbert_Wassenaar — Fri, 05 Aug 2016 11:50:39 GMT

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)

Re: Query on straight table

Clever_Anjos — Fri, 05 Aug 2016 11:52:00 GMT

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

Re: Query on straight table

rajeshqvd — Fri, 05 Aug 2016 11:52:47 GMT

use input box.

Re: Query on straight table

Mahamed_Qlik — Fri, 05 Aug 2016 11:58:53 GMT

Hi Clever,

This check is not allowing to check :

Re: Query on straight table

Mahamed_Qlik — Fri, 05 Aug 2016 12:00:39 GMT

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

Re: Query on straight table

Gysbert_Wassenaar — Fri, 05 Aug 2016 12:02:28 GMT

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

Re: Query on straight table

Clever_Anjos — Fri, 05 Aug 2016 12:02:58 GMT

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

Re: Query on straight table

Mahamed_Qlik — Fri, 05 Aug 2016 12:27:15 GMT

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

Re: Query on straight table

Clever_Anjos — Fri, 05 Aug 2016 12:35:41 GMT

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 😃

Re: Query on straight table

Mahamed_Qlik — Fri, 05 Aug 2016 12:43:38 GMT

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

these are shown in straight table.

Re: Query on straight table

Mahamed_Qlik — Fri, 05 Aug 2016 12:46:15 GMT

Here is the screenshot:

Re: Query on straight table

Clever_Anjos — Fri, 05 Aug 2016 12:46:16 GMT

Right click into dropdown after selecting 300*

It´s in portuguese but same options

Re: Query on straight table

Clever_Anjos — Fri, 05 Aug 2016 13:45:06 GMT

Did it worked?

Re: Query on straight table

Mahamed_Qlik — Fri, 05 Aug 2016 13:51:44 GMT

Yes. Thank you so much for your hel

Regards,

Mahamed

Re: Query on straight table

Clever_Anjos — Fri, 05 Aug 2016 13:55:49 GMT

Nice!