Qlik Community

Third-Party Qlik Jobs

Area for people to learn more about current Qlik related job postings.

Highlighted
DrS
New Contributor

data not showing but formula is correct

Hi i have just put my calculation sum(Amount1) for Gross Premium(GWP), the fomula is correct but it is not showing the data for some reason, when i use filters to select data it sometimes appears during filtering and once i cancel the filter it goes back to Zero.

image.pngGross premium(GWP) has the issues

3 Replies
salonibhatia
New Contributor III

Re: data not showing but formula is correct

hey .. can u share the dashboard?? looks like something wrong with data in backend
Partner
Partner

Re: data not showing but formula is correct

try Aggr() function

ex- Aggr(sum(Amount1),Name)

jyothish8807
Honored Contributor II

Re: data not showing but formula is correct

Hi Drs,

Try this both:

Sum(Total <Name> Sales)

You can add, remove the fields to which it can grouped.

or

if(Sales >=0,Sum(Sale))

Also i recommend to removed the screenshot of your dashboard as it displays a lot of information's about your client, which could be critical.

Best Regards,
KC