topic Re: Aggr in expression HELP in QlikView

Aggr in expression HELP

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

Hi,

I have written a expression, it works when i select 1 month, but when i try to see several months in my table, the numbers go crazy.

Expression:

Sum(Total{<KONTRGRNR={5},SALKONT={3075,3097,3098,3099},LINJETEKST={'Elsert*', 'Påslag*'}>}SUM*'0,8')

((sum({<SALKONT={3091}>}AVRMENGDE) - Sum({<SALKONT={3098,3099},KONTRGRNR-={5}>}AVRMENGDE))

(sum(TOTAL{<SALKONT={3091}>}AVRMENGDE) - Sum(TOTAL{<SALKONT={3098,3099},KONTRGRNR-={5}>}AVRMENGDE))

)

Dimmensions:

%key

KONTGRNAMN

PRICEAREAID

Month

Year

selected Jan, Feb, Mar;

selected Jan, Feb;

Re: Aggr in expression HELP

sunny_talwar — Thu, 21 Sep 2017 08:39:25 GMT

May be you need to use field name with TOTAL qualifier here?

Sum(Total <Month> {<KONTRGRNR={5},SALKONT={3075,3097,3098,3099},LINJETEKST={'Elsert*', 'Påslag*'}>}SUM*'0,8')

((sum({<SALKONT={3091}>}AVRMENGDE) - Sum({<SALKONT={3098,3099},KONTRGRNR-={5}>}AVRMENGDE))

(sum(TOTAL <Month> {<SALKONT={3091}>}AVRMENGDE) - Sum(TOTAL <Month> {<SALKONT={3098,3099},KONTRGRNR-={5}>}AVRMENGDE))

)

Re: Aggr in expression HELP

Anonymous — Thu, 21 Sep 2017 08:45:38 GMT

Hi, thanks for reply

I have now tried with <Month> but then all the collums become 0.

Any other suggestions?

Re: Aggr in expression HELP

Anonymous — Thu, 21 Sep 2017 08:48:31 GMT

Thanks, i also wrapped the expression in aggr. Then it worked, thanks so much !

Re: Aggr in expression HELP

sunny_talwar — Thu, 21 Sep 2017 08:48:36 GMT

This might be a stupid question, but did you use the word Month or Maned? You have to use the month field name that is in your dashboard... I hope you used Maned as it appears that is the name of your month field