Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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
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.

Highlighted
Partner
Partner

Re: Use expression in table box

Hi Wiebke,

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

Sorry.

Andy