Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Resolving a value in an expression

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

4 Replies
spsrk_84
Creator III
Creator III

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

Not applicable
Author

Not sure that's it as:

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

Not applicable
Author

This kind of works:

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

sparur
Specialist II
Specialist II

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))