Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
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

6 Replies
Anonymous
Not applicable
Author

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
Creator II
Creator II

Hi Wiecke,

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

Regards,

Dinesh Kumar M

Ponkaviyarasu
Partner
Partner

Hi Peeter,

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

Thanks

sasiparupudi1
Master III
Master III

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

Not applicable
Author

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

awhitfield
Partner
Partner

Hi Wiebke,

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

Sorry.

Andy