Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

krithikarees
New Contributor

KPI is not same as totals in table

The expression I used to calculate 0 days is

=sum(if ($(vClearing) and num($(vCalendarDate)) - num([Net due date]) <= 0  , [Debit/Credit Amount],0))

when I use the same expression in KPI it gives me a different total.

any help would be appreciated!

3 Replies
hdbucher
New Contributor III

Re: KPI is not same as totals in table

=sum(if ($(vClearing) and num($(vCalendarDate)) - num([Net due date]) <= 0 ....


this is correty and?


maybe this....


=sum(if (num($(vClearing)) = (num($(vCalendarDate)) - num([Net due date])) <= 0 .....


jomar_ebonite
New Contributor III

Re: KPI is not same as totals in table

Sample qvf would help.

Thanks

Re: KPI is not same as totals in table

can you post variable definition?

Just guess I think you required aggr()

Sum(aggr(sum(if ($(vClearing) and num($(vCalendarDate)) - num([Net due date]) <= 0  , [Debit/Credit Amount],0)),YourAllDimensionIncludedInChart)).

Regards,

Regards,
Prashant Sangle
Community Browser