How to get same calculated field value (pulled from DB) in a table chart with hard coded value

[varaprasad0816]

Hi Folks,

Please find below mentioned screenshot for your reference.

I have 5 fields which are directly pulled and calculated from DB.

Filter :

SLA Type (Field Values : Uptime, Resolution, Other)

Three Tables :

1. Uptime Results

2. Resolution Results

3. Other Results Table

For Uptime Results table :

I designed a table in Qliksense by pulling these fields directly which are giving proper output.

But I need to do hard coded the filter with SLA Type (Field value: Uptime ) in set analysis by using any one the field.

Tried with below mentioned expression but not givng same results as the direct field gives us.

Count({<SLA Type = {'Uptime'}>}Actual Uptime Perecnt)

I know, this is wrong expression but tried with that one.

we dont want to do any aggregation here, as these are calculated from DB.

Regards,

Vara