topic Re: Using a variable for calculated dimension. in QlikView

Using a variable for calculated dimension.

Thu, 30 Jan 2014 14:49:13 GMT

I am using a variable having multiple values for a calculated dimension in a straight table, but it is showing only one value in the straight table.
variable definition= if(Left([Resume Title],4)=Left([Requirement Title],4),HotListDisplayName,Null())

I get multiple names for this condition but it is showing only one value.

Re: Using a variable for calculated dimension.

Thu, 30 Jan 2014 15:09:20 GMT

Hi,

It seems to me the problem is which variable value should match with which line in straight table. Can this be made as an additional field during load? It would make it a lot easier.

Regards

Re: Using a variable for calculated dimension.

Thu, 30 Jan 2014 15:22:16 GMT

If you really need to use variable in calculated dimension.

Try

variable definition= 'Valuelist(' & chr(39) & concat(distinct if(Left([Resume Title],4)=Left([Requirement Title],4),HotListDisplayName), chr(39) & chr(44) & chr(39)) & chr(39) & ')'

And in the calculated dimension, =$(variable)

That said, your expression will also need to be modified as this calculated dimension is merely a list of value not one of the fields connected to any table.

Re: Using a variable for calculated dimension.

Clever_Anjos — Thu, 30 Jan 2014 15:29:39 GMT

Maybe some combinations does not return values.

Please add a fixed "1" as expression and check if all rows are listed.

Re: Using a variable for calculated dimension.

Thu, 30 Jan 2014 16:11:22 GMT

I tried an additional load statement as follows.

Load if(left([Resume Title],4)=left([Requirement Title],4),HotListDisplayName,null()) as SuitableConsultants;

Before this I have 3 load statements for 3 different tables(Excel files).

In my if condition the fields are coming from different tables.

The field SuitableConsultants is not showing up in select fields.