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

varaprasad0816 — Sat, 16 Nov 2024 04:17:36 GMT

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

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