topic Resolving a value in an expression in QlikView

Resolving a value in an expression

Thu, 13 May 2010 09:53:50 GMT

Hi All,

I have the following expression a chart:

=Count(''&DrivingTable.TABLE_NAME&'.PKEY')

where for the sake DrivingTable.TABLE_NAME is currently A.

If I add an exp. to Count(A.PKEY) i get 16. Which is correct.

but the exp. Count(''&DrivingTable.TABLE_NAME&'.PKEY') returns 0.

I know I need the DrivingTable.TABLE_NAME to resolve to 'A' before the Count expression but am not having much luck getting there.

Any ideas?

Thanks

Jamie

Resolving a value in an expression

spsrk_84 — Thu, 13 May 2010 10:04:57 GMT

Hi,

Try like this

Count( '' &DrivingTable.TABLE_NAME " &'.PKEY')

I think in your expression u have opened duoble Quotes but u didn't closed them ...

I feel that is the problem ,check it if it is not working we will try some other things.....

Regards,

Ajay

Resolving a value in an expression

Thu, 13 May 2010 10:10:55 GMT

Not sure that's it as:

=''&DrivingTable.TABLE_NAME will return 'A'

Resolving a value in an expression

Thu, 13 May 2010 10:47:00 GMT

This kind of works:

=Sum(FieldValueCount(''&DrivingTable.TABLE_NAME&'.PKEY'))

Resolving a value in an expression

sparur — Thu, 13 May 2010 12:02:01 GMT

Hello, Jamie.

try to set your expression for FiledName to put in variable vFieldName(for example) and set value od this variable as =''&DrivingTable.TABLE_NAME & '.PKEY'

and then calculate your aggregate function: count($(vFieldName))