topic Re: Use expression in table box in QlikView

Use expression in table box

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Where can I tell my table box what kind of information it should show me?

E.g. I have a table box with all customer names AND the date their file has been created. But, how can I tell QV I only want a table box with customers created in 2016? Where can I write an expression that looks like CreationDate{">=01/01/2016<=31/12/2016"}?

Thanks in advance

Re: Use expression in table box

Anonymous — Mon, 17 Oct 2016 12:09:36 GMT

in a table box you cannot define expressions

you Need to use a straigth table

or if you want a table box you need to use a listbox for selecting the required dates

Re: Use expression in table box

dineshm030 — Mon, 17 Oct 2016 12:12:33 GMT

Hi Wiecke,

We can not write expression in Table Box. Have to write Straight Table.

Regards,

Dinesh Kumar M

Re: Use expression in table box

Ponkaviyarasu — Mon, 17 Oct 2016 12:28:49 GMT

Hi Peeter,

You can't give expression in Table box. Instead of Table box you can use 'Straight table'.

Thanks

Re: Use expression in table box

sasiparupudi1 — Mon, 17 Oct 2016 13:07:55 GMT

Use a straight table instead. Expressions are not available in table box. hope this helps

Re: Use expression in table box

Mon, 17 Oct 2016 13:14:58 GMT

You cannot use table box for this. Kindly use straight table and apply set analysis accordingly.

Re: Use expression in table box

awhitfield — Mon, 17 Oct 2016 13:21:42 GMT

Hi Wiebke,

you CAN'T add an expression to a Table Box.

Sorry.

Andy