topic Re: if then else and variables in QlikView

if then else and variables

Wed, 29 May 2013 10:18:08 GMT

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.

Re: if then else and variables

tresB — Wed, 29 May 2013 11:23:30 GMT

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.

Re: if then else and variables

Wed, 29 May 2013 12:53:45 GMT

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.

Re: if then else and variables

jvitantonio — Wed, 29 May 2013 13:01:21 GMT

Hi, try this:

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

Re: if then else and variables

Wed, 29 May 2013 13:08:48 GMT

Hi Qlikuser14

This is giving an error on calculated dimension.

Thanks,

Iain

Re: if then else and variables

tresB — Wed, 29 May 2013 13:25:35 GMT

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

Thanks.