topic Problem with dynamic label in table in QlikView

Problem with dynamic label in table

asa_runstrom — Fri, 04 Mar 2011 14:38:35 GMT

I have problem with my dynamic labels to my coloumns. I have three columns and it work if the first columns name is dummy1 and the second coloumns name is dummy 2 and in the third column I use the labels name to set the value in the column and write [dummy1]+[dummy2] .

But now I need to do the columns name dynamic and call the first column for ='dummy1 '&'$(monthA)' and the second column för ='dummy2 '&'$(monthA) but I dont get any value in column three if I write ['dummy1'&'$(monthA)']+['dummy2'+'$(monthA)'].

Does anyone know how to solve my problem?

Problem with dynamic label in table

stephencredmond — Fri, 04 Mar 2011 14:44:10 GMT

Hi,

Use a dollar expansion for the name reference:

[=$('dummy1'& monthA)] + [=$('dummy2'& monthA)]

Regards,

Stephen

Problem with dynamic label in table

Fri, 04 Mar 2011 14:55:44 GMT

Hi,

Do you use qv 10 ? if this is the case you can use the "Column" function, try Column(1)+Column(2) as value for the third column. I don't remember if this function has been added in version 10 if it was existing before.

Problem with dynamic label in table

johnw — Sat, 05 Mar 2011 02:13:21 GMT


RenaudCharlet wrote:I don't remember if this function has been added in version 10 if it was existing before.

I don't know when it was added, but it's been around for a long time.

Problem with dynamic label in table

asa_runstrom — Mon, 07 Mar 2011 08:33:16 GMT

I have tried your example but it doesn't work.

Problem with dynamic label in table

asa_runstrom — Mon, 07 Mar 2011 08:35:20 GMT

I use version 8.5. I can't find the "Column" function so I wonder where I can find this function.

Problem with dynamic label in table

asa_runstrom — Mon, 07 Mar 2011 09:03:29 GMT

I found the "Column" function i version 8.5.

Thank you for your help

Åsa