topic Re: Item with "variable" name in QlikView

Item with "variable" name

danosoft — Thu, 05 Apr 2018 13:52:43 GMT

Hi i wanna take in my text box a field of my table with name according with the selected year. I try to explain, i have these 3 fields:

FIELD1_2017

FIELD1_2018

FIELD1_2019

When i select my year filed (for example 2018), i want in my text box i see : Sum(FIELD1_2019)

i know i can do that with some IF statement, but is possible in qlikview call a field composing it runtime with

name=FIELD1_ + selected year ? like Sum(FIELD1_[SELECTED_YEAR])

Re: Item with "variable" name

eliran — Thu, 05 Apr 2018 14:18:09 GMT

Dear Daniele,

You can accomplish this with a variable easily:

vField==FIELD1_'&GetFieldSelections(Year)

sum($(vField)) inside the chart/text box.

BR,

Eliran.

Re: Item with "variable" name

danosoft — Thu, 05 Apr 2018 14:31:24 GMT

Ok thanks, but it show me 0, if i show only the variable it show me correctly the name

Re: Item with "variable" name

vishsaggi — Thu, 05 Apr 2018 14:40:54 GMT

Can you share some sample data and your expected output here?

Re: Item with "variable" name

marcus_sommer — Thu, 05 Apr 2018 14:45:20 GMT

In general the logic suggested from Eliran will work and probably there is just an issue with syntax. Personally I would probably use something like this:

sum($(='FIELD1_' & max(Year)))

to get also a working expression if more as one year is selected respectively possible.

Beside this it might be much easier if you transformed your crosstable into a "normal" table-structure per The Crosstable Load.

- Marcus

Re: Item with "variable" name

danosoft — Thu, 05 Apr 2018 14:48:47 GMT

Thanks, this is better becouse i can use it not only in variable, i didn't want create a lot of variable, in this way i can use it directly in my text script.

Thanks