topic Re: Using an expression for the header in table in QlikView

Using an expression for the header in table

Black_Hole — Sat, 16 Nov 2024 18:12:30 GMT

Hello all,

I put an expression in the title/header of a graph table.

But, it's seems that's the expression is not working because none result is displayed.

Below, the expression defined:

(note: the expression should return a date)

Please could you advise me about this issue?

Thank you in advance for your help.

Re: Using an expression for the header in table

tresB — Thu, 20 Aug 2020 10:46:09 GMT

FGCRL TransactionDate seems to be a field and it would probably have multiple values. Unless you select one date from this list, qlik would not know which date value to work on. Make a selection in your field, you would probably see a date as output. Also, there should be an easier and better way of getting a date in desired format, like using date#() or/and date().

Re: Using an expression for the header in table

Black_Hole — Thu, 20 Aug 2020 12:34:35 GMT

Hello @tresB ,

Effectively! When I make a selection on the TransactionDate, the expression works as expected.

Thank you very much for your detailed explanation!