Aggregated Dimension Calculation Qliksense

supriyabiware — Sat, 16 Nov 2024 17:23:09 GMT

Hi All,

I am trying to get Calculated aggregated Dimension in a chart

I have a below formula, Could someone please help in getting it right? currently its only showing above target attribute and nothing else.

=If(
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Actual),[%Account_ID])
>
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Target),[%Account_ID])

, 'Above Target',

If(
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Actual),[%Account_ID])
=
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Target),[%Account_ID])

,'On Target',

If(
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Actual),[%Account_ID])
<
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Target),[%Account_ID])

,'Below Target',

If(
Aggr(Sum({<Activity_Status={'Submitted'},Is_Target_Account={'Yes'}>}Actual),[%Account_ID])
=0,
'No Calls'

))))

topic Aggregated Dimension Calculation Qliksense in App Development

Aggregated Dimension Calculation Qliksense