topic Re: Sum IF Help Needed in QlikView

Sum IF Help Needed

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

This is my first post on the Qlik Community so please be gentle.

I'm trying to create an expression to show results if [WTE Contracted]-[WTEBudget] is less than zero.

sum(if([WTE Contracted]-[WTE Budget]<0, [WTE Contracted]-[WTE Budget]))

But it doesn't seem to want to work.

Thanks!

olivetwist — Thu, 13 Jul 2017 15:16:09 GMT

does this work?

If([WTE Contracted]-[WTE Budget]<0, sum([BCUESR.WTE Contracted]-[WTE Budget]))

Anonymous — Thu, 13 Jul 2017 15:21:25 GMT

Unfortunately not, it's coming through as a dash.

vishsaggi — Thu, 13 Jul 2017 15:30:15 GMT

What is your expression for [WTE Budget] ? May be this ? Can you try?

sum(if([WTE Contracted]-(YourActualexpre for Budged)<0, [WTE Contracted]-(YourActualexpre for Budged)))

Anonymous — Thu, 13 Jul 2017 15:40:02 GMT

This expression now pulls through as 0.00:

sum(if([WTE Contracted]-([WTE Budget])<0, [WTE Contracted]-([WTE Budget])))

sunny_talwar — Thu, 13 Jul 2017 15:44:58 GMT

Is WTE Contracted and WTE Budget field names or expression labels?

Anonymous — Thu, 13 Jul 2017 15:50:36 GMT

They are expression labels.

I've got this to work:

sum([WTE Contracted])-[WTE Budget]

But I can't get it to only show results if they are <0.

vishsaggi — Thu, 13 Jul 2017 16:14:53 GMT

What is your expected output? Can you show some data or sample?

Anonymous — Thu, 13 Jul 2017 16:30:20 GMT

This worked for those interested:

=if(sum([WTE Contracted])-[WTE Budget]<0, sum([WTE Contracted])-[WTE Budget])

olivetwist — Thu, 13 Jul 2017 18:40:53 GMT

i forgot the first sum, nice one.