Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Yam1
Contributor
Contributor

Totals function in kpi

Hi.

I would like to desplay the automatice table totals function In a kpi

in this pic im calculated the column i would like to sumtotal and present in kpi

if (count({<[Error_Ind]={'1'},[Env]={'AGIRA'}>} Error_Ind )>10000,max({<[Error_Ind]={'1'},[Env]={'AGIRA'}>}  failedkeys ),count({<[Error_Ind]={'1'},[Env]={'AGIRA'}>} Error_Ind ))

How shuld i writh it in the kpi

Is it possible to simply display the automatic totals function shown in the table?

Thanks

20210905_113229.jpg

 
Updating Media
1 Reply
PrashantSangle

what is the error you are getting if you are using same expression in KPI?

try some of the below options might help you

1: Sum(yourexpression)

2: Sum(Aggr(Sum(yourExpression),your_all_dimension_which_present_in_table))

 

Regards,

Prashant

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂