Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
varaprasad0816
Creator II
Creator II

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

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.

 

 

Hard Coded Value in a Table.JPG

 

Regards,

Vara

Labels (1)
0 Replies