topic Re: Filter table box rows by range in QlikView

Filter table box rows by range

mokitsu61 — Thu, 31 May 2018 06:18:08 GMT

My question is about filtering rows of Tablebox.

Tablebox:

key | value

1 | A

2 | B

3 | C

4 | D

Listbox of "key":

When we select "3" of Listbox, Tablebox shows follow,

3 | C

* key = 3

But I want to make it as follow

3 | C

4 | D

* key >= 3

Does anyone know the way for it?

Re: Filter table box rows by range

sunny_talwar — Thu, 31 May 2018 11:28:26 GMT

This won't be possible (or will need script changes) to do this in the table box... why not use a straight table instead?

Re: Filter table box rows by range

mokitsu61 — Thu, 31 May 2018 21:49:14 GMT

Hi, Sunny,

Thank you for your replying.

I(m not sticking to use Tablebox, I'm just want to show data in Table format.

So I couldn't find how to realize my requirement in Straight table too.

Do you have any ideas for it?

Thank you.

Re: Filter table box rows by range

sunny_talwar — Fri, 01 Jun 2018 00:14:27 GMT

May be like this

Dimension

value

key

Expression

Avg({<key = {"='>=' & Min(key))"}>} 1)

and then you might be able to hide your expression from the presentation tab

Re: Filter table box rows by range

mokitsu61 — Fri, 01 Jun 2018 01:57:55 GMT

Sorry, I can't understand why AVE() function is used for it...

My original requirement is that we'd like to analyze [MY DATA] and this analysis needs data that selected date to 50 years future. And show target data in Table format.

Actually we can realize it by selecting whole KEY value we need which are in Listbox, but this idea is not good for me due to mis-operations.

* I know we can select tun of items on List box easily by putting ">XXXXXX" into search box of Listbox, but I think selecting over 18,000 items (365days * 50year) on Listbox will be no suitable for us...

MY DATA (Over 1,000,000 rows) :

KEY| VALUE

01-Apr-2010 | A

01-Apr-2010 | B

02-Apr-2010 | C

03-Apr-2010 | D

...

31-Mar-2050 | ZZZZZ

Thank you.

Re: Filter table box rows by range

sunny_talwar — Fri, 01 Jun 2018 02:07:43 GMT

I get all that... and all you need is a straight table object with all your dimensions and just one dummy expression which will take care of your requirement. Does that make sense?

Re: Filter table box rows by range

mokitsu61 — Fri, 01 Jun 2018 07:09:16 GMT

Sorry again,

It make sense about using Straight table.

But I can't under stand your set analysis.

Do you know any references for it?

Re: Filter table box rows by range

sunny_talwar — Fri, 01 Jun 2018 08:58:44 GMT

Check here

Set Analysis: syntaxes, examples

Re: Filter table box rows by range

mokitsu61 — Fri, 01 Jun 2018 09:05:10 GMT

Thanks, I'll check it.

Re: Filter table box rows by range

mokitsu61 — Mon, 04 Jun 2018 02:23:28 GMT

Hi Sunny,

> Avg([<key = {"='>' & Min(key))"}>} 1)

I couldn't find above format in your document...

Can you give me more hints about it?

Re: Filter table box rows by range

sagar_puri — Mon, 04 Jun 2018 05:47:39 GMT

Try This,

=only({<Key={">=$(=Key)<=$(=max({<Key=>}Key))"}>}Value)

Regards,

Re: Filter table box rows by range

mokitsu61 — Mon, 04 Jun 2018 07:59:25 GMT

Thank you for your replying.

How specify the value of [Value] when [Value] are several items?

I'm really happy by your response and I want to realize your advice on my PC.

MY DATA (Over 1,000,000 rows) :

KEY| VALUE1 | VALUE2

01-Apr-2010 | A | a

01-Apr-2010 | B | b

02-Apr-2010 | C | c

03-Apr-2010 | D | d

...

31-Mar-2050 | ZZZZZ | zzzzz

Thank you.

Re: Filter table box rows by range

sagar_puri — Mon, 04 Jun 2018 09:25:37 GMT

Hi,

I hope this is what you are asking, Keep the Dimension as Key and add 2 expressions here,

=only({<Key={">=$(=Key)<=$(=max({<Key=>}Key))"}>}Value1),

=only({<Key={">=$(=Key)<=$(=max({<Key=>}Key))"}>}Value2)

Regards,

Re: Filter table box rows by range

mokitsu61 — Mon, 11 Jun 2018 05:42:42 GMT

Thanks!