Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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 🙂