topic Error in Expression in Bar chart in QlikView

Error in Expression in Bar chart

Thu, 16 Jul 2015 10:17:05 GMT

Hi Frnz,

I would like to display Sum of Top 2 Accounts in year wise. Here, in every account has some values(L4AMID_VALUE_USD). I would like to calculate sum of these values and apply Top 2 on these account names. And Finally i want Sum Of Top 2 accounts.

Please find the attached QVW.

Re: Error in Expression in Bar chart

Kushal_Chawda — Thu, 16 Jul 2015 10:22:46 GMT

Try below expression

sum(aggr(if(rank(sum(L4AMID_VALUE_USD),4)<=2,sum(L4AMID_VALUE_USD)),YEAR, L4ACCTNAME))

Re: Error in Expression in Bar chart

sunny_talwar — Thu, 16 Jul 2015 10:23:33 GMT

May be this:

sum(If(Aggr(NODISTINCT Rank(Sum(L4AMID_VALUE_USD)), L4ACCTNAME) <= 2, L4AMID_VALUE_USD))

Re: Error in Expression in Bar chart

MK_QSL — Thu, 16 Jul 2015 10:27:47 GMT

It should be

2015 26

2016 53

2017 50

Re: Error in Expression in Bar chart

Kushal_Chawda — Thu, 16 Jul 2015 10:31:26 GMT

Yes, My expression gives this result

Re: Error in Expression in Bar chart

sunny_talwar — Thu, 16 Jul 2015 10:33:34 GMT

It certainly does

Re: Error in Expression in Bar chart

MK_QSL — Thu, 16 Jul 2015 10:36:58 GMT

I think you are missing YEAR in aggregation

sum(If(Aggr(NODISTINCT Rank(Sum(L4AMID_VALUE_USD)), YEAR, L4ACCTNAME) <= 2, L4AMID_VALUE_USD))

Re: Error in Expression in Bar chart

sunny_talwar — Thu, 16 Jul 2015 10:39:11 GMT

Hahahaha ya that seem to did it Not on top of my game today.

Re: Error in Expression in Bar chart

MK_QSL — Thu, 16 Jul 2015 10:41:27 GMT

Day just started.. Long way to go for you.. Mine already half way

Re: Error in Expression in Bar chart

Thu, 16 Jul 2015 10:48:59 GMT

Hi Frnz,,

Thanks a lot. All have given right expression. It is working..

Re: Error in Expression in Bar chart

sunny_talwar — Thu, 16 Jul 2015 10:51:15 GMT

That's true