if then else and variables

[#1]

I have loaded in some Variables into Qlikview using an excell spreadsheet and given the variables a field name of Variable i then want to display the value of the variable in a pivot table

I was thinking of using If (class=Variable,Variable,0)

where the name of the variable is the same as the name of the class then display the value of the variable or else display 0 or no match.

Any advice would be graetly appreciated.

[tresesco]

it seems ok. if it is not working, you might want to check with '$' symbol and quotes appropriations. or else, if you can upload a sample application.

Thanks.

[#3]

if i put the following code

=If (class =Variable,Variable)

Two value are displayed a null value and the name of the variable.

Whereas i want to display the value of the variable. and only show null if they isnt a match

If i use this code =If (class =Variable,Variable,0)

Then both the Variable name and a 0 is displayed.

I will try and get an example Qlikview doc to demonstraight later on today.

Thanks in advance for any help.

[jvitantonio]

Hi, try this:

=if(class = $(variable), class)

[#5]

Hi Qlikuser14

This is giving an error on calculated dimension.

Thanks,

              Iain

[tresesco]

Best way could be - if you can upload the sample application.

Thanks.