Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Use expression in table box

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

Tags (1)
6 Replies
Highlighted
Partner
Partner

Re: Use expression in table box

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

dineshm030
Contributor II

Re: Use expression in table box

Hi Wiecke,

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

Regards,

Dinesh Kumar M

Partner
Partner

Re: Use expression in table box

Hi Peeter,

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

Thanks

sasiparupudi1
Honored Contributor III

Re: Use expression in table box

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

Not applicable

Re: Use expression in table box

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

Partner
Partner

Re: Use expression in table box

Hi Wiebke,

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

Sorry.

Andy