topic Re: Same Formula not working in Bar Chart and #1KPI in QlikView

Same Formula not working in Bar Chart and #1KPI

vikas_nandanwar — Thu, 30 Nov 2017 04:12:37 GMT

Hi,,

I am using below formula in bar chart and #1KPI -

if([Sales/AOP]='Sales', Sum([Cts]),0)

My Bar Chart gives me correct representation while #1KPI gives me 0

Why??

Thanks,

Vikas

luismadriz — Thu, 30 Nov 2017 04:21:33 GMT

Hi,

Please review this one: It’s all Aggregations

You could use this: Sum({<[Sales/AOP]={"Sales"}>} [Cts])

I hope this helps,

Cheers,

Luis

vikas_nandanwar — Thu, 30 Nov 2017 04:39:36 GMT

Thanks,

this worked

Vikas