topic Re: Expression help in QlikView

Expression help

Fri, 11 Dec 2015 14:02:10 GMT

HI All

i want sum the Sales for year = 2015 only

i don't have an year field only month Year field

like this

Jan 2015

Feb 2015

Mar 2015

Apr 2015

i want to fit this month year field into this expression

sum({1<[Year] = {'2015'}>}Sales)

Please Suggest

Re: Expression help

Mark_Little — Fri, 11 Dec 2015 14:04:09 GMT

HI,

Add it to your script.

Right(Date,4) as Year

The you can use in the expression.

Mark

Re: Expression help

sunny_talwar — Fri, 11 Dec 2015 14:05:51 GMT

Try this:

Sum({1<MonthYear = {"$(='>=' & MonthName(YearStart(Max(MonthYear))) & '<=' & MonthName(Max(MonthYear)))"}>}Sales)

Where MonthYear is created in the script using MonthName() function.

Re: Expression help

Fri, 11 Dec 2015 14:06:11 GMT

HI Mark

sorry For not mentioning

I want this to done on the table

I dont want this change in script

Re: Expression help

roger_stone — Fri, 11 Dec 2015 14:45:22 GMT

You can try this, it doesn't need to be in the script:

=SUM(IF (RIGHT(Year,4)='2015',Sales))

Re: Expression help

sivarajs — Fri, 11 Dec 2015 15:06:02 GMT

Do Subfield(MonthYear,' ',2) as Year in load then use the sum expression

Re: Expression help

roger_stone — Fri, 11 Dec 2015 15:09:54 GMT

The original poster has already said it can't be in the script.

Re: Expression help

settu_periasamy — Fri, 11 Dec 2015 15:16:37 GMT

May be this

=Sum ({1<MonthYearField={"*2015"}>}Sales)

Re: Expression help

thakkarrahul01 — Fri, 11 Dec 2015 15:23:52 GMT

Hi John,

you may find this link helpful.

Range of month in a bar chart