topic Dynamic lables in table in QlikView

Dynamic lables in table

vireshkolagimat — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a straight table and it contains the below fields in the order.

Week ending 1-1-2016

Month

Quarter

Year

I have added all four fields in the expressions tab and given the label manually. How to get the labels dynamically if there is change in the name of the column. Suppose if [week ending 1-1-2016] changes to [week ending 1-10-2016].

Thank You.

Regards,

Viresh

Re: Dynamic lables in table

miguelbraga — Mon, 30 May 2016 08:41:16 GMT

Hi Viresh Kolagimath,

What does your field [week ending 1-1-2016] reflects in the script? If you change Month, Quarter and Year it will make changes in your field? If yes, then a plausible answer is:

Put in the label the following expression:

= '1-' & max(Month) & '-' & max(Year)

Regards,

Re: Dynamic lables in table

vireshkolagimat — Mon, 30 May 2016 10:42:53 GMT

Hi,

The field name itself [week ending 1-1-2016] and i'm reading the this field as it is in edit script.

Regards,

Viresh

Re: Dynamic lables in table

miguelbraga — Mon, 30 May 2016 10:49:24 GMT

Change my previous solution to this:

Put in the label the following expression:

= '[Week ending 1-' & max(Month) & '-' & max(Year) & ']'

Hope this helps

Regards,

Re: Dynamic lables in table

Pulkit_Thukral — Mon, 30 May 2016 11:02:55 GMT

Try something like this

='Week Ending - ' & Date(Weekend(MAX(Datefield)),'MM-DD-YYYY')

'Week Ending - ' & Date(Weekend(today()),'MM-DD-YYYY') if this suits you.